Introduction to HTML Reporting with SAS

1
Introduction to HTML Reporting with SAS

• Welcome to HTML reporting with SAS
• Sam Gordji, ccsam_at_olemiss.edu
• Weir 107

2
List of Statistical Packages

• Mathematica
• A free copy for faculty, staff, and students. To
  obtain a copy of Mathematica please visit
• http//www.mcsr.olemiss.edu/appssubpage.php?pagen
  amemathematica.inc

3
General Information

• Email contact
• Email your questions to assist_at_olemiss.edu
• Please fill out the performance report and leave
  your email address so we may contact you for
  follow up questions

4
General Information

• Matlab is available on willow and sweetgum
• Matlab PC version will be available soon
• SAS Enterprise Guide (EG) also may be used to
  create HTML output files
• SPSS, SAS, and Mathematica are available in Weir
  Student Lab, Weir 107, and several other labs
  around campus
• We will look at a few short examples of SAS
  SAS/EG

5
General Information

• SAS performs statistical analysis
• SPSS also performs statistical analysis and is
  similar to SAS
• Mathematicas main function is to perform
  mathematical operations including statistics
• Matlab is similar to Mathematica

6
General Information

• IT staff will assist users to access these
  packages
• We also assist users to find the proper procedure
  to analyze their data. If you need assistance
  please send an email to assist_at_mcsr.olemiss.edu

7
Enterprise Guide (EG)

• Enterprise Guide (EG) is a Front-End Program for
  SAS
• Available to those who have SAS
• While running EG, SAS will run in the background
• EG builds tasks, while SAS runs them
• EG accepts various formats, e.g. .xls
• Programming is done by Point and Click and
  Drag and Drop
• Access to much of SAS procs
• Creating and running a few examples

8
Useful Links

• The main webpage
• http//www.sas.com/
• For information on documentations for SAS visit
  
• http//support.sas.com/onlinedoc/913/docMainpage.
  jsp
• Link for EG
• http//www.sas.com/technologies/bi/query_reportin
  g/guide/
• We will visit the above site and look at SAS Base
  EG

9
A Small Example

• data test
• ods html file"c\Users\ccsam\sas\odsreg3.htm"
• input a b c
• cards
• 1 2 3
• 2 3 4
• 4 5 6
• 6 5 3
• proc print
• proc means run
• ods html close
• Let us run this program and look at its output

10
Generating HTML Without EG

• Open SAS and import corr748re_html.sas
• Run corr748re_html.sas
• Look at the 3 lines creating output delivery
  system (ODS)
• Look at the output created by corr748re
• Let us look at test_html.sas program

11
Generating HTML Without EG

• Let us look at the second example on how to
  produce HTML output using SAS only
• Run html_sas.sas program
• Save the output as SASoutput.mht
• Close sas, open SASoutput.mht and print
  SASoutput.mht
• Please note ods stands for Output Delivery
  System

12
Running Enterprise Guide 4

• Click Start-gtProgram-gtSAS-gtEnterprise Guide 4
• Close the small window
• Choose File-gtopen-gt datagt Local Computer
• Choose your input file (e.g. graph_eg.xls), then
  click open
• Open your data by
• Clicking sheet1-gtopen, then choose option one,
  Select this option if view the file

13
Running Enterprise Guide 4 (Cont.)

• From the File menu choose describe-gt summary
  statistics
• To run proc describe move the first variable to
  the right and click run
• Choose another proc and run it

14
Creating Output in HTML (EG)

• Under Project Explorer
• Right Click HTML-Code, then Choose Export
• Choose Export-HTML Code
• Choose Local Computer
• Choose a name, then save
• Close all SAS windows
• Open your output and examine it