topic Re: Time Series Transformations in SAS Programming

Time Series Transformations

SaggiK — Sun, 13 Apr 2014 18:15:21 GMT

Hi all,

I'm using stock (intraday) transaction data recorded at irregular points in time (e.g., 9:45 ; 9:48 ; 9:49).
I want to convert the data to fix time interval so I can perform some statistical time series analysis, for example the stock price every 2 minutes.

I tried using "proc expand", but didn't find a way to do it. Is this kind of conversion possible using "proc expand" or am I looking in the wrong direction?

I saw some examples with proc timeseries - maybe this is a better way of doing it?

Thanks,
Saggi

Re: Time Series Transformations

RichardinOz — Sun, 13 Apr 2014 21:37:35 GMT

try in a data step (or SQL equivalent)

timestat = intnx('MINUTE2', timestamp, 0, 'END') ;

Richard

Message was edited by: Richard Carson - added missing parameter

Re: Time Series Transformations

Ksharp — Mon, 14 Apr 2014 10:33:29 GMT

Yeah. proc expand can achieve that.

data a;
input time : time8. v;
format time time8.;
cards;
09:45 21
09:48 45
09:49 34
09:54 32
10:02 56
;
run;
proc sort data=a; by time;run;
data aa;
 merge a a(firstobs=2 rename=(time=_time));
 output;
 do t=time+60 to coalesce(_time-60,0) by 60;
  time=t;v=.;output;
 end;
drop t _time;
run;
proc expand data=aa out=bb method=spline;
      id time;
   run;

Xia Keshan

Re: Time Series Transformations

SaggiK — Thu, 17 Apr 2014 16:39:09 GMT

Hi All,

Thank you for your solutions.

Regards,

Saggi

Re: Time Series Transformations

udo_sas — Thu, 17 Apr 2014 20:50:29 GMT

Hello Saggi -

As you mentioned earlier you may want to consider PROC TIMESERIES which analyzes time-stamped transactional data with respect to time and accumulates the data into a time series format as yet another option.

An example can be found here: http://support.sas.com/documentation/cdl/en/etsug/66840/HTML/default/viewer.htm#etsug_timeseries_examples01.htm

Thanks,

Udo

Re: Time Series Transformations

SaggiK — Sat, 19 Apr 2014 09:51:16 GMT

Udo,

Thanks you for the reference.

I saw that the example code uses a time interval of a month ("id timestamp interval=month") whereas I want to use a time interval of a second (or millisecond).

I read the proc's syntax but I didn't find any details of the possible frequencies I can use in this option. can you direct me to the relevant documentation?

Thanks again,

Saggi

Re: Time Series Transformations

udo_sas — Mon, 21 Apr 2014 13:18:50 GMT

Saggi -

A list of all supported intervals of the TIMESERIES procedure can be found here: http://support.sas.com/documentation/cdl/en/etsug/66840/HTML/default/viewer.htm#etsug_intervals_sect006.htm

Thanks,

Udo

Re: Time Series Transformations

SaggiK — Tue, 22 Apr 2014 06:50:11 GMT

Udo,

Thank you - this is very helpful.

Saggi