DATA Step, Macro, Functions and more

change numeric into character output in a proc frecq

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 10
Accepted Solution

change numeric into character output in a proc frecq

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


Accepted Solutions
Solution
‎03-27-2013 05:39 PM
PROC Star
Posts: 7,487

Re: change numeric into character output in a proc frecq

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?

View solution in original post


All Replies
Super User
Posts: 11,343

Re: change numeric into character output in a proc frecq

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;

Solution
‎03-27-2013 05:39 PM
PROC Star
Posts: 7,487

Re: change numeric into character output in a proc frecq

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?

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 172 views
  • 2 likes
  • 3 in conversation