topic Re: assign "Yes" "No" to variables. in SAS Procedures

assign "Yes" "No" to variables.

Ken_oy — Fri, 06 May 2011 19:24:11 GMT

I have several binary variables (1, 2). I tried to label them all to "Yes, No".
Is there any easier way to do this? I remember I used "format" statement before, but cannot recall how i did that. Don't want to use "if then" statement, too many variables.
Any help? thanks!

Re: assign "Yes" "No" to variables.

SPR — Fri, 06 May 2011 20:21:02 GMT

Hello Ken_oy,

This is a solution:
[pre]
data a;
bin=1; output;
bin=2; output;
bin=.; output;
run;
proc format;
value bin
1= "Yes"
2= "No "
other="Unk";
run;
proc print data=a;
format bin bin.;
run;
[/pre]
Sincerely,
SPR

Re: assign "Yes" "No" to variables.

ballardw — Fri, 06 May 2011 20:48:30 GMT

Hint: If you want to have the format available all the time put it in a permanent library by adding the LIBRARY= option to the PROC step. Reference e that library in the format search path using the FMTSEARCH system option or other tool.