Hi there,
Below is my program:
data hosp_proc12a;
merge hosp12 (in=a) procd;
by record_id;
if a;
if procedure_no=. then procedure_no=0;
else if 5 <= procudure_no <=9 then procudure_no =5;
else if procudure_no >=10 then procudure_no=10;
keep record_id indig procedure_no age_grp;
run ;
For missing value, I can get a 0. but for other values, there is no change at all. I still have values like 8, 11, 13, 18 in there.
I tried to to define a new variable:
data hosp_proc12a;
merge hosp12 (in=a) procd;
by record_id;
if a;
if procedure_no=. then procd_no=0;
else if 1 <= procudure_no <=4 then procd_no =procudure_no ;
else if 5 <= procudure_no <=9 then procd_no =5;
else if procudure_no >=10 then procud_no=10;
keep record_id indig procedure_no age_grp;
run ;
But this time I can only get procd_no=0 when procedure_no is missing and procd_no is missing when procedure_no take other values.
Why this can happen? WHat I need to do?
Qinghe
It is just typo in your code decide is it "procedure_no" or "procudure_no"?
let them all be the same then you will not get the same issue
Replace procudure_no with procedure_no. Seems like a spelling mistake.
data hosp_proc12a;
merge hosp12 (in=a) procd;
by record_id;
if a;
if procedure_no=. then procedure_no=0;
else if 5 <= procudure_no <=9 then procudure_no =5;
else if procudure_no >=10 then procudure_no=10;
keep record_id indig procedure_no age_grp;
run ;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.