Hi Everyone!
I am new to SAS but I am trying to create a program but Im not getting any output, which tells me I'm doing something wrong. I have two data sets and I want to subset the data and find only the transactions that ...for the variable 'X' starts with 4. Here is what I tried...
Data trans_data;
SET fy.13transdata;
WHERE substr (X, 1,4) = '4';
run;
Im confused as to how I should structure my where statement. Can someone help?
Thx!
EP
WHERE substr (X, 1,4) = '4';
What would you expect the 4 in the substr function to do?
I think it should be 1,
WHERE substr (X, 1,1) = '4';
Try reading the documentation on Substr again:
WHERE substr (X, 1,4) = '4';
What would you expect the 4 in the substr function to do?
I think it should be 1,
WHERE substr (X, 1,1) = '4';
Try reading the documentation on Substr again:
Thanks I saw that link I thought the 4 represents how many characters? But I believe it means the number of characters Sas should read. Thx agn!
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.