topic Re: Create columns from a string in SAS Programming

Create columns from a string

SASPhile — Thu, 15 Nov 2012 19:14:12 GMT

how to create three columns from a string?i will get these values in a txt file and the string length can vary.

AZERBAIJAN AZ AZE 031

Country=AZERBAIJAN

Country_code=AZ/AZE

Dial_code=031

art297 — Thu, 15 Nov 2012 19:44:31 GMT

Will the string always contain 4 strings within it?

SASPhile — Thu, 15 Nov 2012 19:57:23 GMT

Hi,

Yes.

art297 — Thu, 15 Nov 2012 19:58:35 GMT

data want;

input;

Country=scan(_infile_,1);

Country_code=catx("/",scan(_infile_,2),scan(_infile_,3));

Dial_code=scan(_infile_,4);

cards;

AZERBAIJAN AZ AZE 031

;