- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 05-06-2011 03:24 PM
(3452 views)
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!
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!
- Tags:
- transpose
- transposing
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.