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

A Format Is Not Being Applied to a Variable

Unlike most SAS procedures, where there is only one way to apply formats to your output, PROC TABULATE has several ways to apply formats. Consider the following three ways:
  • using the FORMAT= option in the PROC TABULATE statement
  • using the FORMAT= (or F=) option in the TABLE statement
  • using the FORMAT statement
Unfortunately, these three methods are not interchangeable. This can lead to a lot of confusion when your table does not turn out as expected. For example, look at the following two tables. One table has a format for the analysis variable INCOME. The second table has formats for the two class variables, OCCUP and CTRY.
PROC TABULATE DATA=TEMP; CLASS EDUC AGE; VAR INCOME; TABLE ...
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