Subscribe Bookmark RSS Feed

value ordering question

I have a question about the "value ordering" property of a column. Suppose we are using big class data set. The default ordering for age is {12,13,...17}. I manually changed it to {17, 16,...12}.

When I call the summary function, I find that if age is used as group variable, the ordering works fine. But if using "sex" as group variable and "age" as subgroup variable, the ordering for age goes back to the default one. Is there anyway to fix this?



Jun 23, 2011

That is a bug in summary, that the subgroup column ignores the ordering property saved in the column. If the order is important, you might want to switch the the role, make it the grouping column. Alternatively, you can use Tabulate.
That's interesting. Thank you very much!
Or you can use proc sql in SAS.