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.
... View more