BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
podarum
Quartz | Level 8

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Shmuel
Garnet | Level 18

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;

View solution in original post

3 REPLIES 3
Shmuel
Garnet | Level 18

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
Super User

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

podarum
Quartz | Level 8

Yes, it's all Canada.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 2835 views
  • 0 likes
  • 3 in conversation