cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
hogi
Level XI

Multiple Response - unique values

For a column with modeling type multiple response, is there a command in JSL to get the unique values?

Or do I have to generate it manually?

Open( "/C:/Program Files/SAS/JMP/17/Samples/Data/Big Class Families.jmp" );
unique_values=Associative Array(Words(Concat Items(:sports << get values() ,","),", ")) << get keys;

 

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: Multiple Response - unique values

Not sure if there are any functions to get them directly, but you could get them from Distribution platform for example

Names Default To Here(1);

dt = Open("$SAMPLE_DATA/Consumer Preferences.jmp");

dist = Distribution(Multiple Response Distribution(Column(:Floss Delimited)), invisible);
vals = Report(dist)[OutlineBox("Frequencies"), StringColBox("Level")] << get;
dist << Close Window;

show(vals); // vals = {"After Meal", "Before Sleep", "Other", "Wake"};

This won't catch missing values and it will have to be checked separately from the report.

-Jarmo

View solution in original post

1 REPLY 1
jthi
Super User

Re: Multiple Response - unique values

Not sure if there are any functions to get them directly, but you could get them from Distribution platform for example

Names Default To Here(1);

dt = Open("$SAMPLE_DATA/Consumer Preferences.jmp");

dist = Distribution(Multiple Response Distribution(Column(:Floss Delimited)), invisible);
vals = Report(dist)[OutlineBox("Frequencies"), StringColBox("Level")] << get;
dist << Close Window;

show(vals); // vals = {"After Meal", "Before Sleep", "Other", "Wake"};

This won't catch missing values and it will have to be checked separately from the report.

-Jarmo