topic assigning multiple variables in New SAS User

assigning multiple variables

genius99 — Tue, 17 Sep 2019 16:31:38 GMT

I have two data sets, and I want to assign a continent to each country. how do I do that?

I have attached the data

Re: assigning multiple variables

Kurt_Bremser — Tue, 17 Sep 2019 16:44:44 GMT

Create a value format that connects countries to continents, and use that:

proc format;
value $continents
  "Switzerland" = "Europe"
  "Austria" = "Europe"
  "USA" = "North America"
  /* and so on */
;
run;

data want;
set have;
continent = put(country,$continent.);
run;

Re: assigning multiple variables

Jagadishkatam — Tue, 17 Sep 2019 16:48:47 GMT

May be if you post the sample data and expected output it would help to get better responses.

However I will try

You can derive the continent based on the country something as below , alternatively you can use the format if we can know all countries and respective continents

If country='Germany' then continent='Europe';
else if country='China' then continent='Asia';
etc.,