Hello everyone,
If i want keep name start with 'D'. the code below works,but how if I want keep the name end with "y"?or second letter is "o"? Is there any similar operator like "=: "to do this in data step?(data step only)
data test;
input name $;
cards;
John
Diana
Diane
Sally
Doug
David
;
run;
data test;
set test;
if name =: 'D';
run;
proc print;
run;
Thanks
data test;
input name $;
cards;
John
Diana
Diane
Sally
Doug
David
;
run;
proc sql;
create table want as select * from test where name like '%y' or name like '%o%' ;
quit;
proc print;
run;
data test; input name $; cards; John Diana Diane Sally Doug David ; run; data want; set test; if prxmatch('/^D|^[a-z]o|y$/i',strip(name)); run;
Xia Keshan
Message was edited by: xia keshan
if substr(compress(lowcase(name)),2,1)='o' or substr(compress(lowcase(name)),length(name),1)='y' or
substr(compress(lowcase(name)),1,1)='d' ;
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.
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.