Introduction to HTML Reporting with SAS

1. Introduction to HTML Reporting with SAS Welcome to HTML reporting with SAS Sam Gordji, ccsam@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?pagename=mathematica.inc

3. 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

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 • Mathematica’s 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@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_reporting/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->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”

13. 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

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