QUEST Q3 2006

1
QUEST Q3 2006

• Welcome

2
Agenda

• 530 540 Intro Welcome Michelle Homes
• 540 600 BI Stored Processes a programmatic
  approach Alan Davies
• 600 605 SAS Know It All Session brief
• 605 620 Questy Trivia Michelle Homes
• 620 640 Break and Refreshments
• 640 650 Trivia Answers Michelle Homes
• 650 715 SAS Know It All Session
• 715 745 Social Mixer

3
SAS Know It All Session

• Email questions during the month prior to QUEST
• Get a prize for doing so
• An opportunity to talk about SAS related issues

4
Questy Trivia Question 1

• What is output by put fruititem
• a) fruititem
• b) fruititem
• c) grapefruit
• d) shirazfruit

Given let itemfruit let fruitgrape
let grapeshiraz let shirazred let
grapefruityellow
5
Questy Trivia Question 2

• What is output by put fruititem
• a) fruitfruit
• b) redfruit
• c) shirazfruit
• d) grapefruit

Given let itemfruit let fruitgrape
let grapeshiraz let shirazred let
grapefruityellow
6
Questy Trivia Question 3

• What is output by put fruit fruit
• a) shiraz grape
• b) red shiraz
• c) red red
• d) shiraz shiraz

Given let itemfruit let fruitgrape
let grapeshiraz let shirazred let
grapefruityellow
7
Questy Trivia Question 4

• What is the name of the SAS data view that
  contains the names and values of all macro
  variables available to the session. Including
  automatic and user-definable variables?
• WORK.MACRO
• WORK.VMACRO
• SASHELP.MACRO
• SASHELP.VMACRO

8
Questy Trivia Question 5

• What would be created on the global table as the
  result of the following code
• macro globuild
• do i 1 to 5
• xi
• end
• mend
• global globuild

• x1 x2 x3 x4 x5
• global12345
• globuild12345
• x12345

9
Questy Trivia Question 6

• How many lines will be written to the LOG file
  via the PUT and PUT statements in the following
  data step?
• 9
• 5
• 6
• 3

data test input x _at__at_ put 'THE VALUE OF X
IS ' x put TODAY IS SYSDATE put 'THE
VALUE OF X IS ' x cards 1 2 3 run
10
Questy Trivia Question 7

• What fruit has its seeds on the outside?

11
Questy Trivia Question 8

• You suffer from misopedia. Do you have an
  abnormal aversion to
• a) very large books
• b) children
• c) people who wont spend money
• d) using encyclopaedias

12
Questy Trivia Question 9

• Each year does the Moon move away from the Earth
  by
• a) two inches
• b) two feet
• c) two miles
• d) two kilometres

13
Questy Trivia Question 10

• What is the only mammal that cant jump?

14
Questy Trivia Answer 1

• What is output by put fruititem
• a) fruititem
• b) fruititem
• c) grapefruit
• d) shirazfruit

Given let itemfruit let fruitgrape
let grapeshiraz let shirazred let
grapefruityellow
15
Questy Trivia Answer 2

• What is output by put fruititem
• a) fruitfruit
• b) redfruit
• c) shirazfruit
• d) grapefruit

Given let itemfruit let fruitgrape
let grapeshiraz let shirazred let
grapefruityellow
16
Questy Trivia Answer 3

• What is output by put fruit fruit
• a) shiraz grape
• b) red shiraz
• c) red red
• d) shiraz shiraz

Given let itemfruit let fruitgrape
let grapeshiraz let shirazred let
grapefruityellow
17
Questy Trivia Answer 4

• What is the name of the SAS data view that
  contains the names and values of all macro
  variables available to the session. Including
  automatic and user-definable variables?
• WORK.MACRO
• WORK.VMACRO
• SASHELP.MACRO
• SASHELP.VMACRO

18
Questy Trivia Answer 5

• What would be created on the global table as the
  result of the following code
• macro globuild
• do i 1 to 5
• xi
• end
• mend
• global globuild

• x1 x2 x3 x4 x5
• global12345
• globuild12345
• x12345

19
Questy Trivia Answer 6

• How many lines will be written to the LOG file
  via the PUT and PUT statements in the following
  data step?
• 9
• 5
• 6
• 3

data test input x _at__at_ put 'THE VALUE OF X
IS ' x put TODAY IS SYSDATE put 'THE
VALUE OF X IS ' x cards 1 2 3 run
20
Questy Trivia Question 7

• What fruit has its seeds on the outside?

Strawberry
21
Questy Trivia Question 8

• You suffer from misopedia. Do you have an
  abnormal aversion to
• a) very large books
• b) children
• c) people who wont spend money
• d) using encyclopaedias

22
Questy Trivia Question 9

• Each year does the Moon move away from the Earth
  by
• a) two inches
• b) two feet
• c) two miles
• d) two kilometres

23
Questy Trivia Question 10

• What is the only mammal that cant jump?

Elephant
24
SAS Know It All Session

• SAS Technical Support recap and info
• Fraud Identification
• Questions

25
SAS Technical Support

• Who uses the SAS Technical Support website?
• What can you find on it?
• Why should you spend time using the site?

26
(No Transcript)
27
(No Transcript)
28
(No Transcript)
29
(No Transcript)
30
(No Transcript)
31
Fraud Identification

• Predicting Workers Compensation Insurance Fraud
  Using SAS Enterprise Miner 5.1 and SAS Text Miner
• http//www2.sas.com/proceedings/sugi30/071-30.pdf
  
• Terry Woodfield, SAS Institute
• Fraud Detection A Primer for SAS Programmers
• http//www2.sas.com/proceedings/sugi31/080-31.pdf
  
• Thomas J Winn Jnr, State Auditors Office, Texas
• SAS Fraud Detection and Prevention. Selection of
  articles and whitepapers from UK office.
• http//www.sas.com/offices/europe/uk/solutions/fin
  mgmt/pd_fraud.html
• Peter Dorrington is Head of Fraud Solutions at
  SAS UK you can email him from this webpage
• Data Mining Using SAS Enterprise Miner A Case
  Study Approach, Second Edition
• http//www.sas.com/apps/pubscat/bookdetails.jsp?pc
  59123

32
Questions

• Alan Tsuji Bank of Queensland
• What is proc nickname?

33
Questions

• Is there a way in SAS 9.1 to test if a macro
  variable exists?

34
SYMEXIST function The function returns a value
of 1 if the macro variable exists and a value of
0 if it does not.

• let checksymexist(x) / Note The
  (ampersand) does not precede the macro variable
  name in the argument to the function. /
• / Prior to SAS 9.1 you can use the following
  macro to determine if a macro variable exists
  /
• macro check(mvar)
• local i tmp
• let dsidsysfunc(open(sashelp.vmacro))
• let numsysfunc(varnum(dsid,name))
• do until(ob -1)
• let ieval(i1)
• let obsysfunc(fetchobs(dsid,i))
• let valsysfunc(getvarc(dsid,num))
• if val upcase(mvar) then do
• let ob -1
• let tmpyes
• end
• else do
• let tmpno
• end
• if ob-1 then do