A brief introduction to SAS Enterprise Guide for Statistics 1160 students

1
A brief introduction to SAS Enterprise Guide for
Statistics 1160 students

• Kevin Murray
• School of Mathematics and Statistics
• UWA

2
Contents

• What is SAS and SAS Enterprise Guide?
• Getting started with SAS Enterprise Guide
• Creating new data and reading in existing data
• Manipulating data
• Some basic statistical functions
• Some basic graphing functions
• More information

3
What is SAS and SAS Enterprise Guide?

• SAS is a very powerful software package used
  worldwide
• SAS uses a programming language to carry out
  statistical analyses
• SAS Enterprise Guide is a point and click package
  that creates the code needed for SAS
• It creates the code, sends it to SAS, SAS carries
  out the analyses and sends the results back to
  Enterprise Guide.
• Enables the much of the functionality of SAS
  without the heartache of the programming!!

4
What is SAS and SAS Enterprise Guide?
SAS System
ENTERPRISE GUIDE
5
Getting Started

• In the Lab
• Either select SAS Enterprise Guide from the Start
  gt Program Menu sequence
• Or find the short cut icon on the lab machine and
  double click

6
Entering new data in SAS

• When you open SAS enterprise guide you should see
  something similar to this

7
Creating a new data set

• Either
• When you open go to new data in the welcome box
• Or
• 2. Go through the file menu sequence File gt New
  gt Data

8
File menu sequence
9
Creating Data

• This will save a given named dataset (data1 in
  this instance) in a temporary directory called
  WORK.

10
Creating data

• You can now enter values and codes as with any
  other spreadsheet.
• The symbol at the top of each column indicates
  what kind of variable you have (eg. Character
  numeric etc..)
• This can be changed by right clicking the column
  and changing the variable type
• By default it will allocate a column type based
  on the first value entered in this column.

11
Manipulating data

• Sometimes we need to add columns or even
  transform data
• We can do this by inserting a new column in the
  existing dataset.

12
Manipulating data

• Enter the name of a variable and a label if you
  want.
• In the expression write a mathematical expression

13
Common mathematical expressions

• Plus (), minus (-), multiple (), divide (/),
  square root (sqrt), power (x2).
• All can be entered in any expression.
• If the new variable relies on a existing variable
  enter the existing variable name in the
  expression

14
Using existing datasets

• Stat1160 will make use of data already created
  and stored
• These datasets are on the Stat1160 web pages in
  both excel format and SAS EG format and are also
  available on the Lab machines
• SAS EG will directly open any of these formats

15
Using existing data sets

• In SAS EG click File gt Open gt From My Computer
• Find the file you wish to open in the directory
  on your computer

16
Using existing data sets- excel files

• Importing excel data have to make decision on
  what to do
• The top selection will work fine for stats 1160,
  however using the bottom selection mentioned
  below creates a SAS data set which you can do
  much more with (be careful though as there are
  more options to play with)

17
Basic functions using enterprise guide

• Most functions that we will perform in Stats 1160
  will use one of the three menu items
• Describe
• Graph
• Analyze

18
Summary statistics and histogram

• Open up the Olympic dataset and get summary
  statistics
• Variables have to be assigned to categories in
  the task roles
• Assign the 100m variable to the Analysis
  variable category as this is the variable we
  wish to examine

19
Summary statistics and histogram

• In the statistics - basic category you can select
  mean, standard deviation, variance etc.
• In the statistics - percentiles category you can
  get median and percentiles
• Under plots you can select which charts you would
  like to see for this variable select histogram
  and click run.

20
Output

• Can be resized and cut and pasted into other
  packages

21
Process flow diagram

• SAS EG uses a process flow diagram to keep track
  of what you have done
• You can click back through each procedure or
  results as and when you please

22
Stem and leaf plot

• Through the analyze gt Distribution Analysis menu
  carry out a stem and leaf plot (remember to
  identify which variable you want as the analysis
  variable)

23
More information

• The help function is easy to use
• SAS EG also has a tutorial packaged with it which
  give you much more information
• Ask a demonstrator or lecturer
• For more information on SAS Enterprise Guide
  contact kev_at_maths.uwa.edu.au, room 2.37 School
  of Mathematics and Statistics UWA Crawley Campus
• ENJOY ?

24
Things to try!

• Open the Olympic data and get descriptions of
  several variables at the same time (more than 1
  analysis variable can be entered)
• Try doing some scatter plots with Olympic data.
  What relationships can you see?
• Open another data set. Try entering some data as
  a classification variable in the Task roles.
• From the stats 1160 data sets on the web pages or
  in the MCL try to find some data that would be
  appropriate for bar charts, pie charts, and stem
  leaf plots try doing some of these in SAS
  enterprise guide
• Have a look at the tutorial in SAS EG and try and
  work through some of the examples