- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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