topic Re: Modify a value in the data step with same variable name in SAS Procedures

Modify a value in the data step with same variable name

Ying — Fri, 20 Dec 2013 17:55:34 GMT

Happy Holidays!

Could you please explain why the value TYPE after the modification couldn’t give correct answer? The correct answer should be like this but the code didn't give this. Why? Thank you!

Type Frequency

. 1

3 1

5 4

data lk;
input id type;
datalines;
1 1
2 2
3 3
;
run;
data test;
input id;
datalines;
1
1
2
2
3
4
;
run;

data test1;
merge test(in=in1) lk;
by id;
if in1;

if type in (1,2) then type=5;
else if type ^= 3 then type=.;
run;
proc freq data=test1; tables type/list missing; run;

Re: Modify a value in the data step with same variable name

art297 — Fri, 20 Dec 2013 18:19:02 GMT

You are retaining the modified value. It will do as you expect if you use:

data test1 (drop=_type);

merge test(in=in1) lk (rename=(type=_type));

by id;

if in1;

if _type in (1,2) then type=5;

else if _type ^= 3 then type=.;

else type=3;

run;

Re: Modify a value in the data step with same variable name

Jagadishkatam — Fri, 20 Dec 2013 18:20:04 GMT

You have used type instead of id in the if condition.

data test1;
merge test(in=in1) lk;
by id;
if in1;

if id in (1,2) then type=5;

else if id ^= 3 then type=.;

run;

proc freq data=test1; tables type/list missing; run;

Please used the above code to get the desired result.

Thanks,

Jag

Re: Modify a value in the data step with same variable name

Ying — Fri, 20 Dec 2013 20:09:19 GMT

Thank you! It should be the reason.