Hello everyone,
I have two questions:
Thanks!
1.
How to use string function to find the first none 'x' letter?
data have;
value='xxasdxfg';output;
value='xxxxqwerxxt';output;
run;
data need;
value
asdxfg
qwerxxt
2.
how to use string function keep the last N digit?
x='123456789';
data want;
set have;
x2=substr(x,-4); /*I need x2=6789,the last four digits of x*/
hi ...
new = substr(value,verify(value,'x'));
x = '123456789';
x2 = substr(x,length(x)-3);
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Register now!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for:
View all other training opportunities.