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' ;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.