First post and I'm a beginner in SAS.
Looking to count the variables in a table. I have them grouped or sorted. Below is my example:
Table_1
ITEM
red
blue
blue
yellow
yellow
yellow
Expected outcome in new table (Table_2) or appended to Table_1:
ITEM COUNT
red 1
blue 2
yellow 3
How can I get Table_1 as above or a new Table_2 with the outcome?
Thanks - Adam
Figured it out:
proc freq data = Table_1 order = freq NOPRINT;
tables Item / nocum nopercent out = Table_2 (drop=percent);
run;
Thanks for your help ballardw!
Easiest is likely proc freq:
proc freq data=have;
tables item;
run;
to generate a data set add an output data set instruction
proc freq data=have;
tables item/ out=item_count;
run;
the data set Item_count will also have a percent you could remove by adding (drop=percent) after the dataset name.
I'm sorry, I'm really new to this. How would the suggested code be exactly with Table_1 and Item (my table name and the variable)?
Thanks - Adam
Figured it out:
proc freq data = Table_1 order = freq NOPRINT;
tables Item / nocum nopercent out = Table_2 (drop=percent);
run;
Thanks for your help ballardw!
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.