As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


How To Produce Almost Perfect RTF Output

From sasCommunity
Jump to: navigation, search

Abstract

The Census Bureau performs an annual data collection for the National Center for Education Statistics. As part of the file documentation, the Census Bureau produces output that shows the imputation flag distribution for more than 140 variables. Census also produces a summary table that shows the minimum, maximum, and mean value for each continuous variable, along with the number of records that have a value greater than or equal to zero, the number of records with missing values, and the number of records with “not applicable” values.

The output can be easily produced as RTF (Rich Text Format), but we need to use many little tricks to produce beautiful Microsoft Word output. The little tricks include modifying the PRINTER style, modifying the one way frequency table template, using ODS RTF TEXT= statements with RTF control words, using inline formatting on the footnote statement, and applying style definitions to PROC PRINT to produce RTF output that almost exactly meets the publication style. Setting up the SAS® code only needs to be done one time, thus eliminating a lot of manual formatting in Microsoft Word.

Online materials

The NESUG 2006 paper
Zip file containing data, SAS code, and output

Contact Info

Suzanne.Marie.Dorinski@census.gov


Suzanne's user page