Introduction to HTML Reporting with SAS
Welcome to HTML reporting with SAS
Sam Gordji, [email protected]
Weir 107
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?pagename=mathematica.inc
General Information
Email contact– Email your questions to [email protected]
Please fill out the performance report and leave your email address so we may contact you for follow up questions
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
General Information
SAS performs statistical analysis SPSS also performs statistical analysis
and is similar to SAS Mathematica’s main function is to perform
mathematical operations including statistics
Matlab is similar to Mathematica
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: [email protected]
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
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_reporting/guide/
We will visit the above site and look at SAS Base & EG
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
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
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
Running Enterprise Guide 4
Click Start->Program->SAS->Enterprise Guide 4 Close the small window Choose File->open-> data> Local Computer Choose your input file (e.g. graph_eg.xls), then
click open Open your data by: Clicking sheet1->open, then choose option
one, “Select this option if… view the file”
Running Enterprise Guide 4 (Cont.)
From the File menu choose describe-> summary statistics
To run proc describe move the first variable to the right and click “run”
Choose another proc and run it
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