ARE YOU USING PROC REPORT YET?

1
ARE YOU USING PROC REPORT YET?

• Priya Ramaswami
• Janssen RD US

2

• Advantages of PROC REPORT
• - Very powerful
• - Perform lists, subsets, statistics,
  
• computations, formatting within one
• procedure.
• - Multiple functions in one SORT,
• PRINT, MEANS, TABULATE, some DATA
• STEP processing

3

• SYNTAX
• PROC REPORT datainput dataset options
• WHERE ltoptionalgt
• COLUMN list of variables
• DEFINE variable 1 / column attributes
• DEFINE variable 2 / column attributes
• .
• DEFINE last variable / column attributes
• COMPUTE block ltoptionalgt
• BREAK statement ltoptionalgt
• RBREAK statement ltoptionalgt
• RUN

4

• PROC REPORT statement Common options
• DATA Input dataset used for processing
  the report
• NOWD Short for NOWINDOWS. Sends the
  report to the output
• window instead of the interactive
  REPORT window
• SPLIT Wraps the header and column
  contents at the specified
• character. The
  default character is /
• HEADLINE Creates a line below the column header
• HEADSKIP Inserts a blank line between the
  column header and
• the first line of
  data
• OUT Creates an output dataset with
  the contents of the
• REPORT procedure.
  This is especially helpful while
• trouble-shooting any
  new variables created in the
• COMPUTE block or
  specified breaks.

5

• WHERE statement - subset the data.
• Syntax keyword WHERE conditions
• COLUMN statement - lists all the variables to be
  displayed in the report,
• including variables created in the COMPUTE
  block
• Syntax keyword COLUMN variable names.
  

6

• DEFINE statement - how the variables are
  presented in the report.
• Syntax keyword DEFINE variable name
  slash (/) set of
• keywords and options.
• Common keywords
• GROUP categorizes observations by the
  variable
• DISPLAY default displays values for each
  observation as they
• appear in the data.
• ORDER sorts the data by the variable
• ANALYSIS performs the specified statistical
  function on the
• variable
• COMPUTED identifies variables created in the
  COMPUTE block.

7

• COMPUTE block - begins with the COMPUTE statement
  and ends with the ENDCOMP statement. Create new
  variables, add blank lines, add footnotes.
• BREAK statement is optional and is used for
  summarizing groups of data.
• Syntax BREAK before or after variable /
  ltoptionsgt
• BREAK variable has to be a group or order
  variable. A summary line is created when the
  value of the variable changes. The keyword BEFORE
  creates the summary line before the data the
  keyword AFTER creates the summary line after the
  data.

8

• RBREAK statement is optional and is used to
  create a summary line for the whole report.
• Syntax RBREAK before or after /
  ltoptionsgt
• Options for the BREAK and RBREAK statements
• - UL Underline
• - OL Overline
• - DUL Double underline
• - DOL Double overline
• - PAGE Skip a page before the next
  row
• - SKIP Skip a line before the
  next row
• - SUMMARIZE Create a summary line for
  each variable
• 
  specified
• - SUPPRESS Not print the value of the
  break variable in the
• 
  summary line

9
(No Transcript)
10
(No Transcript)
11
(No Transcript)
12
(No Transcript)
13

• ORDER Option
• Specifies the method of sorting the variable.
  Used in conjunction with the ORDER keyword in the
  DEFINE statement. There are four types of sorts
  that can be performed with the ORDER option.
• ORDERINTERNAL Sorts by the variables
  unformatted values
• ORDERDATA Sorts by the order of the
  variables values as in the
• 
  dataset
• ORDERFORMATTED Default Sorts by the variables
  formatted values
• ORDERFREQ Sorts by the frequency
  counts of the variables
• 
  values

14
(No Transcript)
15
(No Transcript)
16

• COMPUTE BLOCK
• One of the most unique features of the REPORT
  procedure.
• Enables to modify values, add variables, add
  headers and footnotes, and control the contents
  of columns.
• The COMPUTE block begins with the COMPUTE
  statement and ends with the ENDCOMP statement.
  Typically placed after the DEFINE statements.
•   2 types of COMPUTE blocks
• associated with a location with respect to the
  layout of the report
• associated with the report item only.
• Syntax
• compute ltlocationgt ltreport itemgt lt/
  optionsgt
• executable statements
• endcomp

17
(No Transcript)
18
(No Transcript)
19
(No Transcript)
20
(No Transcript)
21

• OUTPUT DELIVERY SYSTEM (ODS)
• Output from the PROC REPORT can be directed to a
  pdf file, rtf file or html file.
• Syntax
• ods listing close
• ods rtf file file location\file
  name.rtf
• proc report steps from previous
  example
• ods rtf close
•  

Closes output window
Opens a file for the output in rtf format
Closes rtf file
22
(No Transcript)
23

• Contact details
• Priya Ramaswami,
• Janssen RD US
• pramaswa_at_its.jnj.com