topic Why "others" (proc format) does not work here? in SAS Procedures

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

TomiKong — Fri, 14 Dec 2012 09:05:13 GMT

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;

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

kuridisanjeev — Fri, 14 Dec 2012 09:20:54 GMT

Hi Tomiking...

Small correction in your code...

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

Thanks & Regards

Sanjeev.K

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

kuridisanjeev — Fri, 14 Dec 2012 09:25:08 GMT

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

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

TomiKong — Fri, 14 Dec 2012 09:30:19 GMT

Got it. Thanks.