Skip to Main Content
PROC TABULATE by Example, Second Edition
book

PROC TABULATE by Example, Second Edition

by Lauren Haworth Lake, Julie McKnight
May 2015
Intermediate to advanced content levelIntermediate to advanced
348 pages
11h 31m
English
SAS Institute
Content preview from PROC TABULATE by Example, Second Edition

Reorder Class Variables

Overview

The ORDER=, ASCENDING, and DESCENDING options enable you to specify the order in which specific class variable categories are listed in your table.
To see how the ORDER= option works in general, look at the following example program. Here the option is applied in the PROC TABULATE statement, so it affects every class variable in the table. In this case, the ORDER=FREQ option has been chosen so that the values will be listed in descending order of their frequency in the data set.
PROC TABULATE DATA=TEMP ORDER=FREQ;
   CLASS GENDER AGE ANS;
   TABLE AGE*ANS=' ',
         (GENDER=' ' ALL)*N=' '*F=10.
         / BOX='Reason for Choice';
RUN;
In Output 9.20, notice how the categories of the variable ANS are listed in order of their frequency. ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

SAS 9.4 Language Reference, 6th Edition

SAS 9.4 Language Reference, 6th Edition

SAS Institute

Publisher Resources

ISBN: 9781607649908