change numeric into character output in a proc frecq

[dennisl]

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

[ballardw]

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;

[art297 · Accepted solution]

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?