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

Percentages for Multiple Row Variables

Our first table shows row percentages. What’s different about this table is that this time there are multiple row variables. So we will be building percentages for more than one variable at a time.
Our starting point is a table showing a breakdown of customers by country , gender, business type, and business size. The following code produces a table that shows the number of customers in each category:
PROC TABULATE DATA=TEMP;
   CLASS GENDER CTRY CUSTTYPE SIZE;
   TABLE (CTRY CUSTTYPE)*GENDER, SIZE*N;
RUN;
But it would be much more interesting to see some percentages. This will make it easier to see the distribution of customers between the categories.
PROC TABULATE DATA=TEMP; CLASS GENDER CTRY CUSTTYPE SIZE; ...
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