PROC REPORT formatting tips

6

I’m a SAS user in the Pharmaceutical industry. I switched to the Pharmaceutical industry (from Marketing Research) four years ago and had a lot to learn! I started my new endeavor by purchasing some excellent SAS books, joining my local SAS user group, attending conferences (Michigan SAS User Group, PharmaSUG, SAS Global Forum), talking to SAS Press authors, and taking advantage of the wonderful SAS publications (SAS blogs, SAS Community, SAS Tech Support, and conference papers). I’m writing this blog to share some helpful hints I’ve learned from these great resources as well as tips that I’ve gathered from on-the-job mentors and my own daily experience.

Here are some PROC REPORT formatting tips:

Managing Header Levels with COLUMN and DEFINE Statements

  • Headers created with the COLUMN statement are placed above headers created with the DEFINE statement. See “Gender” placement in CODE and FIGURE 1.X.1 vs. 1.X.2.
  • CODE 1.X.2 shows a blank placed in quotes (define SEX / " ";) to prevent the variable name (SEX) from appearing under “Gender” (default without a DEFINE header in place).

 Creating Line Breaks in Column Headers:

  • Line breaks can be created in the COLUMN and/or DEFINE statements.
  • Line break syntax can come from multiple sources that produce the same results. Examples: a PROC REPORT SPLIT Character, an ODS Escape character with the wn function or RTF inline formatting.
  • The line break code is inserted in the location of the desired line break.

 

Share

About Author

Lisa Fine

Assistant Manager, Clinical Programming - United BioSource Corporation

Lisa Fine is an Assistant Manager of Clinical Programming at United BioSource Corporation. She has fourteen years of experience in applied SAS programming with a focus on data verification and reporting in the industry areas of Pharmaceutical Research and Marketing. Lisa has presented and published several papers for various SAS User Group conferences.

Related Posts

6 Comments

  1. I think these formatting tips are incredibly helpful. I hope we will have the opportunity read more tips in the future from Lisa Fine!

Leave A Reply

Back to Top