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