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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.