topic Re: SAS query in SAS Programming

SAS query

rakeshvvv — Thu, 09 Jun 2016 14:51:32 GMT

Dear All,

I have dataset with the one variable X. I would like to write a query to exclude the first numerical, special character part and start reading from the first occurrence of the alphabet.

10 - SEASONAL ALLERGIES - UN/UNK/1954

3333 ** COMMON COLD - 10/JAN/2015

222 ### RECURRENT SINUSITIS - UN/UNK/2003

44444 @@ INSOMNIA - UN/UNK/2008

The output should look like this.

SEASONAL ALLERGIES - UN/UNK/1954

COMMON COLD - 10/JAN/2015

RECURRENT SINUSITIS - UN/UNK/2003

INSOMNIA - UN/UNK/2008

Thanks in advance

Rakesh

Re: SAS query

Tom — Thu, 09 Jun 2016 15:00:23 GMT

You could use the VERIFY() function.

data have;
  input x $60.;
cards4;
10 - SEASONAL ALLERGIES - UN/UNK/1954
3333 ** COMMON COLD - 10/JAN/2015
222 ### RECURRENT SINUSITIS - UN/UNK/2003
44444 @@ INSOMNIA - UN/UNK/2008
;;;;

data want ;
 set have ;
 x=substr(x,max(1,verify(x,'012345678 -+*#@')));
run;

Re: SAS query

RW9 — Thu, 09 Jun 2016 15:09:27 GMT

You could also substr from the first occurence of an alphabetic character:

new_var=substr(findc(old_var,"","a"));

This will substring from first alpha character to the end.

Re: SAS query

Ksharp — Fri, 10 Jun 2016 04:37:14 GMT

I don't like Tom's code .



data have;
  input x $60.;
cards4;
10 - SEASONAL ALLERGIES - UN/UNK/1954
3333 ** COMMON COLD - 10/JAN/2015
222 ### RECURRENT SINUSITIS - UN/UNK/2003
44444 @@ INSOMNIA - UN/UNK/2008
;;;;


data want ;
 set have ;
 x=substr(x,max(1,verify(x,'012345678 -+*#@')));
 me=substr(x,prxmatch('/[a-z]/i',x));
run;