topic Selecting Zipcodes starting with a character symbol in SAS Programming

Selecting Zipcodes starting with a character symbol

MinalMMurkhande — Wed, 02 Apr 2014 06:00:57 GMT

Hi ,

I need to filter out data in the "ZIP" column of a data set. It has few values which start with a character variable (A-Z). How can I filter them in a dataset of 1000000 rows. Column "ZIP" is a categorical variable.

I did try this approach but there seems something to be wrong :

proc sql;

delete * from dataset where zip = '^[A-Z]';

quit;

The log says no rows are selected. Please advice !

Thanks ,

Minal

Re: Selecting Zipcodes starting with a character symbol

UrvishShah — Wed, 02 Apr 2014 06:14:37 GMT

proc sql;

select *

from have

where anayalpha(ZIP);

quit;

Re: Selecting Zipcodes starting with a character symbol

MinalMMurkhande — Wed, 02 Apr 2014 06:30:31 GMT

Thanks for the reply. But on running the code I get the following error :

23 proc sql;

24 select *

25 from project.a1

26 where anayalpha(ZIP);

ERROR: Function ANAYALPHA could not be located.

But anyways I tried running this :

proc sql;

select * from project.a1 where prxmatch('/^[A-Z]/', zip);

quit;

and it worked.

Thanks,

Minal

Re: Selecting Zipcodes starting with a character symbol

pradeepalankar — Wed, 02 Apr 2014 08:40:05 GMT

it should be

if anyalpha(zip)=1;

1 is for if zip starts with character value.

Re: Selecting Zipcodes starting with a character symbol

RW9 — Wed, 02 Apr 2014 09:00:28 GMT

Typo in word anyalpha:

where anyalpha(ZIP);

Re: Selecting Zipcodes starting with a character symbol

data_null__ — Wed, 02 Apr 2014 11:17:33 GMT

data _null_; 
   input zip $;
   notdigit = verify(first(zip),'0123456789');
   put _all_; 
   cards; 
10123
u9900
90210
;;;;
   run; 

15         data _null_;
16            input zip $;
17            notdigit = verify(first(zip),'0123456789');
18            put _all_;
19            cards;

zip=10123 notdigit=0 _ERROR_=0 _N_=1
zip=u9900 notdigit=1 _ERROR_=0 _N_=2
zip=90210 notdigit=0 _ERROR_=0 _N_=3