Dear SAS Users.
perhaps you can provide me with an elegant way to solve the following issue:
My data set contains a set of variables named fab* where * is a number from 1 to 60. The variables contain a four digit code. I want to create a dummer variable fabid. It should have the value 1 if the two first digits equal 02 in one of the values of the 60 fab* variables for one observation. Is there a quick way to avoid writing an if condition without refering to all 60 variables' names?
Best,
Dennis
Array() is your friend:
data want;
set have;
array test $4. fab1-fab60;
do over test;
if test=:'02' then new_var=1;
end;
run;
Haikuo
Array() is your friend:
data want;
set have;
array test $4. fab1-fab60;
do over test;
if test=:'02' then new_var=1;
end;
run;
Haikuo
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.