topic Re: DELETE or SELECT TEXT BEGINNING WITH SAME CHARACTER in SAS Procedures

DELETE or SELECT TEXT BEGINNING WITH SAME CHARACTER

Statsconsultancy — Fri, 07 Jan 2011 10:16:22 GMT

I will like to select disease with codes beginning with B2 or C2. Is it possible to use logical operations here. I tried the following, but it did not work

data new;
set lib.data;
where disease like 'B2%' or where disease like 'C2%';
run;

I want to select patients with disease codes B2*** or C2***. Can anyone help.

Re: DELETE or SELECT TEXT BEGINNING WITH SAME CHARACTER

jklaverstijn — Fri, 07 Jan 2011 10:40:49 GMT

This should work, you just have the syntax not entirely correct. Ommit the repetition of WHERE:

where disease like 'B2%' or disease like 'C2%';

That should do it. Basic SQL, nothing SAS here.

Good luck, Jan.

Re: DELETE or SELECT TEXT BEGINNING WITH SAME CHARACTER

art297 — Fri, 07 Jan 2011 13:44:31 GMT

Works in data step. Nothing SQL here!

Is it Friday yet?
Art

Re: DELETE or SELECT TEXT BEGINNING WITH SAME CHARACTER

advoss — Fri, 07 Jan 2011 16:22:05 GMT

You could also do:

data new;
set lib.data;
where disease IN: ('B2','C2'); /* note the colon on the IN, just matches on 1st chars*/
run;