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.
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;
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;
Do you have Cities that have two names? ie Niagara Falls?
Yes, it's all Canada.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.