Help using Base SAS procedures

Can I use Proc Timelines to Find the oldest "non broken" date ?

Reply
N/A
Posts: 0

Can I use Proc Timelines to Find the oldest "non broken" date ?

In this sample dataset the oldest "non broken" date under MAINREF 1 is the 9 of August 2008 due to overlap from the underlying REF.
The oldest "non broken" date under MAINREF 2 is the 1 of April 2010
(from REF 11 to REF12 there is a non overlapping month.)
Is this possible to find out using PROC TIMELINES
thnk in advance
FROMDATE TODATE MAINREF REF
30-07-2010 01-04-2010 1 1
30-06-2010 01-05-2010 1 2
04-08-2009 09-08-2008 1 3
06-04-2010 03-10-2009 1 2
22-11-2009 25-07-2009 1 1
30-07-2010 01-04-2010 2 11
30-06-2010 01-05-2010 2 12
04-08-2009 09-08-2008 2 13
12-03-2010 03-10-2009 2 12
22-11-2009 25-07-2009 2 11
Valued Guide
Posts: 632

Re: Can I use Proc Timelines to Find the oldest "non broken" date ?

You can find some information about processing episodic data at
http://www2.sas.com/proceedings/sugi29/260-29.pdf

I am unfamiliar with PROC TIMELINES, and do not understand your example are you looking for a break in the dates?
N/A
Posts: 0

Re: Can I use Proc Timelines to Find the oldest "non broken" date ?

Yes. I'am trying to find the break in the dates(under MAINREF 2):
I will take a look, Thanks
30-07-2010 01-04-2010 2 11
30-06-2010 01-05-2010 2 12
04-08-2009 09-08-2008 2 13
12-03-2010 03-10-2009 2 12
22-11-2009 25-07-2009 2 11
SAS Super FREQ
Posts: 8,744

Re: Can I use Proc Timelines to Find the oldest "non broken" date ?

Is there even a PROC TIMELINES???? SAS/ETS has PROC TIMESERIES...
http://support.sas.com/documentation/cdl/en/etsug/63348/HTML/default/viewer.htm#/documentation/cdl/e...

and the section on "differencing" is here
http://support.sas.com/documentation/cdl/en/etsug/63348/HTML/default/viewer.htm#/documentation/cdl/e... (if you understand the math).

Meanwhile, I'm curious how the data goes backward in time...because in the first 2 obs
[pre]
FROMDATE TODATE MAINREF REF
30-07-2010 01-04-2010 1 1
30-06-2010 01-05-2010 1 2
[/pre]

I'd like to figure out how to go FROM July 30 TO April 1 or FROM June 30 TO May 1?? Perhaps someone invented the way-back time machine and I didn't get the memo.

cynthia
Ask a Question
Discussion stats
  • 3 replies
  • 101 views
  • 0 likes
  • 3 in conversation