topic Re: change numeric into character output in a proc frecq in SAS Programming

change numeric into character output in a proc frecq

dennisl — Wed, 27 Mar 2013 20:50:54 GMT

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

Re: change numeric into character output in a proc frecq

ballardw — Wed, 27 Mar 2013 21:38:47 GMT

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;

Re: change numeric into character output in a proc frecq

art297 — Wed, 27 Mar 2013 21:39:04 GMT

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?