Selecting Zipcodes starting with a character symbol

[MinalMMurkhande]

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

[UrvishShah]

proc sql;

  select *

  from have

  where anayalpha(ZIP);

quit;

[MinalMMurkhande]

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

[RW9]

Typo in word anyalpha:

where anyalpha(ZIP);

[pradeepalankar]

it should be

if anyalpha(zip)=1;

1 is for if zip starts with character value.

[data_null__ · Accepted solution]

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