topic Re: proc sql in SAS Programming

Get continent names from sashelp.demographics

Lilik — Mon, 14 Apr 2025 06:51:08 GMT

Good day dear All,

I have some difficulties in finding continent names in sashelp.demographics. The requirement is to "Get the CONTNAME variable with the following values, without using any formats". In dataset there are continent codes. Could you help me with this?

Thanks in advance.

Re: proc sql

ballardw — Fri, 11 Apr 2025 16:11:57 GMT

If you are supposed to be looking for specific values then you should share the specific values you are using.

"Get the CONTNAME variable with the following values, without using any formats". My first thought would be to use an INFORMAT, which is not a Format, but I suspect that you are supposed to build a table with the actual values of the CONTNAME variable and the associated values you want to use as part of join to get the desired values. The easiest way to do that would likely be a data step reading the paired values.