As featured in: Data Management Solutions Using SAS Hash Table Operations: A Business Intelligence Case Study , and built from this github repository.
Chapter9Splits.sas
1 /*******************************************************************
2  Datalines for CHAPTER9SPLITS dataset
3  Generated by %mp_ds2cards()
4  Licensed under GNU, available on github.com/boemska/macrocore
5 ********************************************************************/
6 data template.Chapter9splits ;
7 attrib
8 hashTable length= $32 label="Member Name"
9 Column length= $32 label="Column Name"
10 is_A_Key length= 8
11 ;
12 infile cards dsd delimiter=',';
13 input
14  hashTable :$char.
15  Column :$char.
16  is_A_Key
17 ;
18 datalines4;
19 BYDAYOFWEEK,DayOfWeek,1
20 BYDAYOFWEEK,PAs,0
21 BYDAYOFWEEK,AtBats,0
22 BYDAYOFWEEK,Hits,0
23 BYDAYOFWEEK,BA,0
24 BYDAYOFWEEK,OBP,0
25 BYDAYOFWEEK,SLG,0
26 BYDAYOFWEEK,OPS,0
27 BYDAYOFWEEK,_Bases,0
28 BYDAYOFWEEK,_Reached_Base,0
29 BYMONTH,Month,1
30 BYMONTH,PAs,0
31 BYMONTH,AtBats,0
32 BYMONTH,Hits,0
33 BYMONTH,BA,0
34 BYMONTH,OBP,0
35 BYMONTH,SLG,0
36 BYMONTH,OPS,0
37 BYMONTH,_Bases,0
38 BYMONTH,_Reached_Base,0
39 BYPLAYER,Last_Name,1
40 BYPLAYER,First_Name,1
41 BYPLAYER,Player_ID,1
42 BYPLAYER,PAs,0
43 BYPLAYER,AtBats,0
44 BYPLAYER,Hits,0
45 BYPLAYER,BA,0
46 BYPLAYER,OBP,0
47 BYPLAYER,SLG,0
48 BYPLAYER,OPS,0
49 BYPLAYER,_Bases,0
50 BYPLAYER,_Reached_Base,0
51 BYPLAYERMONTH,Last_Name,1
52 BYPLAYERMONTH,First_Name,1
53 BYPLAYERMONTH,Player_ID,1
54 BYPLAYERMONTH,Month,1
55 BYPLAYERMONTH,PAs,0
56 BYPLAYERMONTH,AtBats,0
57 BYPLAYERMONTH,Hits,0
58 BYPLAYERMONTH,BA,0
59 BYPLAYERMONTH,OBP,0
60 BYPLAYERMONTH,SLG,0
61 BYPLAYERMONTH,OPS,0
62 BYPLAYERMONTH,_Bases,0
63 BYPLAYERMONTH,_Reached_Base,0
64 BYTEAM,Team_Name,1
65 BYTEAM,Team_SK,1
66 BYTEAM,PAs,0
67 BYTEAM,AtBats,0
68 BYTEAM,Hits,0
69 BYTEAM,BA,0
70 BYTEAM,OBP,0
71 BYTEAM,SLG,0
72 BYTEAM,OPS,0
73 BYTEAM,_Bases,0
74 BYTEAM,_Reached_Base,0
75 ;;;;
76 run;
  • Generated by doxygen For more information visit the Bizarro Ball library.