I have a variable which has possible values of 1Y 2Y 3Y 4Y 5Y U <missing>
I'm creating a new variable in a data step, like this:
data want;
set have;
if var1 In('3Y','4Y','5Y') then newvar=1; else if var1=. THEN newvar=.; ELSE newvar=0;
run;
My problem is that the newvar becomes missing when in fact the original value was 1Y or 2Y. But the newvar seems to actually be correct in the instance of it being in the IN() list.
I get no errors, but I get a warning:
Limit set by ERRORS=option reached. Further errors of this type will not be printed
(makes no sense, because I'm not getting errors)
I get a note for just about every row -
Invalid numeric data, VAR1='1Y', at line xxxx column yyyy
So - what in the world am I doing wrong that allows this to partially work? It works in the first list but apparently on the ELSE I am getting this weird note.
Try this.
data want;
set have;
if var1 In('3Y','4Y','5Y') then newvar=1;
else if var1=' ' THEN newvar=.;
ELSE newvar=0;
run;
Try this.
data want;
set have;
if var1 In('3Y','4Y','5Y') then newvar=1;
else if var1=' ' THEN newvar=.;
ELSE newvar=0;
run;
that worked! Thanks
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.