topic Re: data numeric, but variable actually categorical in SAS Procedures

data numeric, but variable actually categorical

CharlesR — Fri, 30 Jul 2010 04:11:07 GMT

Hello,
I'm using proc logistic and have several categorical variables. The data, though, is numeric, some with corresponding formats, others binary, etc. Is there an easy way to get proc logistic to recognize the variables as categorical? I tried to list them under class, but this didn't work of course since the data is numeric. Do i simply have to reformat the info? How do i do this in an efficient manner?

Re: data numeric, but variable actually categorical

deleted_user — Fri, 30 Jul 2010 18:59:07 GMT

CLASS works with numeric or character. However, if you want to group numeric variables into grouped classes you will need to generate a user format. Here is an example:

PROC FORMAT;
value classit low-25 = '-25'
25<-60 = '25 <- 60'
60 - high = '60+'
;
run;

proc logistic data=yourdata descending;
class num_class;
format num_class clasit.;
model whatever = other_numeric | class @ 2;
run; Message was edited by: jonas.bilenas

Re: data numeric, but variable actually categorical

deleted_user — Fri, 30 Jul 2010 19:01:04 GMT

Hmm, My response looks truncated. Is there a word limit here?

Re: data numeric, but variable actually categorical

RickM — Fri, 30 Jul 2010 19:03:34 GMT

Jonas,

Take a look at

http://support.sas.com/forums/thread.jspa?messageID=27609毙

Re: data numeric, but variable actually categorical

Cynthia_sas — Fri, 30 Jul 2010 20:08:54 GMT

Hi:
No, no word limit, but special characters like < and > sometimes confuse the forum posting editor...because it uses HTML tags and < and > are looking like HTML and so sometimes pieces of your post get "truncated" while the editor looks for the end of a tag.

Here's the specifics:
http://support.sas.com/forums/thread.jspa?messageID=27609毙

Use the [pre] and [/pre] tags around your code and output in order to maintain indenting and spacing. And, also, use < for < symbol and > for > symbol.

cynthia

Re: data numeric, but variable actually categorical

CharlesR — Sat, 31 Jul 2010 02:45:17 GMT

Great. Thanks all! I think i was forgetting to put my values in single quotes. Silly rabbit . . .