BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
dennisl
Calcite | Level 5

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

1 ACCEPTED SOLUTION

Accepted Solutions
Haikuo
Onyx | Level 15

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

View solution in original post

1 REPLY 1
Haikuo
Onyx | Level 15

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

sas-innovate-2024.png

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.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 654 views
  • 0 likes
  • 2 in conversation