PROC IMPORT OUT= set1
DATAFILE= "/folders/myfolders/set1.xls"
DBMS=xls REPLACE ;
GETNAMES=YES;
RUN;

PROC IMPORT OUT= set2
DATAFILE= "/folders/myfolders/set2.xls"
DBMS=xls REPLACE ;
GETNAMES=YES;
RUN;

PROC IMPORT OUT= set3
DATAFILE= "/folders/myfolders/set3.xls"
DBMS=xls REPLACE ;
GETNAMES=YES;
RUN;


proc means data=work.Set1 min max mean std;
title 'set1';
var u;
run;
proc means data=work.Set2 min max mean std;
title 'set2';
var u;
run;

proc means data=work.Set3 min max mean std;
title 'set3';
var Units;
run;

proc sgplot data=work.set1;
series x = i y = u;
title 'set1';
run;

proc sgplot data=work.set2;
series x = i y = u;
title 'set2';
run;

proc sgplot data=work.set3;
series x = Month y = Units;
title 'set3';


proc arima data=work.set1;
title 'model set1';
identify var=u(1);
estimate p=0 q=1;
forecast lead=8 id=i out=results1;
run;

proc arima data=work.set2;
title 'model set2';
identify var=u(1);
estimate p=1 q=2;
forecast lead=8 id=i out=results2;
run;

proc arima data=work.set3;
title 'model set3';
identify var=Units(0);
estimate p=1 q=4;
forecast lead=8 id=month out=results3;
run;