extract information in a column

[YangYY]

Hi,

I got a column is cities which is like

cities

Saint Petersburg,Russia

Istanbul,Turkey

Porto Alegre,Brazil

Izmir,Turkey

Helsinki,Finland

And I have another document which includes country and continent. I want to attach the continent of each city. But I think I need to extract the country from the cities above and I use proc sort to merge them with the document. But I have no idea how to extra some information from a column(maybe I should use delimiter "," ?)

Anyone could help me with that?? Or do it in another way??

Thank you so much in advance

[PeterClemmensen]

Like this?

data have;
input city :$20. country :$20.;
infile datalines dlm=',';
datalines;
Saint Petersburg,Russia
Istanbul,Turkey
Porto Alegre,Brazil
Izmir,Turkey
Helsinki,Finland
;

[YangYY]

Saint Petersburg,Russia
Istanbul,Turkey
Porto Alegre,Brazil
Izmir,Turkey
Helsinki,Finland

 Thanks for your reply. But these cities above are included in a column of a data set.  So how can I use infile statement??

[PeterClemmensen]

Ok. They are in a single variable, correct?

[YangYY]

yes,they are

[PeterClemmensen · Accepted solution]

See if this helps you

data have;
input cities $ 1-100;
infile datalines truncover;
datalines;
Saint Petersburg,Russia
Istanbul,Turkey
Porto Alegre,Brazil
Izmir,Turkey
Helsinki,Finland
;

data want;
    set have;
    city=scan(cities, 1, ',');
    country=scan(cities, 2, ',');
run;

[YangYY]

Thank you so much!! It is exactly what I need!!