Date: Wed, 15 Jun 2005 20:38:07 +0000
Reply-To: toby dunn <tobydunn@HOTMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: toby dunn <tobydunn@HOTMAIL.COM>
Subject: Re: Any ideas: how to construct series based on 30 second cutoff
In-Reply-To: <1118866777.015115.41370@g49g2000cwa.googlegroups.com>
Content-Type: text/plain; format=flowed
Pani,
Giving us some data would help but to simply increment a date time value
here are two ways:
data one ;
dtstart = '1jun1990:12:00:00'dt;
dtend = intnx('second',dtstart,30) ;
dtend2 = dtstart + 30 ;
format dtstart dtend dtend2 datetime. ;
put dtstart= dtend= dtend2= ;
run ;
Toby Dunn
From: pani1 <chakrapani.chaturvedula@GMAIL.COM>
Reply-To: pani1 <chakrapani.chaturvedula@GMAIL.COM>
To: SAS-L@LISTSERV.UGA.EDU
Subject: Any ideas: how to construct series based on 30 second cutoff
Date: Wed, 15 Jun 2005 13:19:37 -0700
I have to construct a price series with every 30 seconds (so i have to
keep the last price(record) before the 30 second cutoff and remove the
remaining)
I have date, time and other columns.
thanks
pani