Transcript Getting to know SAS - University of Arkansas

A Data Warehouse Mining Tool
Stephen Turner 575-6281
Chris Frala 575-6286
1




WARNING: There are A LOT of slides….but
they are step-by-step examples
Learn how to gain access
Take a look around
Build some queries and then learn how to
manipulate them to serve us better!
2

Building some queries

Summary of Cost Centers for a BU
 Manipulating existing queries
Summary of Cost Centers for a PI
 Details of Payroll for a BU

 Adding filter for a Time Range

Details of Payroll for an Individual
 Adding a Sort feature

Outstanding Invoices for a BU
3


Icon looks like this
If you don’t have the icon or you do or it is not
active, then here is how to gain access.
4

Via Information Technology Services website
http://its.uark.edu/
5
6
http://its.uark.edu/Data_Warehouse_Account_Request_Form.pdf
7
8
9
10
11
12
13
14
15




Now that we have two tables, we need to
combine them
Right click on one them and select “Query
Builder”
Then in the command bar, select “Join Tables”
And then “Add Tables”
16
This is the default of joining two tables and what
is used 99% of the time
17

This is the default of joining two tables and
what is used 99% of the time
18
19
20
21
22
23
24

This is great, but what if I wanted to pull in
the Category?
25
26
27
28
29

Let’s save what we have done first
30

What if, we need to know it by PI instead?
31
32
33
34
35
36
37
38
39
40

If I have not been to a Table in a while, I
usually just Double Click the table.
41

Now I look for things I can use. For this
example we will use

BU, CCN, Pay Amount, Benefits
42

Now right click on “LABOR_CURRENT” and
select “Query Builder”
43

Add a Filter
44

Selecting multiple BUs
45
46
47


But I wanted to know WHO was paid on a
given time period.
Right click on the Query Builder
48

Adding a new field
49

Adding a new Filter
50

Now let’s filter by a “range”
51
52

For this example, we will look all the payments
for the month of July 2012
53

Remember, we can “Send To” excel
54

To save, go to “File” and “Save As”
55
56
57

Now right click on “LABOR_CURRENT” and
select “Query Builder”
58

Adding a filter
59
60
61
62

Adding a “Sort”
63

Ascending or Descending
64
65

Combining multiple tables (5) into one query
66
67
68
69

Right click on the top table and select “Query
Builder”
70
71


When joining these, we sometimes see the error
message below.
Usually because column names that are not
actually the same.
72
73
74
75

When combining multiple tables, I usually
RUN the query before doing a Filter.
76

Unfiltered  186,194,858 lines
77
78
79
80
81
82
83
84
85

A lot of information


Hopefully a lot of good/useful information
There is a TON of information out there, so
don’t get afraid to get dirty playing in the data
86