Hi everyone
I have a csv file structured as
(date=xx/xx/xxxx,time=xx:xx:xx.xxx(millisecond accuracy), var1=xx, var2=yy).
I want to look at autocorrelations of var1, var1*var2 etc at different time lags, e.g 1min, 2min, 10 min. There are several
observation at same date with same minute but at different milliseconds. For some dates or some time (xx:xx:xx),
there is no data also.
I converted date and time to total minutes passed since beginning of cutoff year. I used that variable as timestamp
and calculated mean, std etc for var1, var1*var2 using proc means. However I want to use timeseries procedure
to find out correlations.
SAS website says custom intervals cannot be used with timeseries but there might be another approach to solve this problem.
http://support.sas.com/kb/52/870.html
Do you know how to use minutes for intervals?
I can try to do it manually by defining new variables with different time lags but I need to do more complicated work for the dates/times where
there is no data
Thanks
seckin
p.s:I started learning sas very recently, I appreciate any help/suggestions.
Hello -
You should be able to take advantage of TIMESERIES without using any custom intervals.
Here is an example to illustrate what I'm talking about:
*sashelp.citiday points to a sample data set which features daily data for several measurements;
*work.minmonth will contain min values for each day per month and will written to the WORK library;
proc timeseries data=sashelp.citiday out=work.minmonth;
*in the ID statement you tell TIMESERIES which interval you want to aggregate to - in this case MONTH by specifying the interval option;
*note that month needs to be in a valid SAS date or datetime format;
*if you data is of datetime format you will have to add a DT, for example interval=DTMONTH;
*using the accumulate option you specify how you want to accumulate - in this case only the minimum values are used;
id date interval=month accumulate=min;
*the VAR statement points TIMEDATA to the column of your table you want to use;
var snydjcm;
run;
Hope that helps.
Otherwise please share a sample of your data.
Thanks,
Udo
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.
Find more tutorials on the SAS Users YouTube channel.