Fehler : 0
Warnungen: 0
NOTE: PROZEDUR 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: PROZEDUR IMPORT used (Total process time): real time 0.17 seconds cpu time 0.00 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-Anweisung 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 6 Das SAS System 11:39 Friday, March 21, 20 40 RANGE="parameters"; 41 run; NOTE: The import data set has 5 observations and 2 variables. NOTE: WORK.REFPARM data set was successfully created. NOTE: PROZEDUR 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\_TD3800_HD1PCMS0104_/report1.rtf"; NOTE: Writing RTF Body file: C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD3800_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: PROZEDUR REG used (Total process time): real time 0.40 seconds cpu time 0.14 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: PROZEDUR 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\de/log/006.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/006.lst" ; MPRINT(ENDTESTCALL): RUN;