Show:
Instat Trivia
Specs Please
Gambler's Ruin
A Picture is Worth 1K
Lines of Code
To SQL or not to SQL
100
The official name of Instat in India
What is Instat Clinical Research?
100
The name of the SAS Macro that we use to create the SDTM domains from the Specs GDoc
What is %Create_SDTM?
100
In the game of craps, when two dice are thrown, this combined dice value has the highest probability.
What is 7?
100
This ODS Graphics procedures requires the PANELBY statement.
What is PROC SGPANEL?
100
The two SQL keywords required to make a valid query.
What is SELECT and FROM?
200
Location of the first Instat Event
What is New Jersey?
200
The Wednesday of the month that will be a video Ops call
What is the first Wednesday?
200
The probability of flipping a coin 3 times and getting 3 heads
What is 1 in 8, or 0.125?
200
The name of the new graphing programming subsystem in SAS that ODS Graphics procedures are built on.
What is Graph Template Language (GTL)?
200
The SQL keyword that Kyle doesn't like to use
What is HAVING?
300
The top 2 clients in 2016, based on revenue
What are Celgene and Lexicon?
300
The name of the SAS Macro used to create Unfuddle tickets from the Tables Specs GDoc
What is %pp_cr_tickets?
300
The machine that is programmed to offer the highest payback percentage compared to similar slot games there are on the casino floor.
What is a LOOSE SLOT?
300
This SGPLOT statement is used to plot vertical bars.
What is the VBAR statement?
300
The SQL operator that returns unique values of a column
What is DISTINCT?
400
The number of states Instat is registered to do business
What is 9?
400
The name of the new server folder that will be included in all projects going forward
What is the LOG folder?
400
In the game of roulette, this is the probability of winning when placing a bet on red.
What is 18/38 or .47?
400
The character that separates the graphing statement from the list of options for that statement.
What is the slash (/) character?
400
The SQL equivalent to the data step merge, with in= on your main dataset, and merging by variables with the "if Invar;" on the main dataset.
What is a LEFT JOIN?
500
The month and year Dave will be back at Instat
What is June 2019?
500
These 4 documents/resources together serve as our specifications for programming TLFs
What are the SAP, the mock table shells, the ToC GoogleDoc and Unfuddle tickets.
500
This casino game has the highest "house edge" at a whopping 25%.
What is KENO?
500
These two SGPLOT statements are both needed if you want a line plot with markers on the points also.
What is SCATTER and SERIES?
500
These two aggregate functions will do the same, calculate an average of values in the rows
What is AVG and MEAN?