Help using Base SAS procedures

How to select next service day

Accepted Solution Solved
Reply
Regular Contributor
Posts: 240
Accepted Solution

How to select next service day

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


Accepted Solutions
Solution
‎02-18-2014 06:28 PM
Super User
Posts: 17,730

Re: How to select next service day

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

View solution in original post


All Replies
Solution
‎02-18-2014 06:28 PM
Super User
Posts: 17,730

Re: How to select next service day

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

Regular Contributor
Posts: 240

Re: How to select next service day

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

Regular Contributor
Posts: 240

Re: How to select next service day

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

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 206 views
  • 0 likes
  • 2 in conversation