Create columns from a string

[SASPhile]

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]

Will the string always contain 4 strings within it?

[SASPhile]

Hi,

Yes.

[art297]

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

;