In the casino industry, trip defines as total activities within day.  A guest might play table games then turn around and play slot games the next hour; we count that as 1 trip.  However, our data structure divided Slot and Table separate.  A guest can be In two tables within a given day. Below I used inner join for three tables: Guest, Slot, and Table.  The result looks like the picture below. As you can see guest 1001 played total times in one day in TablePlayerDayDate1 even though he/she did not have multiple transactions.  Now how do I get their trips based on their one gaming day? ... View more

Hi, I have two data tables: Table1 and Table2. I want to combine the trips based on the PlayDate.  I don't want this syntax "T1 Trips + T2 Trips" cause this will give me 2 instead of 1 because Customer 1 played only 1 time in the date 2-12-2014: Table 1 PlayDate Trips Customer 1 2/12/2014  1:15am 1 Table2 PlayDate Trip Customer 1 2/12/2014 2:00pm 1 ... View more

How do I know I have proc formatting.  And how do I access it. Is it proc formatting different from "Insert a New Column" in Query Builder?  Using proc formatting, I want to tried some new tricks I learned through SAS online:  CNTLIN DATA LOOKUP; INFILE DATAIN; INPUT      @20 IDNUMBER $CHAR16. ; START = IDNUMBER ; LABEL = 'KEEP' ; FMTNAME = '$LOOKUP'; PROC SORT DATA = LOOKUP OUT = FMT NODUPKEY ; BY START ; PROC FORMAT CNTLIN=FMT; ... View more