Errors  : 0
Warnings: 0

NOTE: PROCEDURE PRINTTO used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
29         %macro SetXLSType;
30            %if (&sysver=9.1) %then EXCEL; %else XLS;
31         %mend;
NOTE: The macro SETXLSTYPE completed compilation without errors.
      12 instructions 188 bytes.
32         proc import datafile="&g_testdata/regression.xls" dbms=%SetXLSType out=work.data replace;
MPRINT(SETXLSTYPE):  XLS
33            RANGE="data";
34         run;
 
NOTE: The import data set has 10 observations and 3 variables.
NOTE: WORK.DATA data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
 
 
35         data refdata (rename=(yhat=est)) testdata(drop=yhat);
36            set work.data;
37            format _all_;
38         run;
 
NOTE: There were 10 observations read from the data set WORK.DATA.
NOTE: The data set WORK.REFDATA has 10 observations and 3 variables.
NOTE: The data set WORK.TESTDATA has 10 observations and 2 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
 
 
39         proc import datafile="&g_testdata/regression.xls" dbms=%SetXLSType out=refparm replace;
MPRINT(SETXLSTYPE):  XLS
40            RANGE="parameters";
6                                                                                                                        The SAS System                                                                                             11:39 Friday, March 21, 20
 
41         run;
 
NOTE: The import data set has 5 observations and 2 variables.
NOTE: WORK.REFPARM data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
42
43         %regression(data=testdata, x=x, y=y, out=aus, yhat=est, parms=parameters, report=&g_work/report1.rtf)
NOTE: The macro REGRESSION completed compilation without errors.
      22 instructions 748 bytes.
MPRINT(REGRESSION):   ods _all_ close;
MPRINT(REGRESSION):   ods rtf file="C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD3256_HD1PCMS0104_/report1.rtf";
NOTE: Writing RTF Body file: C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD3256_HD1PCMS0104_/report1.rtf
MPRINT(REGRESSION):   proc reg data=testdata outest=parameters;
MPRINT(REGRESSION):   model y = x;
MPRINT(REGRESSION):   output out=aus(keep=x y est) p=est;
MPRINT(REGRESSION):   plot y * x;
MPRINT(REGRESSION):   run;
 
MPRINT(REGRESSION):   quit;
NOTE: The data set WORK.PARAMETERS has 1 observations and 7 variables.
NOTE: The data set WORK.AUS has 10 observations and 3 variables.
NOTE: PROCEDURE REG used (Total process time):
      real time           0.24 seconds
      cpu time            0.10 seconds
 
 
MPRINT(REGRESSION):   ods rtf close;
44
45         proc sql noprint;
46            select intercept into :intercept_sas from parameters;
47            select put (x, best12.) into :slope_sas from parameters;
48            select put (e, best12.) into :slope_xls from refparm;
49            select f into :intercept_xls from refparm;
50         quit;
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
51
52         %assertReport(i_actual=&g_work/report1.rtf, i_expected=&g_testdata/regression.xls,
NOTE: The macro ASSERTREPORT completed compilation without errors.
      154 instructions 4552 bytes.
53                       i_desc=please compare SAS chart with Excel chart)
NOTE: The macro ENDTESTCALL completed compilation without errors.
      67 instructions 2128 bytes.
MPRINT(ENDTESTCALL):   PROC PRINTTO LOG="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\en/log/006.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\en/tst/006.lst" ;
MPRINT(ENDTESTCALL):   RUN;