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

See the title and the attached file. How do I write the SAS code to create variable 3? I am not very experienced with SAS, so any help would be greatly appreciated. Thank you!

Edit- Thank you Bruno, that worked perfectly!

1 ACCEPTED SOLUTION

Accepted Solutions
BrunoMueller
SAS Super FREQ

Hi

Assuming the input data is sorted by var_1, then the following code should do what you want:

data want;
  set have;
  by Var_1;
  if first.var_1 = 1 then do;
   
retain checkForA;
    checkForA = 1;
 
end;
 
if checkForA = 1 and var_2 = "A" then do;
    var_3_sas =
1;
    checkForA =
0;
 
end;
  var_3_sas = coalesce(var_3_sas,
0);
run;

View solution in original post

1 REPLY 1
BrunoMueller
SAS Super FREQ

Hi

Assuming the input data is sorted by var_1, then the following code should do what you want:

data want;
  set have;
  by Var_1;
  if first.var_1 = 1 then do;
   
retain checkForA;
    checkForA = 1;
 
end;
 
if checkForA = 1 and var_2 = "A" then do;
    var_3_sas =
1;
    checkForA =
0;
 
end;
  var_3_sas = coalesce(var_3_sas,
0);
run;

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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