As featured in: Data Management Solutions Using SAS Hash Table Operations: A Business Intelligence Case Study , and built from this github repository.
Chapter9LookUpTables.sas
1 /*******************************************************************
2  Datalines for CHAPTER9LOOKUPTABLES dataset
3  Generated by %mp_ds2cards()
4  Licensed under GNU, available on github.com/boemska/macrocore
5 ********************************************************************/
6 data template.Chapter9lookuptables ;
7 attrib
8 hashTable length= $32 label="Member Name"
9 Column length= $32 label="Column Name"
10 Is_A_Key length= 8
11 datasetTag length= $200
12 ;
13 infile cards dsd delimiter=',';
14 input
15  hashTable :$char.
16  Column :$char.
17  Is_A_Key
18  datasetTag :$char.
19 ;
20 datalines4;
21 GAMES,Game_SK,1,DW.GAMES
22 GAMES,Date,0,DW.GAMES
23 GAMES,Time,0,DW.GAMES
24 GAMES,Year,0,DW.GAMES
25 GAMES,Month,0,DW.GAMES
26 GAMES,DayOfWeek,0,DW.GAMES
27 GAMES,League,0,DW.GAMES
28 GAMES,Home_SK,0,DW.GAMES
29 GAMES,Away_SK,0,DW.GAMES
30 PLAYERS,Player_ID,1,DW.PLAYERS
31 PLAYERS,Team_SK,0,DW.PLAYERS
32 PLAYERS,First_Name,0,DW.PLAYERS
33 PLAYERS,Last_Name,0,DW.PLAYERS
34 PLAYERS,Bats,0,DW.PLAYERS
35 PLAYERS,Throws,0,DW.PLAYERS
36 PLAYERS,Start_Date,0,DW.PLAYERS
37 PLAYERS,End_Date,0,DW.PLAYERS
38 TEAMS,Team_SK,1,DW.TEAMS
39 TEAMS,Team_Name,0,DW.TEAMS
40 TEAMS,League_SK,0,DW.TEAMS
41 ;;;;
42 run;