topic Re: How to extract the levels of a categorical variable ? in SAS Programming

How to extract the levels of a categorical variable ?

KarimaTouati — Wed, 22 Jan 2020 16:34:40 GMT

Hello,

I am trying to read the names of a categorical variable in SAS and change it.

Is there any predefined function to extract variable levels in SAS ?

Re: How to extract the levels of a categorical variable ?

PaigeMiller — Wed, 22 Jan 2020 16:36:26 GMT

proc sql;
     select distinct variablename from have;
quit;

Re: How to extract the levels of a categorical variable ?

Reeza — Wed, 22 Jan 2020 16:59:34 GMT

PROC FREQ.

PROC FREQ DATA=sashelp.class;
TABLE age / OUT= want;
RUN;

The output is displayed and in the WANT data set. Change the variables in lower case to match your requirements.

Re: How to extract the levels of a categorical variable ?

KarimaTouati — Thu, 23 Jan 2020 08:52:02 GMT

Thank you PaigeMiller, I am looking for each level of my categorical variable and not an extraction of specific variables in my dataset.

Re: How to extract the levels of a categorical variable ?

PaigeMiller — Thu, 23 Jan 2020 11:53:45 GMT

@KarimaTouati wrote:

Thank you PaigeMiller, I am looking for each level of my categorical variable and not an extraction of specific variables in my dataset.

The solution I gave does what you ask for.