Input:
21
22
21
21
23
22
21
21
22
23
22
Needed ouput:
distinct times
21 5
22 4
23 2
Getting the total should be just for reporting purposes and not part of the data itself. One way:
proc freq data=have;
tables distinct / noprint out=counts (keep=distinct count rename=(count=times));
run;
proc print data=counts;
var distinct times;
sum times;
run;
data test;
input var;
datalines;
21
22
21
21
23
22
21
21
22
23
22
;run;
1) proc freq data=test; table var; run;
2) proc means data=test;
class;
var var;
output out=test1 N=;
run;
I haven't run it so check it carefully.
Getting the total should be just for reporting purposes and not part of the data itself. One way:
proc freq data=have;
tables distinct / noprint out=counts (keep=distinct count rename=(count=times));
run;
proc print data=counts;
var distinct times;
sum times;
run;
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.