I have A (numeric variable).
I don't all records where A start with 111.
How do I write the code?
Thank you
HI apple,
Hope the below code is what you are looking for.
x=cats('111',variable_name);
put x=;
if the above code does not work please convert the numeric variable to char by using put() ...
EX:
y=put(variable_name,8.);
x=cats('111',y);
put x=;
Thank You
If you want to select any record which does not begin with '111' then use the folling code;
Data want;
set have;
y=put(a,8.);
z=substr(y,1,3);
if z="111" then delete;
run;
HI Try this,
If a is char:
data test;
input a $;
if a ^=: '111';
cards;
11122
12222
11111
31222
;
If a is numeric:
data test;
input a;
if cats(a) ^=: '111';
cards;
11122
12222
11111
31222
;
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.