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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.