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

DELETE or SELECT TEXT BEGINNING WITH SAME CHARACTER

Statsconsultancy — Thu, 06 Jan 2011 14:08:00 GMT

I have a variable by the name DiseaseCode. How can I select any code that begins with B2.

That is I want to select anything of the form B2**. It can be B23, B2K, B2SKH.

Can someone help.

Re: DELETE or SELECT TEXT BEGINNING WITH SAME CHARACTER

Cynthia_sas — Thu, 06 Jan 2011 14:33:55 GMT

Hi:
Look at the WHERE statement documentation and the LIKE operator:
http://support.sas.com/documentation/cdl/en/lrdict/63026/HTML/default/viewer.htm#a000202951.htm

For example, you could do:
[pre]
proc print data=lib.data;
where disease like 'B2%';
run;

or,

data new;
set lib.data;
where disease like 'B2%';
run;
[/pre]

For the LIKE operator, the _ (underscore) is the wild card character for 1 character and the % (percent) is the wild card character for multiple characters. So, for example, LIKE 'B2_' would find a value that started with B2 and had any 3rd character, while LIKE 'B2%' would find B2X, B2XYZ or B2ABCDEFG.

cynthia

Re: DELETE or SELECT TEXT BEGINNING WITH SAME CHARACTER

LAP — Thu, 06 Jan 2011 15:58:03 GMT

You can also use a colon modifier to select codes that "Begin With". However, I believe that this method is limited to an "IF" statement.

see http://support.sas.com/kb/24/851.html

(Sample 24851: Using a Colon Modifier to Select Observations with Values Beginning with a Specific Character By Kirk Paul Lafler)

for more information.