Hi guys,
I want to reformat my data. If gender="M", I'll reformat it as 1.if others, I'll reformat it as 0. I wrote the codes as below. But it didn't work as expected. Did I use "others" wrongly? Thanks.
Tomi
proc format;
value $gender "M"=1
others=0;
data have;
input gender $ @@;
datalines;
F M M G R T
;
run;
data want;
set have;
format gender $gender.;
run;
And you can apply your format in first data step also.
Don't required second data step..
proc format;
value $gender "M"=1
OTHER=0;
data have;
input gender $ @@;
format gender $Gernder.;
datalines;
F M M G R T
;
run;
Thanks..
Sanjeev.K
Hi Tomiking...
Small correction in your code...
Just write "OTHER" instead of "OTHERS".....:-)
Thanks & Regards
Sanjeev.K
And you can apply your format in first data step also.
Don't required second data step..
proc format;
value $gender "M"=1
OTHER=0;
data have;
input gender $ @@;
format gender $Gernder.;
datalines;
F M M G R T
;
run;
Thanks..
Sanjeev.K
Got it. Thanks.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.