topic how to convert categorical variables into continuous variables in Statistical Procedures

how to convert categorical variables into continuous variables

lucky66 — Tue, 26 Jul 2011 04:29:42 GMT

In Generalized liner model, there are totally 120 categorical variables as predictorsand each of them have 20 levels. I tried to convert these categorical variables into continuous variables so that I can build the model; however, I did not know how to do so.

Who knows? Thanks.

how to convert categorical variables into continuous variables

SteveDenham — Tue, 26 Jul 2011 11:41:04 GMT

Without seeing the code you are using to do the analysis, I hesitate to offer a solution. However, it could be as simple as not including the predictors in the class statement, provided the variables have a natural ordering. Also, why do you have to convert to build the model? Both PROC GLIMMIX and PROC GENMOD can fit categorical models. If you are thinking of some sort of stepwise model building, please look at http://communities.sas.com/thread/30130?tstart=0, where some strong caveats are presented.

Good luck.

Re: how to convert categorical variables into continuous variables

Rick_SAS — Tue, 26 Jul 2011 11:52:00 GMT

Obviously, the categories need to be ordinal so that you can order them. Maybe you have levels such as "bad", "ok", "good", and "excellent"? The way that you convert these to numbers will affect your answer. You can recode those levels as 1,2,3,4, or you might decide that "bad" and "excellent" have more extreme values, and so you recode as 0, 2,3,5.

There is some terse discussion of this in the doc for the SCORES statement of the FREQ procedure:

http://support.sas.com/documentation/cdl/en/procstat/63963/HTML/default/viewer.htm#procstat_freq_a0000000560.htm#procstat.freq.freqscores

For a technical consideration of whether you should do this, along with instructions how, see Analysis of Ordinal Categorical Data by Alan Agresti. You can also try an internet seach using terms such as Ordinal Categories Rank Ridit Scores.