topic Re: Change collation order in SAS Procedures

Change collation order

marieK — Thu, 06 Aug 2009 13:59:21 GMT

Hi,

in my output-table i would like to order my value-names like i want (i.e. i have a frequency-table and the values "yes" , "no", "no answer" and "missings"). if i sort these values i get an output like that:

missings: 10
no: 266
no answer: 70
yes: 599

but i would like to have a table like that:

no: 266
yes: 599
no answer: 70
missings: 10

any idea how i can sort my table output that way??

thank you in advance, marie

Re: Change collation order

Flip — Thu, 06 Aug 2009 14:45:57 GMT

Create a surogate sort variable such that
4 : missings
1 : no
3 : no answer
2 : yes

Sort on that var, but do not diaplay it.

Re: Change collation order

DanielSantos — Thu, 06 Aug 2009 16:58:08 GMT

Another way, would be to create a format (with the desired ordered values, then perform a formatted sort through SQL.

proc sql;
create table b as select * from a order by put(a, $myformat.);
quit;

More about creating SAS formats here:
http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/a002473464.htm

Cheers from Portugal.

Daniel Santos @ www.cgd.pt.

Re: Change collation order

marieK — Fri, 07 Aug 2009 06:44:19 GMT

Thank u very much for your answers!! I'll try it out!

cheers marie