A Data Science Central Community
I need help in defining ordinal variables in SAS. I have age buckets given for each person. Say 26 Years-30 years as bucket 1, 31 years to 35 years as bucket 2, 36 years to 40 years as bucket 3, and so on. If I include these bucket numbers in the model, then SAS considers it as continuous numeric variable. I want to make SAS understand that these buckets are ordinal. I did not get any useful information regarding this online.
Can you please help me out.
Thanks a lot in advance :)
Hey Raghu, I got your DM and responding here.
I'm not sure what you're looking for here. Do you have age as a continuous variable - like 25, 26 ... 70? If you want to group them into buckets, you could quickly use any grouping algorithm to bucket them into your groups of 25-30, 31-35, 36-40 etc. And that way, proc logistic will automatically take it as a character variable. If you need it to be ordinal, then you could recode it into 1,2,3,4,5 for each of the ascending groups and while logistic regression will through out the odds for this as a continuous variable, not a character variable, so you may not be able to get an idea of 1 vs 2 for odds like if you had put it as a char variable.
Does this make sense?
Thanks a lot for the response!
I do not have the exact age values. I am given the age bucket for each person. And as you suggested, I have created the buckets 1,2,3,4,5,etc. So according to you, I can use these bucket numbers directly. It is correct but the interpretation of the odds ratio would not be simple. Am I right?
Thanks a lot once again!