topic Re: How to select next service day in SAS Procedures

How to select next service day

BETO — Tue, 18 Feb 2014 22:26:19 GMT

HI I have a table that has these col

DAte of service ID. Days

2/16/14. T1. Sun Thur

2/16/14 T2. Sun Wed

02/16/14. T3. Sun Tue

02/16/14. T4. Sun

The report is run 2 day lag so Sun report gets run on Tue .WHat report shows is day of service at ID site Days is schedule .

THese were all done Sun . I need to pull only the ones that have next day service that is not today() or tomorrow .

THe first one i would need is the first one and the last one.

THank for your assistance

Re: How to select next service day

Reeza — Tue, 18 Feb 2014 23:28:48 GMT

Your question is difficult to understand, can you rephrase it?

Re: How to select next service day

BETO — Wed, 19 Feb 2014 05:35:17 GMT

HI Reeza,

i was having a hard time with the ask myself ...Sorry

What is being requested is a report to determine what is next day schedule. Example

Date of Service was on Sun 2/16 I pull the report on Tue 2/17. Because there is a lag of time between uploading data. Up to this point I have the data which looks like the table I inserted . From here they want to see only the ones base on schedule for example today is tue so if its schedule today I can exclude if its schedule for tomorrow I can exclude only the ones that are schedule later in the week are needed for the report. Thanks Again

Re: How to select next service day

BETO — Wed, 19 Feb 2014 23:02:17 GMT

HI Reeza I figure it out it took some outside thinking but was able to create a macro that does exactly what I need ...I'm going to close question