Why "others" (proc format) does not work here?

[TomiKong]

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;

[kuridisanjeev]

Hi Tomiking...

Small correction in your code...

Just write "OTHER" instead of "OTHERS".....:-)

Thanks & Regards

Sanjeev.K

[kuridisanjeev · Accepted solution]

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

[TomiKong]

Got it. Thanks.