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

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

mostarr — Sat, 10 Jun 2023 23:29:34 GMT

Assuming I am familiar with programming languages in general, but not the syntax of JMP/JSL specifically, please understand that when I looked up and 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

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

jthi — Fri, 30 Apr 2021 17:13:39 GMT

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)

2. Scripting Guide

3. JMP Help, Scripting Guide

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

mostarr — Fri, 30 Apr 2021 17:43:51 GMT

Where will uniqNames be shown?

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

jthi — Fri, 30 Apr 2021 17:50:21 GMT

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)

mostarr — Fri, 30 Apr 2021 17:58:37 GMT

Thanks, that works perfectly.