Hi All,
I have the follwoing dataset and I want to retrieve the observations where variable CODE has 3 or 4 in its fourth position. can someone write the code for me please. Thanks.
data have;
input ID CODE$ 7.;
cards;
101 BIO4MU
101 ENG3NO
102 PHY2L
102 LOS1KO
103 HUM3P
;
RUN
Expected Output
ID CODE
101 BIO4MU
101 ENG3NO
103 HUM3P
Look at the SUBSTR function.
if char(code,4) in ("3","4");
Use length(var1) to find the length of a variable and the corresponding last character
or use Reverse function and take the first character.
IF char(var1, 6) = "C" and length(var1) = 6;
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.