As featured in: Data Management Solutions Using SAS Hash Table Operations: A Business Intelligence Case Study , and built from this github repository.
schema_metadata.sas
1 /*******************************************************************
2  Datalines for SCHEMA_METADATA dataset
3  Generated by %mp_ds2cards()
4  Licensed under GNU, available on github.com/boemska/macrocore
5 ********************************************************************/
6 data template.SCHEMA_METADATA ;
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 ATBATS,Game_SK,1
20 ATBATS,Batter_ID,.
21 ATBATS,Position_Code,.
22 ATBATS,Inning,.
23 ATBATS,Top_Bot,.
24 ATBATS,AB_Number,.
25 ATBATS,Result,.
26 ATBATS,Direction,.
27 ATBATS,Distance,.
28 ATBATS,Outs,.
29 ATBATS,Balls,.
30 ATBATS,Strikes,.
31 ATBATS,onFirst,.
32 ATBATS,onSecond,.
33 ATBATS,onThird,.
34 ATBATS,onBase,.
35 ATBATS,Left_On_Base,.
36 ATBATS,Runs,.
37 ATBATS,Is_An_AB,.
38 ATBATS,Is_An_Out,.
39 ATBATS,Is_A_Hit,.
40 ATBATS,Is_An_OnBase,.
41 ATBATS,Bases,.
42 ATBATS,Number_of_Pitches,.
43 CHAPTER10LOOKUPTABLES,hashTable,1
44 CHAPTER10LOOKUPTABLES,Column,.
45 CHAPTER10LOOKUPTABLES,Is_A_Key,.
46 CHAPTER10LOOKUPTABLES,datasetTag,.
47 CHAPTER10SPLITS,hashTable,1
48 CHAPTER10SPLITS,Column,.
49 CHAPTER10SPLITS,is_A_Key,.
50 CHAPTER9PARMFILE,hashTable,1
51 CHAPTER9PARMFILE,Column,.
52 CHAPTER9PARMFILE,is_A_Key,.
53 GAMES,Game_SK,1
54 GAMES,Date,.
55 GAMES,Time,.
56 GAMES,Year,.
57 GAMES,Month,.
58 GAMES,DayOfWeek,.
59 GAMES,League,.
60 GAMES,Home_SK,.
61 GAMES,Away_SK,.
62 LINEUPS,Game_SK,1
63 LINEUPS,Team_SK,.
64 LINEUPS,Batting_Order,.
65 LINEUPS,Player_ID,.
66 LINEUPS,Position_Code,.
67 LINEUPS,Bats,.
68 LINEUPS,Throws,.
69 PITCHES,Game_SK,1
70 PITCHES,Pitcher_ID,.
71 PITCHES,Pitcher_First_Name,.
72 PITCHES,Pitcher_Last_Name,.
73 PITCHES,Pitcher_Type,.
74 PITCHES,Inning,.
75 PITCHES,Top_Bot,.
76 PITCHES,Result,.
77 PITCHES,AB_Number,.
78 PITCHES,Outs,.
79 PITCHES,Balls,.
80 PITCHES,Strikes,.
81 PITCHES,Pitch_Number,.
82 PITCHES,Is_A_Ball,.
83 PITCHES,Is_A_Strike,.
84 PITCHES,onBase,.
85 PLAYERS,Player_ID,1
86 PLAYERS,Team_SK,.
87 PLAYERS,First_Name,.
88 PLAYERS,Last_Name,.
89 PLAYERS,Bats,.
90 PLAYERS,Throws,.
91 PLAYERS,Start_Date,.
92 PLAYERS,End_Date,.
93 PLAYERS_POSITIONS_PLAYED,Player_ID,1
94 PLAYERS_POSITIONS_PLAYED,First,.
95 PLAYERS_POSITIONS_PLAYED,Second,.
96 PLAYERS_POSITIONS_PLAYED,Short,.
97 PLAYERS_POSITIONS_PLAYED,Third,.
98 PLAYERS_POSITIONS_PLAYED,Left,.
99 PLAYERS_POSITIONS_PLAYED,Center,.
100 PLAYERS_POSITIONS_PLAYED,Right,.
101 PLAYERS_POSITIONS_PLAYED,Catcher,.
102 PLAYERS_POSITIONS_PLAYED,Pitcher,.
103 PLAYERS_POSITIONS_PLAYED,Pinch_Hitter,.
104 RUNS,Game_SK,1
105 RUNS,Inning,.
106 RUNS,Top_Bot,.
107 RUNS,AB_Number,.
108 RUNS,Runner_ID,.
109 ;;;;
110 run;
  • Generated by doxygen For more information visit the Bizarro Ball library.