topic Formats in SAS Programming

Formats

robertrao — Tue, 15 Sep 2015 08:47:51 GMT

Hello,

I have the following code. In the gender dataset created Sex variable is still being outputted as 1 or 2 instead of being Male /Female.

genderkey is a charecter variable

Please suggest me if i went wrong?

data test1(rename=(genderkey=start name=label));

set gender_dataset(keep=genderkey name);

fmtname='genderfmt';

run;

proc format cntlin=test1;run;

START LABEL FMTNAME

1 Female genderfmt

2 Male genderfmt

data gender;

set have;

Sex=put(genderkey,genderfmt.);

run;

Re: Formats

RW9 — Tue, 15 Sep 2015 11:51:48 GMT

Hi,

I assume from what you have given that SEX is numeric, hence it will not map to the character format created by the read in. In test 1, convert genderkey to a number then it will create a number when read in as format. Currently 1 != "1". What you want is something like:

proc format;
value genderfmt
1="Female"
2="Male";
run;

data gender;
genderkey=1;
Sex=put(genderkey,genderfmt.);
run;

Re: Formats

PGStats — Tue, 15 Sep 2015 15:28:38 GMT

Try

data test1;
set gender_dataset;
start = input(genderkey, best.);
label = name;
fmtname = 'genderfmt';
keep start label fmtname;
run;

proc format cntlin=test1; run;
 
data gender;
set have;
Sex = put(genderkey, genderfmt.);
run;