120 likes | 487 Views
Importing Excel Files into SAS & SPSS. Welcome to IT’s seminar on stat. packages Sam Gordji, ccsam@olemiss.edu Weir 107 . List of Statistical Packages. SPSS SAS Mathematica MathWorks IMSL. List of Statistical Packages. SAS
E N D
Importing Excel Files into SAS & SPSS Welcome to IT’s seminar on stat. packages Sam Gordji, ccsam@olemiss.edu Weir 107
List of Statistical Packages • SPSS • SAS • Mathematica • MathWorks • IMSL
List of Statistical Packages SAS SAS (50 Copies available to the faculty and additional 50 copies are available for student use, IT has most of the SAS modules but not all). The cost for SAS is $75 per copy per year. To obtain a copy of SAS please send email toccsam@olemiss.eduor assist@mcsr.olemiss.edu
List of Statistical Packages Mathematica • Mathematica (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
List of Statistical Packages Matlab • Matlab (available on willow and sweetgum) • Other packages such as Fortran, IMSL, etc. will be mentioned briefly
List of Statistical Packages IMSL • IMSL is a comprehensive package containing Math., stat., and special functions • IMSL is available only on sweetgum • IMSL is a set of subroutines called by a Fortran program
General Information • Email contact • Email your questions to ccsam@olemiss.edu • To download this and other materials visit: http://www.mcsr.olemiss.edu/appssubpage. php?pagename=mathcamp.inc • Please fill out the performance report and leave your email address so we may contact you for follow up questions
General Information • SPSS, SAS, and Mathematica are available in Weir Student Lab, Weir 107, and several other labs around campus • We’ll look at a few examples of how to import excel dataset into SAS & SPSS
General Information • SAS performs statistical analysis • SPSS performs statistical analysis and is similar to SAS • Mathematica’s main function is to perform mathematical operations including statistics • MathWorks is similar to Mathematica and is available on willow and sweetgum
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 email to Sam Gordji at ccsam@olemiss.edu , assist@mcsr.olemiss.edu , or mathadm@olemiss.edu
Today We’ll Cover • Inspecting a simple SAS and SPSS programs (*.log, *.lst) • How to import excel files into SPSS • How to import excel files into SAS