▶ Macros | |
createhash.sas | |
generatelineups.sas | |
generatepitchandpadata.sas | |
▶ Programs | |
▶ Templates | |
AtBats.sas | |
Chapter8Parmfile.sas | |
Chapter9LookUpTables.sas | |
Chapter9Splits.sas | |
Games.sas | |
LineUps.sas | |
Pitches.sas | |
Player_Candidates.sas | |
Player_SCD_All.sas | |
Runs.sas | |
schema_metadata.sas | |
autoexec.sas | |
Chapter 10 Implementing a Hash Queue.sas | |
Chapter 10 Implementing a Hash Stack.sas | |
Chapter 10 Selective Unduplication via Hash.sas | |
Chapter 10 Selective Unduplication via Proc SORT + DATA Step.sas | |
Chapter 10 Stable Unduplication via Hash.sas | |
Chapter 10 Testing Data for Grouping via Hash.sas | |
Chapter 10 Unduplication via Proc SORT.sas | |
Chapter 10 Using a Hash Stack to Find Consecutive Events.sas | |
Chapter 11 Array Sorting via Hash.sas | |
Chapter 11 Combined Techniques Join.sas | |
Chapter 11 Frontal Attack Aggregation Inning.sas | |
Chapter 11 Frontal Attack Aggregation.sas | |
Chapter 11 Frontal Attack Join.sas | |
Chapter 11 Frontal Attack Selective Unduplication.sas | |
Chapter 11 Frontal Attack Unduplication.sas | |
Chapter 11 Full Unduplication.sas | |
Chapter 11 Hash Entry Size Test.sas | |
Chapter 11 Hash Index Join.sas | |
Chapter 11 Hash Index Selective Unduplication.sas | |
Chapter 11 Hash Vs SAS Index Access Speed.sas | |
Chapter 11 Key Byte Split By Game_SK Aggregation.sas | |
Chapter 11 Key Byte Split By Game_SK Join.sas | |
Chapter 11 MD5 Key Reduction Aggregation.sas | |
Chapter 11 MD5 Key Reduction Join.sas | |
Chapter 11 MD5 Key Reduction Unduplication.sas | |
Chapter 11 MD5 Split Aggregation on the Fly.sas | |
Chapter 11 MD5 Split Join on the Fly.sas | |
Chapter 11 MD5 Split SAS Index Aggregation.sas | |
Chapter 11 MD5 Split SAS Index Join.sas | |
Chapter 11 Partial Key Split By Inning Aggregation - Code to Assemble.sas | |
Chapter 11 Partial Key Split By Inning Aggregation.sas | |
Chapter 11 Pregrouped Aggregation.sas | |
Chapter 11 Pregrouped Join.sas | |
Chapter 11 Pregrouped Unduplication.sas | |
Chapter 11 Splitting Inning Values via MOD.sas | |
Chapter 12 Pitcher Metrics What-If One Dataset.sas | |
Chapter 12 Pitcher Metrics What-If Updated.sas | |
Chapter 12 Pitcher Metrics What-If.sas | |
Chapter 13 Long At Bats with Initial 0-2 Count.sas | |
Chapter 2 Create Operation Template.sas | |
Chapter 2 Define Hash Variables Selectively Metadata.sas | |
Chapter 2 Define Multiple Hash Variables.sas | |
Chapter 2 HashValues Sample Data set.sas | |
Chapter 2 Number of Hash Items in Given Memory.sas | |
Chapter 3 Direct Explicit Assigned Retrieve.sas | |
Chapter 3 Duplicate-Key Table Ordered 3-Way.sas | |
Chapter 3 Explicit Unassigned Update All.sas | |
Chapter 3 Implicit Method Call Mode Insert from a File.sas | |
Chapter 3 Implicit Method Call Mode Insert.sas | |
Chapter 3 Insertion Order Demo.sas | |
Chapter 3 ORDERED Argument Tag as Expression.sas | |
Chapter 3 Removing an Item.sas | |
Chapter 4 Create and Link Hash Iterator.sas | |
Chapter 4 Enumerate from First Item Forward Snippet.sas | |
Chapter 4 Enumerate from First Item Snippet.sas | |
Chapter 4 Enumerate from Last Item Backward Snippet.sas | |
Chapter 4 Enumerating from Key-Item Snippet.sas | |
Chapter 4 Harvesting Items via Explicit DO_OVER Snippet.sas | |
Chapter 4 Harvesting Items via Explicit FIND and FIND_NEXT Snippet.sas | |
Chapter 4 Harvesting Items via Implicit DO_OVER Snippet.sas | |
Chapter 4 Harvesting Items via Implicit FIND and FIND_NEXT.sas | |
Chapter 4 Harvesting Same Key Items from Key Item Snippet.sas | |
Chapter 4 Iterator Locking Snippet.sas | |
Chapter 4 Iterator Priming Next Method Snippet.sas | |
Chapter 4 Iterator Priming Next Method Terse Snippet.sas | |
Chapter 4 Iterator Priming Prev Method Terse Snippet.sas | |
Chapter 4 Keeping Item List Set Snippet.sas | |
Chapter 4 Keeping Iterator in Table.sas | |
Chapter 4 Keynumerate Loop DO_OVER Snippet.sas | |
Chapter 4 Keynumerate Loop Style2 Snippet.sas | |
Chapter 4 Keynumerate Loop Style3 Snippet.sas | |
Chapter 4 Keynumerate Mechanics Snippet.sas | |
Chapter 4 Locking Same Item Key Group Snippet.sas | |
Chapter 4 Selective Delete Multiple Items Snippet.sas | |
Chapter 4 Selective Delete Single Item Snippet.sas | |
Chapter 4 Selective Update Explicit REPLACEDUP Snippet.sas | |
Chapter 4 Selective Update Snippet.sas | |
Chapter 4 Template Data Step.sas | |
Chapter 5 AssignPlayersToTeams.sas | |
Chapter 5 GenerateDataDriver.sas | |
Chapter 5 GeneratePitchDistribution.sas | |
Chapter 5 GeneratePlayerCandidates.sas | |
Chapter 5 GeneratePositionsDimensionTable.sas | |
Chapter 5 GenerateSchedule.sas | |
Chapter 5 GenerateTeams.sas | |
Chapter 6 Intrinsic Hash Table Grouping.sas | |
Chapter 6 Left Join via Hash Table.sas | |
Chapter 6 Left Join via SQL.sas | |
Chapter 6 Reordering Split Outputs.sas | |
Chapter 6 Sample from AtBats.sas | |
Chapter 6 Sample from Games.sas | |
Chapter 6 Simple Stable Unduplication via Hash.sas | |
Chapter 6 Simple Stable Unduplication via Proc SORT.sas | |
Chapter 6 Simple Subsetting via Hash Table.sas | |
Chapter 6 Simple Subsetting via SQL Subquery.sas | |
Chapter 6 Splitting Data - Hard Coded.sas | |
Chapter 6 Splitting Sorted Data via Hash with DELETE Method.sas | |
Chapter 6 Splitting Sorted Data via Hash with Unique Key.sas | |
Chapter 6 Splitting Sorted Data via Hash.sas | |
Chapter 6 Splitting Unsorted Data via Hash of Hashes.sas | |
Chapter 6 Subsetting via Hash Table with Simple Count.sas | |
Chapter 6 Subsetting via SQL Join with Simple Count.sas | |
Chapter 6 Unique-Key Left or Inner Join via Hash Table.sas | |
Chapter 6 Variation on Left Join via Hash Table with Count.sas | |
Chapter 6 Variation on Left Join via Hash Table with Multiple Aggregates.sas | |
Chapter 7 Create Star Schema DW.sas | |
Chapter 7 SCD 0.sas | |
Chapter 7 SCD 1.sas | |
Chapter 7 SCD 2.sas | |
Chapter 7 SCD 3 w Facts.sas | |
Chapter 7 SCD 3.sas | |
Chapter 7 SCD 6.sas | |
Chapter 7 Update Star Schema DW.sas | |
Chapter 8 Count Consecutive Events Not SUMINC.sas | |
Chapter 8 Count Consecutive Events.sas | |
Chapter 8 Count Multiple Different Consecutive Events.sas | |
Chapter 8 MeanMedianMode.sas | |
Chapter 8 Median.sas | |
Chapter 8 Mode.sas | |
Chapter 8 Multiple Medians Array Error.sas | |
Chapter 8 Multiple Medians.sas | |
Chapter 8 Multiple Splits Parameterized.sas | |
Chapter 8 Multiple Splits.sas | |
Chapter 8 Percentiles.sas | |
Chapter 8 Slash Line with Name.sas | |
Chapter 8 Slash Line with Unique Count.sas | |
Chapter 8 Slash Line.sas | |
Chapter 8 Team and Player Slash Line.sas | |
Chapter 9 HoH Count Consecutive Events.sas | |
Chapter 9 HoH MeanMedianMode.sas | |
Chapter 9 HoH Multiple Medians.sas | |
Chapter 9 HoH Multiple Splits Batter and Pitcher.sas | |
Chapter 9 HoH Multiple Splits with Unique Count.sas | |
Chapter 9 HoH Multiple Splits.sas | |
Chapter 9 HoH Percentiles.sas | |
Chapter 9 Simple HoH.sas | |
importData.sas | |
bizarroball.sas | Auto-generated file |