topic Re: Apllying format while using if then else.... in SAS Programming

Apllying format while using if then else....

Chrishi — Mon, 25 Aug 2014 06:27:43 GMT

I have a dataset which contain gender variable which might be given in numeric(0/1) or character(Female/Male). If i get the data in numeric i have to apply format created by me as female or male, if given in character keep it as it is so i was apllyig format using if then else its not working any suggestion on this.

proc format;

value sex 0='Female'1='Male';

run;

data have;

input gender;

cards;

;

run;

data have1;

input gender$;

cards;

Female

Male

;

run;

data want;

set have;

if anydigit(gender) ge 1 then
gender1=put(gender,sex.);

else gender1=gender;

run;

data want1;

set have1;

if anydigit(gender) lt 1 then
gender1=put(gender,sex.);

else gender1=gender;

run;

The problem arises when the data is given in character and i dont know wheather the given data is char or numeric before hand.

Thanks

Re: Apllying format while using if then else....

Imroze — Mon, 25 Aug 2014 06:43:43 GMT

Please try the below code... hope it helps....

proc format;

value $sex 0='Female'

1='Male'

other='unknown';

run;

data have;

length gender $8.;

input gender $;

cards;

Female

Male

;

run;

data want;

set have;

if anydigit(gender) ge 1 then
gender1=put(gender,$sex.);

else gender1=gender;

run;

Re: Apllying format while using if then else....

Chrishi — Mon, 25 Aug 2014 06:51:29 GMT

Ya missed out on $ before the format creation thanks.