=;

[GeorgeSAS]

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_null__]

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

[Babloo]

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;

[Ksharp]

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

[Jagadishkatam]

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