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!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.