SAS Helpful Hints

Sending output to Microsoft Word for Final Formatting

SAS output (.lst & .rtf) is nice, but can be improved in Microsoft Word. Unfortunatly SAS output looks bad when it is opened with Word. This problem can be solved by adding a button to your Word menu bar than converts SAS output into a nice format. To do this, follow these steps: (Fortunatly you only have to do this once. After you are done, you'll be able to open your SAS output file and click on your conversion button.)

Inside Microsoft Word:
    Click on Tools -> Macro -> Record new Macro.
        Enter the Macro Name: ConvertSAS.

    Click on Edit -> Select All.
    Select Font: SAS Monospace.
    Select Font Size: 9.

    Click on File -> Page Setup.
        Under the Margins Tab. set the following:
            Top: 0.25       Bottom: 0.25
            Left: 0.2         Right: 0.2
            Gutter: 0.0
            Header: 0.0     Footer: 0.0

        Under the Paper Size Tab, Select Landscape.
        Click on OK.

    Click on the little blue square to stop the macro recording.

    Click on Tools -> Customize.
        Under the Commands Tab Scroll down and select Macros.
        Drag and Drop ConvertSAS, the macro you just recorded, to the menu bar.
        Click on Modify Selection -> Change button image -> Select a button.
        Click on Modify Selection -> Default Style.
    Close

Please send your comments and suggestions about this web page to A. Watts (watts@bst.rochester.edu)