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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.