topic extract prov and postal code form address line in SAS Procedures

extract prov and postal code form address line

podarum — Sun, 25 Sep 2016 16:37:37 GMT

Hi , what is the best way to extract porvince and postal code from an address line as:

Address_Var

TORONTO ON K9Z 9Z9

TORONTO ON M6E 3C6

LONDON ON N5V 3L1

TOTTENHAM ON L0G 1W0

and create 4 new fields. Eg. City, prov and Postal_code and FSA (the 3 first digits of the postal code, eg. K9Z, M6E).

Thanks.

Shmuel — Sun, 25 Sep 2016 17:40:08 GMT

It seems that each line is made of 4 strings: city , province , zip , fsa

anyhow there are probably cities made of two or even 3 strings,

in such case try next code:

data want;

infile datalines;

input address $60.;

fsa = scan(address,-1);

zip = scan(address,-2);

province = scan(address,-3);

ix = index(address,province);

city = substr(address,1,ix-1);

drop ix;

run;

Reeza — Sun, 25 Sep 2016 17:39:14 GMT

Do you have Cities that have two names? ie Niagara Falls?

podarum — Mon, 26 Sep 2016 01:09:05 GMT

Yes, it's all Canada.