nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

381364_en-US

liliconcom

How to Identify Unique Values in a Column from a Data Table (to a Scripting Newbie)

Assuming I am familiar with programming languages in general, but not the syntax of JMP/JSL specifically, please understand that when I looked up JSL: get unique values of a data table column and Get a list of the unique values in a column, matrix, or list none of the solutions worked for me when I try to find a summary of the unique values in a column scriptorially (not via Recode). The reason for doing it scriptorially is I would like to feed the output to other input funnels in another portion of the script.

Here is my code (anonymized and hopefully without typos):

dt = Open( "data file" );
//show(summarize(dt=by("column of interest")));
//dt << Summary(Group(:column of interest), Freq("None"), Weight("None"));

The lines which are commented out do not seem to work for me. I don't even know if I am importing the data correctly, to be honest. "data file" is a .jmp file. How would I know? Would it open up? It doesn't seem to be doing that.

Pardon if this is a double post but I really appreciate the understanding.

Thank you,

Michael

Data Access

Data Blending and Cleanup

Re: How to Identify Unique Values in a Column from a Data Table (to a Scripting Newbie)

Thanks, that works perfectly.

Re: How to Identify Unique Values in a Column from a Data Table (to a Scripting Newbie)

From Scripting Index:

With Summarize the results are saved in variables with the names specified.

You can see them in Log window: View/Log (Ctrl+Shift+L shortcut) or right click on script editor and enable Show Embedded Log (I suggest enabling this from preferences to be shown always).

Embedded log:

Re: How to Identify Unique Values in a Column from a Data Table (to a Scripting Newbie)

Where will uniqNames be shown?

Re: How to Identify Unique Values in a Column from a Data Table (to a Scripting Newbie)

Here is at least two ways to get unique values; Summarize and Associative Array with get keys:

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
Summarize(dt, uniqNames = by(:name));
Show(uniqNames);

aa_uniqNames = Associative Array(Column(dt, "name")) << Get keys;
show(aa_uniqNames);

Also take a look at the following sources for scripting:

1. Directly from JMP take a look under Help/Scripting Index (search for Summarize for example)