topic Can I use Proc Timelines to Find the oldest "non broken" date ? in SAS Procedures

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

deleted_user — Fri, 30 Jul 2010 12:44:30 GMT

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

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

ArtC — Mon, 02 Aug 2010 04:02:06 GMT

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?

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

deleted_user — Mon, 02 Aug 2010 14:08:21 GMT

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

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

Cynthia_sas — Mon, 02 Aug 2010 14:58:51 GMT

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/en/etsug/63348/HTML/default/timeseries_toc.htm

and the section on "differencing" is here
http://support.sas.com/documentation/cdl/en/etsug/63348/HTML/default/viewer.htm#/documentation/cdl/en/etsug/63348/HTML/default/etsug_timeseries_sect020.htm (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