topic Re: extract information in a column in SAS Studio

extract information in a column

YangYY — Mon, 21 Oct 2019 05:27:57 GMT

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

Re: extract information in a column

PeterClemmensen — Mon, 21 Oct 2019 05:35:29 GMT

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
;

Re: extract information in a column

YangYY — Mon, 21 Oct 2019 06:19:48 GMT

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??

Re: extract information in a column

PeterClemmensen — Mon, 21 Oct 2019 06:35:20 GMT

Ok. They are in a single variable, correct?

Re: extract information in a column

YangYY — Mon, 21 Oct 2019 06:46:15 GMT

yes,they are

Re: extract information in a column

PeterClemmensen — Mon, 21 Oct 2019 06:51:51 GMT

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;

Re: extract information in a column

YangYY — Mon, 21 Oct 2019 07:35:10 GMT

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