Introduction to HTML Reporting with SAS

Welcome to HTML reporting with SAS

Sam Gordji, ccsam@olemiss.edu

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 assist@olemiss.edu

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: assist@mcsr.olemiss.edu

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