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;
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.