topic Query for next three days if two set of dates are equal in SAS Enterprise Guide

Query for next three days if two set of dates are equal

sdang — Tue, 26 May 2015 22:06:40 GMT

I want to run a query based on the logic below:

If t1.PlayerDayDate=t2.NewEnrollmentDate then get the next three days of t1.PlayerDayDate of that respective patron.

I want to see when a customer enrolled on that day and play (hence playdate=new enrollmentdate) then also get the next three days transaction or play days.

Thanks

Re: Query for next three days if two set of dates are equal

ballardw — Tue, 26 May 2015 23:15:20 GMT

You should provide a couple of small example data sets and what the desired output would look like.

Re: Query for next three days if two set of dates are equal

sdang — Tue, 26 May 2015 23:30:55 GMT

Hi,

Below are the results of filtering t1.PlayerDayDate=t2.NewEnrollmentDate. Now I want the next three PlayerDayDate since the day that they enrolled.

Data are taken from WORK.QUERY_FOR_TOTALGAMINGADDRES_0001

I hope this helps.

Re: Query for next three days if two set of dates are equal

PGStats — Wed, 27 May 2015 02:36:52 GMT

I hope this can be done in EG. Assuming both your dates are datetimes, use INTCK to count the number of days between play and enrolment :

proc sql;

create table nextDays as

select t2.newEnrolmentDate, t1.*

from

PlayerDays as t1 inner join

Enrolments as t2 on

t1.guestNumber=t2.guestNumber and

intck("DTDAY", t2.newEnrolmentDate, t1.PlayerDayDate) between 0 and 3;

quit;

(untested)

Re: Query for next three days if two set of dates are equal

sdang — Wed, 27 May 2015 15:07:19 GMT

Thank you. You solved my problem.

Re: Query for next three days if two set of dates are equal

TomKari — Wed, 27 May 2015 15:26:03 GMT

I haven't tested it, but I believe it would be doable with the EG query builder.

Tom

Re: Query for next three days if two set of dates are equal

sdang — Wed, 27 May 2015 15:28:05 GMT

Thank you!