Hi SAS-users,
is it possible to label the numeric values of a variable with a name, which appears in the output of the proc frecq. The labels should replace the entries of the variable's numeric values, whereas each value has a different label.
Best,
Dennis
I think you only need to create and apply a format. Take a look at:
SAS FAQ: How can I change the way variables are displayed in proc freq?
Yes, the answer is proc format.
proc format;
value yesno
1= 'Yes'
2= 'No'
;
run;
/* NOTE: any number not assigned a value will still appear as it self, you can aslo assign ranges of numbers to
a text to be displayed */
data junk;
do i = 1 to 10;
x=1;
output;
end;
do i=1 to 5;
x=2;
output;
end;
run;
Proc freq data=junk;
tables x;
format x yesno.;
run;
I think you only need to create and apply a format. Take a look at:
SAS FAQ: How can I change the way variables are displayed in proc freq?
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.