topic Re: =; in SAS Procedures

=;

GeorgeSAS — Fri, 10 Apr 2015 14:29:20 GMT

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

Re: =;

data_null__ — Fri, 10 Apr 2015 14:40:54 GMT

data test;
   set test;
   if name =: 'D' or char(name,2) eq 'o' or char(name,length(name)) eq 'y'; 
   run;

Re: =;

Babloo — Fri, 10 Apr 2015 14:47:47 GMT

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;

Re: =;

Ksharp — Sat, 11 Apr 2015 07:28:17 GMT

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

Re: =;

Jagadishkatam — Sat, 11 Apr 2015 07:51:27 GMT

data test;
   set test;
  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' ;
run;

Thanks,
Jag