topic Re: Truncating a string into pieces? in SAS Procedures

Truncating a string into pieces?

Mirisage — Thu, 25 Jul 2013 13:56:09 GMT

Hi SAS Forum,
I have a list of some 200 postal codes in the attached SAS data set as a string.

I need to get the postal codes separated. The final data set that I want should look like below.

postal_code

T1S0C3

T1S1A1

T1S1A2

T1S1A4

T1S1A5

.......

Could anyone help me to get the single string transformed into a data set like above?

Thank you for your time and expertise.

Mirisage

Re: Truncating a string into pieces?

Haikuo — Thu, 25 Jul 2013 14:06:55 GMT

Please refer this thread for your answer:

https://communities.sas.com/thread/48092

Re: Truncating a string into pieces?

BrunoMueller — Thu, 25 Jul 2013 14:11:57 GMT

Have a look at this code

COUNTW will count the "words" delimited by a blank, SCAN will get the proper string

data postalcodes;
  postal_codes = "T1S0C3 T1S1A1 T1S1A2 T1S1A4 T1S1A5 T1S1A6 T1S1A7 T1S1A8 T1S1A9 T1S1B1 T1S1B2"; 
  length postalCode $ 16; 
  n_postalCodes = countw(postal_codes, " ");
  do i = 1 to n_postalCodes;
    postalCode = scan(postal_codes, i, " ");
    output; 
  end; 

  drop postal_codes /* n_postalCodes i */; 
run; 
  

Re: Truncating a string into pieces?

Mirisage — Fri, 26 Jul 2013 16:08:23 GMT

Hi Bruno

Thank you very much, your code worked nicely and explanation is very helpful.

Hi Hai.kuo,

Mnay thanks for your link which is very helpful.

Regards

Mirisage