Proc Report in SAS

1
Proc Report in SAS

• Doin It in Style
• Ray Pass, Ray Pass Consulting, Hartsdale, NY
• Sandy McNeill, SAS, Cary, NC

2
Data Used

• contains values from a fictitious drug trial of
  an anti-hypertension blood pressure medication
• data collected are from multiple patients and
  consist of basic demographic information
  (drug,patient, sex, visit date),
• with systolic and diastolic blood samples
• pressure readings at time of visit, and reported
  adverse reactions (fever, nausea, rash).

3
(No Transcript)
4
ODS Style implemented in Proc Report

• Color and pictures in a data dynanic manner
• More pleasing to the eye
• Easier to identify trends in the data

5
(No Transcript)
6
(No Transcript)
7
Style Location
8
Images in 1st Column

• compute systolic
• if lastsys ne . then do
• if systolic.sum gt lastsys
• then call define (_col_,'style',
• 'styleforegroundred
• preimage"trendupsm.gif"')
• else if systolic.sum lt lastsys
• then call define (_col_,'style',
• 'styleforegroundgreen
• preimage"trenddownsm.gif"')
• end
• lastsys systolic.sum
• endcomp

9
Background Color of Cell
10
(No Transcript)
11
References

• Acknowledgements
• SAS is a registered trademark of the SAS
  Institute Inc., Cary,
• NC, USA.
• Author Contact Information
• The authors of this paper can be contacted as
  follows
• Ray Pass Sandy McNeill
• Ray Pass Consulting SAS Institute
• 5 Sinclair Place SAS Campus Drive
• Hartsdale, NY 10530 Cary, NC 27513
• Voice [phone] Voice [phone]
• Fax [phone] Fax [phone]
• e-mail raypass_at_att.net e-mail
  sandy.mcneill_at_sas.com