Looping for time series model

[aaileng]

Hey all, I had simulation data with 500 column as replication data, and 1500 rows as number of sample size in a excel file. 

I wish to ask how do i need to do it in loop which ask sas to read the first column then carry on the proc arima and get the AIC, then loop with second column and so on... 

and wish to have all the AIC values in a dataset

Can some one please help me on this? 

ods noproctitle;

ods graphics / imagemap=on;

proc sort data=WORK.IMPORT1 out=Work.preProcessedData;

by Time;

run;

%MACRO DO_BRANCH;

%do i=1 %to 500;

proc timeseries data=Work.preProcessedData seasonality=7 plots=(series corr);

id Time interval=day;

var Data&i / accumulate=none transform=none dif=0 sdif=0;

run;

proc arima data=Work.preProcessedData;

identify var=Data&i;

run;

/*** for multiplicative SARIMA model ***/

estimate q=(1) p=(1)(7) noconstant method=ml;

run;

%end;

%MEND DO_BRANCH;

proc delete data=Work.preProcessedData;

run;

[PaigeMiller]

I'm not an expert on PROC TIMESERIES but you can list multiple variables in the VAR statement.

There is also this, scroll down to the section "The BY way for many models", which talks about PROC REG but the exact same method using a BY statement should work for PROC TIMESERIES and/or PROC ARIMA

https://blogs.sas.com/content/iml/2017/02/13/run-1000-regressions.html

[sbxkoenk]

Hello,

This is the dumbest and slowest way of doing it.

Let us know if you need something more performant, more concise and more smart!

data abc;
 set sashelp.pricedata;
 where region=3;
 where also line=4;
 where also product=13;
run;

PROC SQL noprint;
 create table varnamesarima as
 select *
 from dictionary.columns
 where libname='WORK' and memname='ABC' 
       and type='num' and name NOT IN ('date','cost','region','line','product');
QUIT;

data _NULL_;
 if 0 then set varnamesarima nobs=count;
 call symputx('numbervars',put(count,12.));
 STOP;
run;
%PUT &=numbervars;

%MACRO DO_BRANCH;
%do i=1 %to &numbervars;

data _NULL_;
 set varnamesarima(firstobs=&i. obs=&i.);
 call symputx('currentvar',name);
run;
%PUT §§§§§§§§§§ CURRENT VAR §§§§§§§§§§;
%PUT &=currentvar;
%PUT §§§§§§§§§§ CURRENT VAR §§§§§§§§§§;
 
proc timeseries data=Work.abc seasonality=12 plots=(series corr);
 id date interval=month;
 var &currentvar. / accumulate=none transform=none dif=0 sdif=0;
run;
 
proc arima data=Work.abc;
 identify var=&currentvar.;                     run;
/*** for multiplicative SARIMA model ***/
 estimate q=(1) p=(1)(12) noconstant method=ml; run;
QUIT;
 
%end;
%MEND DO_BRANCH;
%DO_BRANCH
QUIT;
/* end of program */

Koen