topic Re: order=formatted when no format specified for a CATEGORICAL variable in SAS Programming

order=formatted when no format specified for a CATEGORICAL variable

Cecillia_Mao — Wed, 20 May 2020 02:13:04 GMT

Hi everybody, I have a question regarding ORDER=FORMATTED: If no format is applied, the BEST12. format is used for numeric variables. However, I haven't found any description for categorical variables.

I tested using sashelp.cars dataset. It seems like the order is the same as the result of order=internal. So my question is if no format is specified for order=formatted, does SAS use order=internal instead？

proc report data=sashelp.cars(OBS=30);
Column Type invoice ;
define type/order order=formatted;
run;

proc report data=sashelp.cars(OBS=30);
Column Type invoice ;
define type/order order=internal;
run;

Thanks for your help in advance! Any thoughts would be appreciated!

Re: order=formatted when no format specified for a CATEGORICAL variable

ChrisNZ — Wed, 20 May 2020 06:16:16 GMT

If there is no format associated, the value is used, which is what option internal does.

Re: order=formatted when no format specified for a CATEGORICAL variable

ballardw — Wed, 20 May 2020 13:50:48 GMT

If by "categorical" you mean Character then the format will be $W. Which will generally mean your national language sort setting. Note that you may get some things that appear out of order if they have leading spaces because the sort will use the space for determining order but the display in many procedures will not display the leading space.

Numerical variables can be used as categorical. Custom formats to create groups of values, such as 10-year intervals for age, can turn continuous values into categorical values for most analysis, reporting graphing procedures.

Re: order=formatted when no format specified for a CATEGORICAL variable

Cecillia_Mao — Thu, 21 May 2020 01:31:41 GMT

Thanks so much for confirming!

Re: order=formatted when no format specified for a CATEGORICAL variable

Cecillia_Mao — Thu, 21 May 2020 01:43:26 GMT

Thanks so much for the comments! I just learned that most procedures won't display leading spaces. Regarding order=formatted, If there is no specified format, it will use best12. format for numerical variable and $w. format for categorical variables. And the order for those formats still follow 1-9, A-Z, a-z order.
Thank you!