Fehler : 0
Warnungen: 0
1 Das SAS System 11:39 Friday, March 21, 2014 NOTE: Copyright (c) 2002-2010 by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) Proprietary Software 9.3 (TS1M2) Licensed to HMS GMBH WINDOWS SERVER CLIENT 64BIT, Site 70128358. NOTE: This session is executing on the X64_7PRO platform. NOTE: Enhanced analytical products: SAS/STAT 12.1, SAS/ETS 12.1, SAS/OR 12.1, SAS/IML 12.1, SAS/QC 12.1 NOTE: SAS initialization used: real time 0.13 seconds cpu time 0.12 seconds NOTE: The macro _SCENARIO completed compilation without errors. 56 instructions 1692 bytes. MPRINT(_SCENARIO): =MAX; NOTE: The macro _INITERRORHANDLER completed compilation without errors. 24 instructions 444 bytes. MPRINT(_SCENARIO): ; NOTE: The macro _HANDLEERROR completed compilation without errors. 70 instructions 1712 bytes. NOTE: The macro _EXISTDIR completed compilation without errors. 40 instructions 824 bytes. MPRINT(_SCENARIO): LIBNAME target "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de"; NOTE: Libref TARGET was successfully assigned as follows: Engine: V9 Physical Name: c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de NOTE: The macro _LOADENVIRONMENT completed compilation without errors. 213 instructions 7032 bytes. NOTE: The macro _NOBS completed compilation without errors. 32 instructions 640 bytes. MPRINT(_LOADENVIRONMENT): DATA _null_; MPRINT(_LOADENVIRONMENT): SET target.tsu; MPRINT(_LOADENVIRONMENT): call symput ('g_project' , tsu_project); MPRINT(_LOADENVIRONMENT): call symput ('g_root' , tsu_root); MPRINT(_LOADENVIRONMENT): call symput ('g_sasunitroot' , tsu_sasunitroot); MPRINT(_LOADENVIRONMENT): call symput ('g_sasunit' , tsu_sasunit); MPRINT(_LOADENVIRONMENT): call symput ('g_sasunit_os' , tsu_sasunit_os); MPRINT(_LOADENVIRONMENT): call symput ('g_sasautos' , tsu_sasautos); MPRINT(_LOADENVIRONMENT): call symput ('g_sasautos0' , tsu_sasautos); MPRINT(_LOADENVIRONMENT): call symput ("g_sasautos1" , tsu_sasautos1); MPRINT(_LOADENVIRONMENT): call symput ("g_sasautos2" , tsu_sasautos2); MPRINT(_LOADENVIRONMENT): call symput ("g_sasautos3" , tsu_sasautos3); MPRINT(_LOADENVIRONMENT): call symput ("g_sasautos4" , tsu_sasautos4); MPRINT(_LOADENVIRONMENT): call symput ("g_sasautos5" , tsu_sasautos5); MPRINT(_LOADENVIRONMENT): call symput ("g_sasautos6" , tsu_sasautos6); MPRINT(_LOADENVIRONMENT): call symput ("g_sasautos7" , tsu_sasautos7); MPRINT(_LOADENVIRONMENT): call symput ("g_sasautos8" , tsu_sasautos8); MPRINT(_LOADENVIRONMENT): call symput ("g_sasautos9" , tsu_sasautos9); MPRINT(_LOADENVIRONMENT): call symput ('g_autoexec' , tsu_autoexec); MPRINT(_LOADENVIRONMENT): call symput ('g_sascfg' , tsu_sascfg); MPRINT(_LOADENVIRONMENT): call symput ('g_sasuser' , tsu_sasuser); 2 Das SAS System 11:39 Friday, March 21, 20 MPRINT(_LOADENVIRONMENT): call symput ('g_testdata' , tsu_testdata); MPRINT(_LOADENVIRONMENT): call symput ('g_refdata' , tsu_refdata); MPRINT(_LOADENVIRONMENT): call symput ('g_doc' , tsu_doc); MPRINT(_LOADENVIRONMENT): call symput ('g_testcoverage', put (tsu_testcoverage, z1.)); MPRINT(_LOADENVIRONMENT): call symput ('g_verbose' , put (tsu_verbose, z1.)); MPRINT(_LOADENVIRONMENT): RUN; NOTE: There were 1 observations read from the data set TARGET.TSU. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: The macro _ABSPATH completed compilation without errors. 54 instructions 1224 bytes. NOTE: The macro _DETECTSYMBOLS completed compilation without errors. 39 instructions 1268 bytes. MPRINT(_DETECTSYMBOLS): proc printto log=work.detect.note.log new; MPRINT(_DETECTSYMBOLS): run; NOTE: PROZEDUR PRINTTO used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_DETECTSYMBOLS): filename _detect catalog "work.detect.note.log"; MPRINT(_DETECTSYMBOLS): data _null_; MPRINT(_DETECTSYMBOLS): infile _detect truncover; MPRINT(_DETECTSYMBOLS): input line $char256.; MPRINT(_DETECTSYMBOLS): call symput ("g_note", scan(line, 1, ':')); MPRINT(_DETECTSYMBOLS): stop; MPRINT(_DETECTSYMBOLS): run; NOTE: The infile _DETECT is: Catalog Name=WORK.DETECT.NOTE.LOG, Katalogseitengröße=4096, Anzahl der Katalogseiten=4, Erstellt=Freitag, 21. März 2014 11.39 Uhr, Zuletzt geändert=Freitag, 21. März 2014 11.39 Uhr, Dateiname=C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\detect.sas7bcat, Erstellt mit Release=9.0301M2, Erstellt mit Betriebssystem=X64_7PRO NOTE: 1 record was read from the infile _DETECT. The minimum record length was 49. The maximum record length was 49. 3 Das SAS System 11:39 Friday, March 21, 20 NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_DETECTSYMBOLS): filename _detect; NOTE: Fileref _DETECT has been deassigned. MPRINT(_DETECTSYMBOLS): proc datasets lib=work nolist; MPRINT(_DETECTSYMBOLS): delete detect / memtype=catalog; MPRINT(_DETECTSYMBOLS): quit; NOTE: Deleting WORK.DETECT (memtype=CATALOG). NOTE: PROZEDUR DATASETS used (Total process time): real time 0.03 seconds cpu time 0.03 seconds MPRINT(_LOADENVIRONMENT): LIBNAME testout "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst"; NOTE: Libref TESTOUT was successfully assigned as follows: Engine: V9 Physical Name: c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst MPRINT(_LOADENVIRONMENT): FILENAME testout "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst"; MPRINT(_LOADENVIRONMENT): LIBNAME testdata "c:/.jenkins/jobs/SASUnit Build Release ZIP-File/workspace/v1.3/example/dat"; NOTE: Libref TESTDATA was successfully assigned as follows: Engine: V9 Physical Name: c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\dat MPRINT(_LOADENVIRONMENT): FILENAME testdata "c:/.jenkins/jobs/SASUnit Build Release ZIP-File/workspace/v1.3/example/dat"; MPRINT(_LOADENVIRONMENT): LIBNAME refdata "c:/.jenkins/jobs/SASUnit Build Release ZIP-File/workspace/v1.3/example/dat"; NOTE: Libname REFDATA bezieht sich auf dieselbe physische Bibliothek wie TESTDATA. NOTE: Libref REFDATA was successfully assigned as follows: Engine: V9 Physical Name: c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\dat MPRINT(_LOADENVIRONMENT): FILENAME refdata "c:/.jenkins/jobs/SASUnit Build Release ZIP-File/workspace/v1.3/example/dat"; GLOBAL G_SASUSER GLOBAL G_TESTDATA c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\dat GLOBAL G_AUTOEXEC GLOBAL G_DOC GLOBAL G_ERROR ERROR GLOBAL G_PRINTFILE GLOBAL G_ERROR_CODE GLOBAL G_ERROR_MSG GLOBAL G_ERROR_MACRO GLOBAL G_ROOT c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3 GLOBAL G_TESTOUT c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst GLOBAL G_LOG c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log GLOBAL G_SASCFG c:.jenkinsjobsSASUnit Build Release ZIPFileworkspacev1.3/examplebinsasunit.9.3.windows.de.cfg GLOBAL G_SASAUTOS c:.jenkinsjobsSASUnit Build Release ZIPFileworkspacev1.3/examplesaspgm GLOBAL G_SASAUTOS0 c:.jenkinsjobsSASUnit Build Release ZIPFileworkspacev1.3/examplesaspgm GLOBAL G_SASAUTOS1 GLOBAL G_SASAUTOS2 GLOBAL G_SASAUTOS3 GLOBAL G_SASAUTOS4 GLOBAL G_SASAUTOS5 GLOBAL G_SASAUTOS6 4 Das SAS System 11:39 Friday, March 21, 20 GLOBAL G_SASAUTOS7 GLOBAL G_SASAUTOS8 GLOBAL G_SASAUTOS9 GLOBAL G_NOTE NOTE GLOBAL G_VERBOSE 1 GLOBAL G_REFDATA c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\dat GLOBAL G_TESTCOVERAGE 1 GLOBAL G_TARGET c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de GLOBAL G_WARNING WARNING GLOBAL G_PROJECT SASUnit Examples GLOBAL G_SASUNIT c:.jenkinsjobsSASUnit Build Release ZIPFileworkspacev1.3/saspgmsasunit GLOBAL G_SASUNIT_OS c:.jenkinsjobsSASUnit Build Release ZIPFileworkspacev1.3/saspgmsasunitwindows GLOBAL G_WORK C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_ GLOBAL G_LOGFILE GLOBAL G_SASUNITROOT c:.jenkinsjobsSASUnit Build Release ZIPFileworkspacev1.3 MPRINT(_LOADENVIRONMENT): OPTIONS MAUTOSOURCE SASAUTOS=(SASAUTOS "c:/.jenkins/jobs/SASUnit Build Release ZIP-File/workspace/v1.3/saspgm/sasunit" "c:/.jenkins/jobs/SASUnit Build Release ZIP-File/workspace/v1.3/saspgm/sasunit/windows" "c:/.jenkins/jobs/SASUnit Build Release ZIP-File/workspace/v1.3/example/saspgm" ); NOTE: The macro _OSCMDS completed compilation without errors. 35 instructions 808 bytes. MPRINT(_SCENARIO): ; 1 /** 2 \file 3 \ingroup SASUNIT_EXAMPLES_TEST 4 5 \brief Tests for boxplot.sas 6 7 Example for a test scenario with the following features: 8 - check reports manually with assertReport.sas with / without reference 9 - various test cases with different input data 10 - check error handling with assertLogMsg.sas 11 - use test data in library testdata 12 13 \version \$Revision: 315 $ 14 \author \$Author: klandwich $ 15 \date \$Date: 2014-02-28 10:25:18 +0100 (Fr, 28 Feb 2014) $ 16 \sa For further information please refer to <A href="https://sourceforge.net/p/sasunit/wiki/User's%20Guide/" target="_blank">SASUnit User's Guide</A> 17 \sa \$HeadURL: https://svn.code.sf.net/p/sasunit/code/trunk/example/saspgm/boxplot_test.sas $ 18 \copyright Copyright 2010, 2012 HMS Analytical Software GmbH. 19 This file is part of SASUnit, the Unit testing framework for SAS(R) programs. 20 For terms of usage under the GPL license see included file readme.txt 21 or https://sourceforge.net/p/sasunit/wiki/readme.v1.2/. 22 */ /** \cond */ 23 24 /*-- standard case without reference -----------------------------------------*/ 25 %initTestcase(i_object=boxplot.sas, i_desc=standard case without reference) NOTE: The macro INITTESTCASE completed compilation without errors. 99 instructions 2784 bytes. NOTE: The macro LOWCASE completed compilation without errors. 29 instructions 504 bytes. NOTE: The macro _GETAUTOCALLNUMBER completed compilation without errors. 61 instructions 1180 bytes. MPRINT(INITTESTCASE): PROC SQL NOPRINT; MPRINT(INITTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(INITTESTCASE): INSERT INTO target.cas VALUES ( 001 ,1 ,2 ,"boxplot.sas" ,"standard case without reference" , 5 Das SAS System 11:39 Friday, March 21, 20 MPRINT(INITTESTCASE): "" ,1711021158.235 ,. ,. ); NOTE: 1 row was inserted into TARGET.CAS. MPRINT(INITTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== test case 1 ====================================================== MPRINT(INITTESTCASE): PROC PRINTTO NEW LOG="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_001.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_001.lst" ; MPRINT(INITTESTCASE): RUN; NOTE: PROZEDUR PRINTTO used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): UPDATE target.cas SET cas_end = 1711021158.653 WHERE cas_scnid = 001 AND cas_id = 1; NOTE: 1 row was updated in TARGET.CAS. 8 Das SAS System 11:39 Friday, March 21, 20 MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): DATA _null_; MPRINT(ENDTESTCALL): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_001.lst"; MPRINT(ENDTESTCALL): INPUT; MPRINT(ENDTESTCALL): CALL symput ('l_filled','1'); MPRINT(ENDTESTCALL): STOP; MPRINT(ENDTESTCALL): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_001.lst" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\001_001.lst, RECFM=V,LRECL=256,Dateigröße (Byte)=0, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 0 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_001.lst". NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: The macro _DELFILE completed compilation without errors. 26 instructions 552 bytes. MPRINT(ENDTESTCALL): ODS _ALL_ CLOSE; MPRINT(ASSERTREPORT): ; NOTE: The macro _GETEXTENSION completed compilation without errors. 26 instructions 504 bytes. NOTE: The macro _TEMPFILENAME completed compilation without errors. 29 instructions 720 bytes. MPRINT(_TEMPFILENAME): DATA; MPRINT(_TEMPFILENAME): STOP; MPRINT(_TEMPFILENAME): RUN; NOTE: The data set WORK.DATA3 has 0 observations and 0 variables. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE(SASUNIT): Temporary dataset &d_dir is WORK.DATA3 MPRINT(_TEMPFILENAME): PROC SQL NOPRINT; 9 Das SAS System 11:39 Friday, March 21, 20 MPRINT(_TEMPFILENAME): DROP TABLE WORK.DATA3; NOTE: Table WORK.DATA3 has been dropped. MPRINT(_TEMPFILENAME): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: The macro _DIR completed compilation without errors. 88 instructions 3920 bytes. MPRINT(_DIR): proc sql noprint; MPRINT(_DIR): create table WORK.DATA3 (filename char(255)); NOTE: Table WORK.DATA3 created, with 0 rows and 1 columns. MPRINT(_DIR): quit; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_DIR): options noxwait xsync xmin; MPRINT(_DIR): filename _dirfile "C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\___dir.txt" encoding=pcoem850; NOTE(SASUNIT): Directory search is: C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\report1.pdf MPRINT(_DIR): options XWAIT XSYNC NOXMIN; MPRINT(_DIR): data WORK.DATA3 (keep=filename changed); MPRINT(_DIR): length dir filename $255 language $2; MPRINT(_DIR): retain language "__" dir FilePos; MPRINT(_DIR): infile _dirfile truncover; MPRINT(_DIR): input line $char255. @; MPRINT(_DIR): if index (line, "Directory of") or index (line, "Verzeichnis von") then do; MPRINT(_DIR): if index (line, "Directory of") then do; MPRINT(_DIR): dir = substr(line, index (line, "Directory of")+length("Directory of")+1); MPRINT(_DIR): end; MPRINT(_DIR): else do; MPRINT(_DIR): dir = substr(line, index (line, "Verzeichnis von")+length("Verzeichnis von")+1); MPRINT(_DIR): end; MPRINT(_DIR): end; MPRINT(_DIR): if substr(line,1,1) ne ' ' then do; MPRINT(_DIR): * Check for presence of AM/PM in time value, because you can specify AM/PM timeformat in German Windows *; MPRINT(_DIR): if (language = "__") then do; MPRINT(_DIR): Detect_AM_PM = upcase (scan (line, 3, " ")); MPRINT(_DIR): if (Detect_AM_PM in ("AM", "PM")) then do; MPRINT(_DIR): Filenamepart = scan (line,5, " "); MPRINT(_DIR): Filepos = index (line, trim(Filenamepart)); MPRINT(_DIR): language = "EN"; MPRINT(_DIR): end; MPRINT(_DIR): else do; MPRINT(_DIR): Filenamepart = scan (line,4, " "); MPRINT(_DIR): Filepos = index (line, trim(Filenamepart)); MPRINT(_DIR): language = "DE"; MPRINT(_DIR): end; MPRINT(_DIR): end; MPRINT(_DIR): if language='DE' then do; MPRINT(_DIR): input @1 d ddmmyy10. +2 t time5. ; MPRINT(_DIR): end; 10 Das SAS System 11:39 Friday, March 21, 20 MPRINT(_DIR): else do; MPRINT(_DIR): input @1 d mmddyy10. +2 t time9. ; MPRINT(_DIR): end; MPRINT(_DIR): changed = dhms (d, hour(t), minute(t), 0); MPRINT(_DIR): format changed datetime20.; MPRINT(_DIR): filename = translate(trim(dir) !! '/' !! substr (line,FilePos),'/','\'); MPRINT(_DIR): output; MPRINT(_DIR): end; MPRINT(_DIR): run; NOTE: The infile _DIRFILE is: Dateiname=C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\___dir.txt, RECFM=V,LRECL=256,Dateigröße (Byte)=339, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 8 records were read from the infile _DIRFILE. The minimum record length was 0. The maximum record length was 94. NOTE: The data set WORK.DATA3 has 1 observations and 2 variables. NOTE: DATA-Anweisung used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(_DIR): filename _dirfile; NOTE: Fileref _DIRFILE has been deassigned. MPRINT(ASSERTREPORT): data _null_; MPRINT(ASSERTREPORT): set WORK.DATA3 nobs=nobs; MPRINT(ASSERTREPORT): if nobs ne 1 then stop; MPRINT(ASSERTREPORT): if changed < dhms (today(), hour (input ("11:39",time5.)), minute (input ("11:39",time5.)), 0) then do; MPRINT(ASSERTREPORT): stop; MPRINT(ASSERTREPORT): end; MPRINT(ASSERTREPORT): call symput ('l_result', '1'); MPRINT(ASSERTREPORT): stop; MPRINT(ASSERTREPORT): run; NOTE: There were 1 observations read from the data set WORK.DATA3. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ASSERTREPORT): proc sql; MPRINT(ASSERTREPORT): drop table WORK.DATA3; NOTE: Table WORK.DATA3 has been dropped. MPRINT(ASSERTREPORT): quit; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: The macro _GETSCENARIOTESTID completed compilation without errors. 137 instructions 3692 bytes. 11 Das SAS System 11:39 Friday, March 21, 20 MPRINT(_GETSCENARIOTESTID): PROC SQL NOPRINT; MPRINT(_GETSCENARIOTESTID): *** determine number of the current test case ****; MPRINT(_GETSCENARIOTESTID): SELECT max(cas_id) INTO :l_casid_gti FROM target.cas WHERE cas_scnid = 001; MPRINT(_GETSCENARIOTESTID): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_GETSCENARIOTESTID): PROC SQL NOPRINT; MPRINT(_GETSCENARIOTESTID): *** determine number of the current test case ****; MPRINT(_GETSCENARIOTESTID): SELECT max(tst_id) INTO :l_tstid_gti FROM target.tst WHERE tst_scnid = 001 AND tst_casid= 1; MPRINT(_GETSCENARIOTESTID): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ASSERTREPORT): ; NOTE: The macro _CREATETESTSUBFOLDER completed compilation without errors. 65 instructions 1848 bytes. NOTE: The macro _GETTESTSUBFOLDER completed compilation without errors. 112 instructions 2920 bytes. MPRINT(_CREATETESTSUBFOLDER): ; NOTE: The macro _MKDIR completed compilation without errors. 26 instructions 616 bytes. MPRINT(_MKDIR): options noxwait xsync xmin; MPRINT(_MKDIR): options XWAIT XSYNC NOXMIN; MPRINT(_CREATETESTSUBFOLDER): ; MPRINT(ASSERTREPORT): ; NOTE: The macro _COPYFILE completed compilation without errors. 9 instructions 404 bytes. MPRINT(_COPYFILE): DATA _null_; MPRINT(_COPYFILE): INFILE "C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\report1.pdf" RECFM=N LRECL=1048576 LENGTH=l SHAREBUFFERS BLKSIZE=32768; MPRINT(_COPYFILE): FILE "c:/.jenkins/jobs/SASUnit Build Release ZIP-File/workspace/v1.3/example/doc/sasunit/de/tst/_001_001_001_assertreport/_man_act.pdf" RECFM=N LRECL=32768 BLKSIZE=1048576; MPRINT(_COPYFILE): INPUT line $char32767.; MPRINT(_COPYFILE): PUT line $varying32767. l; MPRINT(_COPYFILE): RUN; NOTE: UNBUFFERED is the default with RECFM=N. NOTE: The infile "C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\report1.pdf" is: Dateiname=C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\report1.pdf, RECFM=N,LRECL=1048576,Dateigröße (Byte)=98972, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: UNBUFFERED is the default with RECFM=N. NOTE: The file "c:/.jenkins/jobs/SASUnit Build Release ZIP-File/workspace/v1.3/example/doc/sasunit/de/tst/_001_001_001_assertreport/_man_act.pdf" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\_001_001_001_assertreport\_man_act.pdf, RECFM=N,LRECL=32768,Dateigröße (Byte)=0, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: DATA-Anweisung used (Total process time): 12 Das SAS System 11:39 Friday, March 21, 20 real time 0.00 seconds cpu time 0.00 seconds MPRINT(ASSERTREPORT): ; NOTE: The macro _ASSERTS completed compilation without errors. 152 instructions 4104 bytes. NOTE(SASUNIT): assertReport: assert passed, but manual check necessary. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 1 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 1 ,1 ,"assertReport" ,"please compare chart with specification in source code " ," " ,".pdf " ,1 ,"assertReport: assert passed, but manual check necessary." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 1.1 (assertReport) ===================================== 29 30 /*-- standard case with reference --------------------------------------------*/ 31 %initTestcase(i_object=boxplot.sas, i_desc=standard case with reference) NOTE: The macro ENDTESTCASE completed compilation without errors. 71 instructions 2048 bytes. MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCASE): SELECT count(*) INTO :l_assertLog FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 1 AND tst_type='assertLog'; NOTE: The macro ASSERTLOG completed compilation without errors. 71 instructions 2420 bytes. NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ASSERTLOG): PROC SQL NOPRINT; MPRINT(ASSERTLOG): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(ASSERTLOG): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: The macro _CHECKLOG completed compilation without errors. 32 instructions 1844 bytes. MPRINT(_CHECKLOG): DATA _null_; MPRINT(_CHECKLOG): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_001.log" TRUNCOVER end=eof; MPRINT(_CHECKLOG): INPUT logline $char255.; MPRINT(_CHECKLOG): ATTRIB _errorPatternId LENGTH = 8 _ignoreErrPatternId LENGTH = 8 _warningPatternId LENGTH = 8 _errcount LENGTH = 8 _warncount LENGTH = 8 ; MPRINT(_CHECKLOG): RETAIN _errorPatternId 0 _ignoreErrPatternId 0 _warningPatternId 0 _errcount 0 _warncount 0 ; MPRINT(_CHECKLOG): IF _n_=1 THEN DO; MPRINT(_CHECKLOG): _errorPatternId = prxparse("/^ERROR[: ]/"); MPRINT(_CHECKLOG): _warningPatternId = prxparse("/^WARNING[: ]/"); 13 Das SAS System 11:39 Friday, March 21, 20 MPRINT(_CHECKLOG): _ignoreErrPatternId = prxparse("/^ERROR: Errors printed on page/"); MPRINT(_CHECKLOG): END; MPRINT(_CHECKLOG): IF prxmatch (_errorPatternId, logline) AND (NOT prxmatch (_ignoreErrPatternId, logline)) THEN DO; MPRINT(_CHECKLOG): _errcount = _errcount+1; MPRINT(_CHECKLOG): END; MPRINT(_CHECKLOG): ELSE IF prxmatch (_warningPatternId, logline) THEN DO; MPRINT(_CHECKLOG): _warncount = _warncount+1; MPRINT(_CHECKLOG): END; MPRINT(_CHECKLOG): IF eof THEN DO; MPRINT(_CHECKLOG): CALL symputx ("l_error_count" , put(_errcount,8.)); MPRINT(_CHECKLOG): CALL symputx ("l_warning_count", put(_warncount,8.)); MPRINT(_CHECKLOG): END; MPRINT(_CHECKLOG): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_001.log" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\log\001_001.log, RECFM=V,LRECL=256,Dateigröße (Byte)=6507, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 137 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_001.log". The minimum record length was 0. The maximum record length was 256. One or more lines were truncated. NOTE: DATA-Anweisung used (Total process time): real time 0.01 seconds cpu time 0.01 seconds NOTE(SASUNIT): assertLog: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 1 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 1 ,2 ,"assertLog" ,"Scan log for errors " ,"0#0 " ,"0#0 " ,0 ,"assertLog: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 1.2 (assertLog) ===================================== MPRINT(ENDTESTCASE): QUIT; MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max (tst_res) INTO :l_result FROM target.tst WHERE tst_scnid=001 AND tst_casid=1; MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): UPDATE target.cas SET cas_res = 1 WHERE cas_scnid = 001 AND cas_id = 1; 14 Das SAS System 11:39 Friday, March 21, 20 NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(INITTESTCASE): ; MPRINT(INITTESTCASE): PROC SQL NOPRINT; MPRINT(INITTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(INITTESTCASE): INSERT INTO target.cas VALUES ( 001 ,2 ,2 ,"boxplot.sas" ,"standard case with reference" , MPRINT(INITTESTCASE): "" ,1711021158.777 ,. ,. ); NOTE: 1 row was inserted into TARGET.CAS. MPRINT(INITTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds ========================== test case 2 ====================================================== MPRINT(INITTESTCASE): PROC PRINTTO NEW LOG="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_002.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_002.lst" ; MPRINT(INITTESTCASE): RUN; NOTE: PROZEDUR PRINTTO used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds 17 Das SAS System 11:39 Friday, March 21, 20 cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): UPDATE target.cas SET cas_end = 1711021158.978 WHERE cas_scnid = 001 AND cas_id = 2; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): DATA _null_; MPRINT(ENDTESTCALL): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_002.lst"; MPRINT(ENDTESTCALL): INPUT; MPRINT(ENDTESTCALL): CALL symput ('l_filled','1'); MPRINT(ENDTESTCALL): STOP; MPRINT(ENDTESTCALL): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_002.lst" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\001_002.lst, RECFM=V,LRECL=256,Dateigröße (Byte)=0, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 0 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_002.lst". NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): ODS _ALL_ CLOSE; MPRINT(ASSERTREPORT): ; MPRINT(_TEMPFILENAME): DATA; MPRINT(_TEMPFILENAME): STOP; MPRINT(_TEMPFILENAME): RUN; NOTE: The data set WORK.DATA6 has 0 observations and 0 variables. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE(SASUNIT): Temporary dataset &d_dir is WORK.DATA6 MPRINT(_TEMPFILENAME): PROC SQL NOPRINT; 18 Das SAS System 11:39 Friday, March 21, 20 MPRINT(_TEMPFILENAME): DROP TABLE WORK.DATA6; NOTE: Table WORK.DATA6 has been dropped. MPRINT(_TEMPFILENAME): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_DIR): proc sql noprint; MPRINT(_DIR): create table WORK.DATA6 (filename char(255)); NOTE: Table WORK.DATA6 created, with 0 rows and 1 columns. MPRINT(_DIR): quit; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(_DIR): options noxwait xsync xmin; MPRINT(_DIR): filename _dirfile "C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\___dir.txt" encoding=pcoem850; NOTE(SASUNIT): Directory search is: C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\report2.pdf MPRINT(_DIR): options XWAIT XSYNC NOXMIN; MPRINT(_DIR): data WORK.DATA6 (keep=filename changed); MPRINT(_DIR): length dir filename $255 language $2; MPRINT(_DIR): retain language "__" dir FilePos; MPRINT(_DIR): infile _dirfile truncover; MPRINT(_DIR): input line $char255. @; MPRINT(_DIR): if index (line, "Directory of") or index (line, "Verzeichnis von") then do; MPRINT(_DIR): if index (line, "Directory of") then do; MPRINT(_DIR): dir = substr(line, index (line, "Directory of")+length("Directory of")+1); MPRINT(_DIR): end; MPRINT(_DIR): else do; MPRINT(_DIR): dir = substr(line, index (line, "Verzeichnis von")+length("Verzeichnis von")+1); MPRINT(_DIR): end; MPRINT(_DIR): end; MPRINT(_DIR): if substr(line,1,1) ne ' ' then do; MPRINT(_DIR): * Check for presence of AM/PM in time value, because you can specify AM/PM timeformat in German Windows *; MPRINT(_DIR): if (language = "__") then do; MPRINT(_DIR): Detect_AM_PM = upcase (scan (line, 3, " ")); MPRINT(_DIR): if (Detect_AM_PM in ("AM", "PM")) then do; MPRINT(_DIR): Filenamepart = scan (line,5, " "); MPRINT(_DIR): Filepos = index (line, trim(Filenamepart)); MPRINT(_DIR): language = "EN"; MPRINT(_DIR): end; MPRINT(_DIR): else do; MPRINT(_DIR): Filenamepart = scan (line,4, " "); MPRINT(_DIR): Filepos = index (line, trim(Filenamepart)); MPRINT(_DIR): language = "DE"; MPRINT(_DIR): end; MPRINT(_DIR): end; MPRINT(_DIR): if language='DE' then do; MPRINT(_DIR): input @1 d ddmmyy10. +2 t time5. ; MPRINT(_DIR): end; MPRINT(_DIR): else do; MPRINT(_DIR): input @1 d mmddyy10. +2 t time9. ; 19 Das SAS System 11:39 Friday, March 21, 20 MPRINT(_DIR): end; MPRINT(_DIR): changed = dhms (d, hour(t), minute(t), 0); MPRINT(_DIR): format changed datetime20.; MPRINT(_DIR): filename = translate(trim(dir) !! '/' !! substr (line,FilePos),'/','\'); MPRINT(_DIR): output; MPRINT(_DIR): end; MPRINT(_DIR): run; NOTE: The infile _DIRFILE is: Dateiname=C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\___dir.txt, RECFM=V,LRECL=256,Dateigröße (Byte)=339, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 8 records were read from the infile _DIRFILE. The minimum record length was 0. The maximum record length was 94. NOTE: The data set WORK.DATA6 has 1 observations and 2 variables. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_DIR): filename _dirfile; NOTE: Fileref _DIRFILE has been deassigned. MPRINT(ASSERTREPORT): data _null_; MPRINT(ASSERTREPORT): set WORK.DATA6 nobs=nobs; MPRINT(ASSERTREPORT): if nobs ne 1 then stop; MPRINT(ASSERTREPORT): if changed < dhms (today(), hour (input ("11:39",time5.)), minute (input ("11:39",time5.)), 0) then do; MPRINT(ASSERTREPORT): stop; MPRINT(ASSERTREPORT): end; MPRINT(ASSERTREPORT): call symput ('l_result', '1'); MPRINT(ASSERTREPORT): stop; MPRINT(ASSERTREPORT): run; NOTE: There were 1 observations read from the data set WORK.DATA6. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ASSERTREPORT): proc sql; MPRINT(ASSERTREPORT): drop table WORK.DATA6; NOTE: Table WORK.DATA6 has been dropped. MPRINT(ASSERTREPORT): quit; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_GETSCENARIOTESTID): PROC SQL NOPRINT; MPRINT(_GETSCENARIOTESTID): *** determine number of the current test case ****; MPRINT(_GETSCENARIOTESTID): SELECT max(cas_id) INTO :l_casid_gti FROM target.cas WHERE cas_scnid = 001; MPRINT(_GETSCENARIOTESTID): QUIT; 20 Das SAS System 11:39 Friday, March 21, 20 NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_GETSCENARIOTESTID): PROC SQL NOPRINT; MPRINT(_GETSCENARIOTESTID): *** determine number of the current test case ****; MPRINT(_GETSCENARIOTESTID): SELECT max(tst_id) INTO :l_tstid_gti FROM target.tst WHERE tst_scnid = 001 AND tst_casid= 2; MPRINT(_GETSCENARIOTESTID): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ASSERTREPORT): ; MPRINT(_CREATETESTSUBFOLDER): ; MPRINT(_MKDIR): options noxwait xsync xmin; MPRINT(_MKDIR): options XWAIT XSYNC NOXMIN; MPRINT(_CREATETESTSUBFOLDER): ; MPRINT(ASSERTREPORT): ; MPRINT(_COPYFILE): DATA _null_; MPRINT(_COPYFILE): INFILE "C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\report2.pdf" RECFM=N LRECL=1048576 LENGTH=l SHAREBUFFERS BLKSIZE=32768; MPRINT(_COPYFILE): FILE "c:/.jenkins/jobs/SASUnit Build Release ZIP-File/workspace/v1.3/example/doc/sasunit/de/tst/_001_002_001_assertreport/_man_act.pdf" RECFM=N LRECL=32768 BLKSIZE=1048576; MPRINT(_COPYFILE): INPUT line $char32767.; MPRINT(_COPYFILE): PUT line $varying32767. l; MPRINT(_COPYFILE): RUN; NOTE: UNBUFFERED is the default with RECFM=N. NOTE: The infile "C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\report2.pdf" is: Dateiname=C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\report2.pdf, RECFM=N,LRECL=1048576,Dateigröße (Byte)=98972, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: UNBUFFERED is the default with RECFM=N. NOTE: The file "c:/.jenkins/jobs/SASUnit Build Release ZIP-File/workspace/v1.3/example/doc/sasunit/de/tst/_001_002_001_assertreport/_man_act.pdf" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\_001_002_001_assertreport\_man_act.pdf, RECFM=N,LRECL=32768,Dateigröße (Byte)=0, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ASSERTREPORT): ; MPRINT(_COPYFILE): DATA _null_; MPRINT(_COPYFILE): INFILE "c:/.jenkins/jobs/SASUnit Build Release ZIP-File/workspace/v1.3/example/dat/boxplot1.pdf" RECFM=N LRECL=1048576 LENGTH=l SHAREBUFFERS BLKSIZE=32768; MPRINT(_COPYFILE): FILE "c:/.jenkins/jobs/SASUnit Build Release ZIP-File/workspace/v1.3/example/doc/sasunit/de/tst/_001_002_001_assertreport/_man_exp.pdf" RECFM=N LRECL=32768 BLKSIZE=1048576; MPRINT(_COPYFILE): INPUT line $char32767.; MPRINT(_COPYFILE): PUT line $varying32767. l; MPRINT(_COPYFILE): RUN; 21 Das SAS System 11:39 Friday, March 21, 20 NOTE: UNBUFFERED is the default with RECFM=N. NOTE: The infile "c:/.jenkins/jobs/SASUnit Build Release ZIP-File/workspace/v1.3/example/dat/boxplot1.pdf" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\dat\boxplot1.pdf, RECFM=N,LRECL=1048576,Dateigröße (Byte)=12427, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: UNBUFFERED is the default with RECFM=N. NOTE: The file "c:/.jenkins/jobs/SASUnit Build Release ZIP-File/workspace/v1.3/example/doc/sasunit/de/tst/_001_002_001_assertreport/_man_exp.pdf" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\_001_002_001_assertreport\_man_exp.pdf, RECFM=N,LRECL=32768,Dateigröße (Byte)=0, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ASSERTREPORT): ; NOTE(SASUNIT): assertReport: assert passed, but manual check necessary. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 2 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 2 ,1 ,"assertReport" ,"please compare the two charts " ,".pdf " ,".pdf " ,1 ,"assertReport: assert passed, but manual check necessary." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 2.1 (assertReport) ===================================== 35 36 /*-- standard case with reference, missing values for Y ----------------------*/ 37 %initTestcase(i_object=boxplot.sas, i_desc=%str(standard case with reference, missing values for Y )) MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCASE): SELECT count(*) INTO :l_assertLog FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 2 AND tst_type='assertLog'; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ASSERTLOG): PROC SQL NOPRINT; MPRINT(ASSERTLOG): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(ASSERTLOG): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_CHECKLOG): DATA _null_; 22 Das SAS System 11:39 Friday, March 21, 20 MPRINT(_CHECKLOG): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_002.log" TRUNCOVER end=eof; MPRINT(_CHECKLOG): INPUT logline $char255.; MPRINT(_CHECKLOG): ATTRIB _errorPatternId LENGTH = 8 _ignoreErrPatternId LENGTH = 8 _warningPatternId LENGTH = 8 _errcount LENGTH = 8 _warncount LENGTH = 8 ; MPRINT(_CHECKLOG): RETAIN _errorPatternId 0 _ignoreErrPatternId 0 _warningPatternId 0 _errcount 0 _warncount 0 ; MPRINT(_CHECKLOG): IF _n_=1 THEN DO; MPRINT(_CHECKLOG): _errorPatternId = prxparse("/^ERROR[: ]/"); MPRINT(_CHECKLOG): _warningPatternId = prxparse("/^WARNING[: ]/"); MPRINT(_CHECKLOG): _ignoreErrPatternId = prxparse("/^ERROR: Errors printed on page/"); MPRINT(_CHECKLOG): END; MPRINT(_CHECKLOG): IF prxmatch (_errorPatternId, logline) AND (NOT prxmatch (_ignoreErrPatternId, logline)) THEN DO; MPRINT(_CHECKLOG): _errcount = _errcount+1; MPRINT(_CHECKLOG): END; MPRINT(_CHECKLOG): ELSE IF prxmatch (_warningPatternId, logline) THEN DO; MPRINT(_CHECKLOG): _warncount = _warncount+1; MPRINT(_CHECKLOG): END; MPRINT(_CHECKLOG): IF eof THEN DO; MPRINT(_CHECKLOG): CALL symputx ("l_error_count" , put(_errcount,8.)); MPRINT(_CHECKLOG): CALL symputx ("l_warning_count", put(_warncount,8.)); MPRINT(_CHECKLOG): END; MPRINT(_CHECKLOG): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_002.log" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\log\001_002.log, RECFM=V,LRECL=256,Dateigröße (Byte)=6200, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 131 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_002.log". The minimum record length was 0. The maximum record length was 256. One or more lines were truncated. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE(SASUNIT): assertLog: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 2 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 2 ,2 ,"assertLog" ,"Scan log for errors " ,"0#0 " ,"0#0 " ,0 ,"assertLog: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 2.2 (assertLog) ===================================== MPRINT(ENDTESTCASE): QUIT; MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max (tst_res) INTO :l_result FROM target.tst WHERE tst_scnid=001 AND tst_casid=2; MPRINT(ENDTESTCASE): QUIT; 23 Das SAS System 11:39 Friday, March 21, 20 NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): UPDATE target.cas SET cas_res = 1 WHERE cas_scnid = 001 AND cas_id = 2; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(INITTESTCASE): ; MPRINT(INITTESTCASE): PROC SQL NOPRINT; MPRINT(INITTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(INITTESTCASE): INSERT INTO target.cas VALUES ( 001 ,3 ,2 ,"boxplot.sas" ,"standard case with reference, missing values for Y " , MPRINT(INITTESTCASE): "" ,1711021159.117 ,. ,. ); NOTE: 1 row was inserted into TARGET.CAS. MPRINT(INITTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== test case 3 ====================================================== MPRINT(INITTESTCASE): PROC PRINTTO NEW LOG="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_003.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_003.lst" ; MPRINT(INITTESTCASE): RUN; NOTE: PROZEDUR PRINTTO used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): UPDATE target.cas SET cas_end = 1711021159.334 WHERE cas_scnid = 001 AND cas_id = 3; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): DATA _null_; MPRINT(ENDTESTCALL): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_003.lst"; MPRINT(ENDTESTCALL): INPUT; MPRINT(ENDTESTCALL): CALL symput ('l_filled','1'); MPRINT(ENDTESTCALL): STOP; MPRINT(ENDTESTCALL): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_003.lst" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\001_003.lst, RECFM=V,LRECL=256,Dateigröße (Byte)=0, Zuletzt geändert=21. März 2014 11.39 Uhr, 27 Das SAS System 11:39 Friday, March 21, 20 Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 0 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_003.lst". NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): ODS _ALL_ CLOSE; MPRINT(ASSERTREPORT): ; MPRINT(_TEMPFILENAME): DATA; MPRINT(_TEMPFILENAME): STOP; MPRINT(_TEMPFILENAME): RUN; NOTE: The data set WORK.DATA9 has 0 observations and 0 variables. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE(SASUNIT): Temporary dataset &d_dir is WORK.DATA9 MPRINT(_TEMPFILENAME): PROC SQL NOPRINT; MPRINT(_TEMPFILENAME): DROP TABLE WORK.DATA9; NOTE: Table WORK.DATA9 has been dropped. MPRINT(_TEMPFILENAME): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(_DIR): proc sql noprint; MPRINT(_DIR): create table WORK.DATA9 (filename char(255)); NOTE: Table WORK.DATA9 created, with 0 rows and 1 columns. MPRINT(_DIR): quit; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_DIR): options noxwait xsync xmin; MPRINT(_DIR): filename _dirfile "C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\___dir.txt" encoding=pcoem850; NOTE(SASUNIT): Directory search is: C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\report3.pdf MPRINT(_DIR): options XWAIT XSYNC NOXMIN; MPRINT(_DIR): data WORK.DATA9 (keep=filename changed); MPRINT(_DIR): length dir filename $255 language $2; MPRINT(_DIR): retain language "__" dir FilePos; MPRINT(_DIR): infile _dirfile truncover; MPRINT(_DIR): input line $char255. @; MPRINT(_DIR): if index (line, "Directory of") or index (line, "Verzeichnis von") then do; MPRINT(_DIR): if index (line, "Directory of") then do; MPRINT(_DIR): dir = substr(line, index (line, "Directory of")+length("Directory of")+1); MPRINT(_DIR): end; MPRINT(_DIR): else do; MPRINT(_DIR): dir = substr(line, index (line, "Verzeichnis von")+length("Verzeichnis von")+1); 28 Das SAS System 11:39 Friday, March 21, 20 MPRINT(_DIR): end; MPRINT(_DIR): end; MPRINT(_DIR): if substr(line,1,1) ne ' ' then do; MPRINT(_DIR): * Check for presence of AM/PM in time value, because you can specify AM/PM timeformat in German Windows *; MPRINT(_DIR): if (language = "__") then do; MPRINT(_DIR): Detect_AM_PM = upcase (scan (line, 3, " ")); MPRINT(_DIR): if (Detect_AM_PM in ("AM", "PM")) then do; MPRINT(_DIR): Filenamepart = scan (line,5, " "); MPRINT(_DIR): Filepos = index (line, trim(Filenamepart)); MPRINT(_DIR): language = "EN"; MPRINT(_DIR): end; MPRINT(_DIR): else do; MPRINT(_DIR): Filenamepart = scan (line,4, " "); MPRINT(_DIR): Filepos = index (line, trim(Filenamepart)); MPRINT(_DIR): language = "DE"; MPRINT(_DIR): end; MPRINT(_DIR): end; MPRINT(_DIR): if language='DE' then do; MPRINT(_DIR): input @1 d ddmmyy10. +2 t time5. ; MPRINT(_DIR): end; MPRINT(_DIR): else do; MPRINT(_DIR): input @1 d mmddyy10. +2 t time9. ; MPRINT(_DIR): end; MPRINT(_DIR): changed = dhms (d, hour(t), minute(t), 0); MPRINT(_DIR): format changed datetime20.; MPRINT(_DIR): filename = translate(trim(dir) !! '/' !! substr (line,FilePos),'/','\'); MPRINT(_DIR): output; MPRINT(_DIR): end; MPRINT(_DIR): run; NOTE: The infile _DIRFILE is: Dateiname=C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\___dir.txt, RECFM=V,LRECL=256,Dateigröße (Byte)=339, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 8 records were read from the infile _DIRFILE. The minimum record length was 0. The maximum record length was 94. NOTE: The data set WORK.DATA9 has 1 observations and 2 variables. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_DIR): filename _dirfile; NOTE: Fileref _DIRFILE has been deassigned. MPRINT(ASSERTREPORT): data _null_; MPRINT(ASSERTREPORT): set WORK.DATA9 nobs=nobs; MPRINT(ASSERTREPORT): if nobs ne 1 then stop; MPRINT(ASSERTREPORT): if changed < dhms (today(), hour (input ("11:39",time5.)), minute (input ("11:39",time5.)), 0) then do; MPRINT(ASSERTREPORT): stop; MPRINT(ASSERTREPORT): end; MPRINT(ASSERTREPORT): call symput ('l_result', '1'); 29 Das SAS System 11:39 Friday, March 21, 20 MPRINT(ASSERTREPORT): stop; MPRINT(ASSERTREPORT): run; NOTE: There were 1 observations read from the data set WORK.DATA9. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ASSERTREPORT): proc sql; MPRINT(ASSERTREPORT): drop table WORK.DATA9; NOTE: Table WORK.DATA9 has been dropped. MPRINT(ASSERTREPORT): quit; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(_GETSCENARIOTESTID): PROC SQL NOPRINT; MPRINT(_GETSCENARIOTESTID): *** determine number of the current test case ****; MPRINT(_GETSCENARIOTESTID): SELECT max(cas_id) INTO :l_casid_gti FROM target.cas WHERE cas_scnid = 001; MPRINT(_GETSCENARIOTESTID): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_GETSCENARIOTESTID): PROC SQL NOPRINT; MPRINT(_GETSCENARIOTESTID): *** determine number of the current test case ****; MPRINT(_GETSCENARIOTESTID): SELECT max(tst_id) INTO :l_tstid_gti FROM target.tst WHERE tst_scnid = 001 AND tst_casid= 3; MPRINT(_GETSCENARIOTESTID): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ASSERTREPORT): ; MPRINT(_CREATETESTSUBFOLDER): ; MPRINT(_MKDIR): options noxwait xsync xmin; MPRINT(_MKDIR): options XWAIT XSYNC NOXMIN; MPRINT(_CREATETESTSUBFOLDER): ; MPRINT(ASSERTREPORT): ; MPRINT(_COPYFILE): DATA _null_; MPRINT(_COPYFILE): INFILE "C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\report3.pdf" RECFM=N LRECL=1048576 LENGTH=l SHAREBUFFERS BLKSIZE=32768; MPRINT(_COPYFILE): FILE "c:/.jenkins/jobs/SASUnit Build Release ZIP-File/workspace/v1.3/example/doc/sasunit/de/tst/_001_003_001_assertreport/_man_act.pdf" RECFM=N LRECL=32768 BLKSIZE=1048576; MPRINT(_COPYFILE): INPUT line $char32767.; MPRINT(_COPYFILE): PUT line $varying32767. l; MPRINT(_COPYFILE): RUN; NOTE: UNBUFFERED is the default with RECFM=N. NOTE: The infile "C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\report3.pdf" is: Dateiname=C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\report3.pdf, RECFM=N,LRECL=1048576,Dateigröße (Byte)=98972, Zuletzt geändert=21. März 2014 11.39 Uhr, 30 Das SAS System 11:39 Friday, March 21, 20 Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: UNBUFFERED is the default with RECFM=N. NOTE: The file "c:/.jenkins/jobs/SASUnit Build Release ZIP-File/workspace/v1.3/example/doc/sasunit/de/tst/_001_003_001_assertreport/_man_act.pdf" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\_001_003_001_assertreport\_man_act.pdf, RECFM=N,LRECL=32768,Dateigröße (Byte)=0, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ASSERTREPORT): ; MPRINT(_COPYFILE): DATA _null_; MPRINT(_COPYFILE): INFILE "c:/.jenkins/jobs/SASUnit Build Release ZIP-File/workspace/v1.3/example/dat/boxplot1.pdf" RECFM=N LRECL=1048576 LENGTH=l SHAREBUFFERS BLKSIZE=32768; MPRINT(_COPYFILE): FILE "c:/.jenkins/jobs/SASUnit Build Release ZIP-File/workspace/v1.3/example/doc/sasunit/de/tst/_001_003_001_assertreport/_man_exp.pdf" RECFM=N LRECL=32768 BLKSIZE=1048576; MPRINT(_COPYFILE): INPUT line $char32767.; MPRINT(_COPYFILE): PUT line $varying32767. l; MPRINT(_COPYFILE): RUN; NOTE: UNBUFFERED is the default with RECFM=N. NOTE: The infile "c:/.jenkins/jobs/SASUnit Build Release ZIP-File/workspace/v1.3/example/dat/boxplot1.pdf" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\dat\boxplot1.pdf, RECFM=N,LRECL=1048576,Dateigröße (Byte)=12427, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: UNBUFFERED is the default with RECFM=N. NOTE: The file "c:/.jenkins/jobs/SASUnit Build Release ZIP-File/workspace/v1.3/example/doc/sasunit/de/tst/_001_003_001_assertreport/_man_exp.pdf" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\_001_003_001_assertreport\_man_exp.pdf, RECFM=N,LRECL=32768,Dateigröße (Byte)=0, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ASSERTREPORT): ; NOTE(SASUNIT): assertReport: assert passed, but manual check necessary. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 3 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 3 ,1 ,"assertReport" ,"please compare the two charts, no changes produced by missing values in the y variable " ,".pdf " ,".pdf " ,1 ,"assertReport: assert passed, but manual check necessary." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 31 Das SAS System 11:39 Friday, March 21, 20 ========================== Check 3.1 (assertReport) ===================================== 47 %assertLogMsg(i_logMsg=%str(NOTE: 240 observation\(s\) contained a MISSING value for the SBP \* Visit = Med request|NOTE: 240 Beobachtung\(en\) in fehlendem Wert enthalten für den Befehl SBP \* Visit = Med) NOTE: The macro ASSERTLOGMSG completed compilation without errors. 98 instructions 2864 bytes. 48 ,i_desc=regular expression used to support different languages 49 ) MPRINT(ASSERTLOGMSG): PROC SQL NOPRINT; MPRINT(ASSERTLOGMSG): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(ASSERTLOGMSG): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ASSERTLOGMSG): DATA _null_; MPRINT(ASSERTLOGMSG): RETAIN pattern_id; MPRINT(ASSERTLOGMSG): IF _n_=1 THEN DO; MPRINT(ASSERTLOGMSG): pattern_id = prxparse("/NOTE: 240 OBSERVATION\(S\) CONTAINED A MISSING VALUE FOR THE SBP \* VISIT = MED REQUEST|NOTE: 240 BEOBACHTUNG\(EN\) IN FEHLENDEM WERT ENTHALTEN FÜR DEN BEFEHL SBP \* VISIT = MED/"); MPRINT(ASSERTLOGMSG): END; MPRINT(ASSERTLOGMSG): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_003.log" END=eof TRUNCOVER; MPRINT(ASSERTLOGMSG): INPUT logrec $char256.; MPRINT(ASSERTLOGMSG): logrec = upcase(logrec); MPRINT(ASSERTLOGMSG): IF prxmatch (pattern_id, logrec) THEN DO; MPRINT(ASSERTLOGMSG): call symput ('l_msg_found', '1'); MPRINT(ASSERTLOGMSG): END; MPRINT(ASSERTLOGMSG): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_003.log" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\log\001_003.log, RECFM=V,LRECL=256,Dateigröße (Byte)=6990, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 148 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_003.log". The minimum record length was 0. The maximum record length was 256. One or more lines were truncated. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE(SASUNIT): assertLogMsg: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 3 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 3 ,2 ,"assertLogMsg" ,"regular expression used to support different languages " ,"1NOTE: 240 observation\(s\) contained a MISSING value for the SBP \* Visit = Med request|NOTE: 240 Beobachtung\(en\) in fehlendem Wert enthalten für den Befehl SBP \* Visit = Med " ,"1 " ,0 ,"assertLogMsg: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds 32 Das SAS System 11:39 Friday, March 21, 20 cpu time 0.00 seconds ========================== Check 3.2 (assertLogMsg) ===================================== 50 51 /*-- different scaling for x and y axis --------------------------------------*/ 52 %initTestcase(i_object=boxplot.sas, i_desc=different scaling for x and y axis) MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCASE): SELECT count(*) INTO :l_assertLog FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 3 AND tst_type='assertLog'; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ASSERTLOG): PROC SQL NOPRINT; MPRINT(ASSERTLOG): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(ASSERTLOG): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_CHECKLOG): DATA _null_; MPRINT(_CHECKLOG): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_003.log" TRUNCOVER end=eof; MPRINT(_CHECKLOG): INPUT logline $char255.; MPRINT(_CHECKLOG): ATTRIB _errorPatternId LENGTH = 8 _ignoreErrPatternId LENGTH = 8 _warningPatternId LENGTH = 8 _errcount LENGTH = 8 _warncount LENGTH = 8 ; MPRINT(_CHECKLOG): RETAIN _errorPatternId 0 _ignoreErrPatternId 0 _warningPatternId 0 _errcount 0 _warncount 0 ; MPRINT(_CHECKLOG): IF _n_=1 THEN DO; MPRINT(_CHECKLOG): _errorPatternId = prxparse("/^ERROR[: ]/"); MPRINT(_CHECKLOG): _warningPatternId = prxparse("/^WARNING[: ]/"); MPRINT(_CHECKLOG): _ignoreErrPatternId = prxparse("/^ERROR: Errors printed on page/"); MPRINT(_CHECKLOG): END; MPRINT(_CHECKLOG): IF prxmatch (_errorPatternId, logline) AND (NOT prxmatch (_ignoreErrPatternId, logline)) THEN DO; MPRINT(_CHECKLOG): _errcount = _errcount+1; MPRINT(_CHECKLOG): END; MPRINT(_CHECKLOG): ELSE IF prxmatch (_warningPatternId, logline) THEN DO; MPRINT(_CHECKLOG): _warncount = _warncount+1; MPRINT(_CHECKLOG): END; MPRINT(_CHECKLOG): IF eof THEN DO; MPRINT(_CHECKLOG): CALL symputx ("l_error_count" , put(_errcount,8.)); MPRINT(_CHECKLOG): CALL symputx ("l_warning_count", put(_warncount,8.)); MPRINT(_CHECKLOG): END; MPRINT(_CHECKLOG): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_003.log" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\log\001_003.log, RECFM=V,LRECL=256,Dateigröße (Byte)=6990, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 148 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_003.log". The minimum record length was 0. The maximum record length was 256. 33 Das SAS System 11:39 Friday, March 21, 20 One or more lines were truncated. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE(SASUNIT): assertLog: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 3 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 3 ,3 ,"assertLog" ,"Scan log for errors " ,"0#0 " ,"0#0 " ,0 ,"assertLog: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 3.3 (assertLog) ===================================== MPRINT(ENDTESTCASE): QUIT; MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max (tst_res) INTO :l_result FROM target.tst WHERE tst_scnid=001 AND tst_casid=3; MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): UPDATE target.cas SET cas_res = 1 WHERE cas_scnid = 001 AND cas_id = 3; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(INITTESTCASE): ; MPRINT(INITTESTCASE): PROC SQL NOPRINT; MPRINT(INITTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(INITTESTCASE): INSERT INTO target.cas VALUES ( 001 ,4 ,2 ,"boxplot.sas" ,"different scaling for x and y axis" , MPRINT(INITTESTCASE): "" ,1711021159.442 ,. ,. ); NOTE: 1 row was inserted into TARGET.CAS. MPRINT(INITTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== test case 4 ====================================================== MPRINT(INITTESTCASE): PROC PRINTTO NEW LOG="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_004.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release 34 Das SAS System 11:39 Friday, March 21, 20 ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_004.lst" ; MPRINT(INITTESTCASE): RUN; NOTE: PROZEDUR PRINTTO used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): UPDATE target.cas SET cas_end = 1711021159.659 WHERE cas_scnid = 001 AND cas_id = 4; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds 37 Das SAS System 11:39 Friday, March 21, 20 cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): DATA _null_; MPRINT(ENDTESTCALL): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_004.lst"; MPRINT(ENDTESTCALL): INPUT; MPRINT(ENDTESTCALL): CALL symput ('l_filled','1'); MPRINT(ENDTESTCALL): STOP; MPRINT(ENDTESTCALL): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_004.lst" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\001_004.lst, RECFM=V,LRECL=256,Dateigröße (Byte)=0, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 0 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_004.lst". NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): ODS _ALL_ CLOSE; MPRINT(ASSERTREPORT): ; MPRINT(_TEMPFILENAME): DATA; MPRINT(_TEMPFILENAME): STOP; MPRINT(_TEMPFILENAME): RUN; NOTE: The data set WORK.DATA12 has 0 observations and 0 variables. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE(SASUNIT): Temporary dataset &d_dir is WORK.DATA12 MPRINT(_TEMPFILENAME): PROC SQL NOPRINT; MPRINT(_TEMPFILENAME): DROP TABLE WORK.DATA12; NOTE: Table WORK.DATA12 has been dropped. MPRINT(_TEMPFILENAME): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_DIR): proc sql noprint; MPRINT(_DIR): create table WORK.DATA12 (filename char(255)); 38 Das SAS System 11:39 Friday, March 21, 20 NOTE: Table WORK.DATA12 created, with 0 rows and 1 columns. MPRINT(_DIR): quit; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(_DIR): options noxwait xsync xmin; MPRINT(_DIR): filename _dirfile "C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\___dir.txt" encoding=pcoem850; NOTE(SASUNIT): Directory search is: C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\report4.pdf MPRINT(_DIR): options XWAIT XSYNC NOXMIN; MPRINT(_DIR): data WORK.DATA12 (keep=filename changed); MPRINT(_DIR): length dir filename $255 language $2; MPRINT(_DIR): retain language "__" dir FilePos; MPRINT(_DIR): infile _dirfile truncover; MPRINT(_DIR): input line $char255. @; MPRINT(_DIR): if index (line, "Directory of") or index (line, "Verzeichnis von") then do; MPRINT(_DIR): if index (line, "Directory of") then do; MPRINT(_DIR): dir = substr(line, index (line, "Directory of")+length("Directory of")+1); MPRINT(_DIR): end; MPRINT(_DIR): else do; MPRINT(_DIR): dir = substr(line, index (line, "Verzeichnis von")+length("Verzeichnis von")+1); MPRINT(_DIR): end; MPRINT(_DIR): end; MPRINT(_DIR): if substr(line,1,1) ne ' ' then do; MPRINT(_DIR): * Check for presence of AM/PM in time value, because you can specify AM/PM timeformat in German Windows *; MPRINT(_DIR): if (language = "__") then do; MPRINT(_DIR): Detect_AM_PM = upcase (scan (line, 3, " ")); MPRINT(_DIR): if (Detect_AM_PM in ("AM", "PM")) then do; MPRINT(_DIR): Filenamepart = scan (line,5, " "); MPRINT(_DIR): Filepos = index (line, trim(Filenamepart)); MPRINT(_DIR): language = "EN"; MPRINT(_DIR): end; MPRINT(_DIR): else do; MPRINT(_DIR): Filenamepart = scan (line,4, " "); MPRINT(_DIR): Filepos = index (line, trim(Filenamepart)); MPRINT(_DIR): language = "DE"; MPRINT(_DIR): end; MPRINT(_DIR): end; MPRINT(_DIR): if language='DE' then do; MPRINT(_DIR): input @1 d ddmmyy10. +2 t time5. ; MPRINT(_DIR): end; MPRINT(_DIR): else do; MPRINT(_DIR): input @1 d mmddyy10. +2 t time9. ; MPRINT(_DIR): end; MPRINT(_DIR): changed = dhms (d, hour(t), minute(t), 0); MPRINT(_DIR): format changed datetime20.; MPRINT(_DIR): filename = translate(trim(dir) !! '/' !! substr (line,FilePos),'/','\'); MPRINT(_DIR): output; MPRINT(_DIR): end; MPRINT(_DIR): run; NOTE: The infile _DIRFILE is: Dateiname=C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\___dir.txt, 39 Das SAS System 11:39 Friday, March 21, 20 RECFM=V,LRECL=256,Dateigröße (Byte)=339, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 8 records were read from the infile _DIRFILE. The minimum record length was 0. The maximum record length was 94. NOTE: The data set WORK.DATA12 has 1 observations and 2 variables. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_DIR): filename _dirfile; NOTE: Fileref _DIRFILE has been deassigned. MPRINT(ASSERTREPORT): data _null_; MPRINT(ASSERTREPORT): set WORK.DATA12 nobs=nobs; MPRINT(ASSERTREPORT): if nobs ne 1 then stop; MPRINT(ASSERTREPORT): if changed < dhms (today(), hour (input ("11:39",time5.)), minute (input ("11:39",time5.)), 0) then do; MPRINT(ASSERTREPORT): stop; MPRINT(ASSERTREPORT): end; MPRINT(ASSERTREPORT): call symput ('l_result', '1'); MPRINT(ASSERTREPORT): stop; MPRINT(ASSERTREPORT): run; NOTE: There were 1 observations read from the data set WORK.DATA12. NOTE: DATA-Anweisung used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(ASSERTREPORT): proc sql; MPRINT(ASSERTREPORT): drop table WORK.DATA12; NOTE: Table WORK.DATA12 has been dropped. MPRINT(ASSERTREPORT): quit; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_GETSCENARIOTESTID): PROC SQL NOPRINT; MPRINT(_GETSCENARIOTESTID): *** determine number of the current test case ****; MPRINT(_GETSCENARIOTESTID): SELECT max(cas_id) INTO :l_casid_gti FROM target.cas WHERE cas_scnid = 001; MPRINT(_GETSCENARIOTESTID): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_GETSCENARIOTESTID): PROC SQL NOPRINT; MPRINT(_GETSCENARIOTESTID): *** determine number of the current test case ****; MPRINT(_GETSCENARIOTESTID): SELECT max(tst_id) INTO :l_tstid_gti FROM target.tst WHERE tst_scnid = 001 AND tst_casid= 4; MPRINT(_GETSCENARIOTESTID): QUIT; NOTE: PROZEDUR SQL used (Total process time): 40 Das SAS System 11:39 Friday, March 21, 20 real time 0.00 seconds cpu time 0.00 seconds MPRINT(ASSERTREPORT): ; MPRINT(_CREATETESTSUBFOLDER): ; MPRINT(_MKDIR): options noxwait xsync xmin; MPRINT(_MKDIR): options XWAIT XSYNC NOXMIN; MPRINT(_CREATETESTSUBFOLDER): ; MPRINT(ASSERTREPORT): ; MPRINT(_COPYFILE): DATA _null_; MPRINT(_COPYFILE): INFILE "C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\report4.pdf" RECFM=N LRECL=1048576 LENGTH=l SHAREBUFFERS BLKSIZE=32768; MPRINT(_COPYFILE): FILE "c:/.jenkins/jobs/SASUnit Build Release ZIP-File/workspace/v1.3/example/doc/sasunit/de/tst/_001_004_001_assertreport/_man_act.pdf" RECFM=N LRECL=32768 BLKSIZE=1048576; MPRINT(_COPYFILE): INPUT line $char32767.; MPRINT(_COPYFILE): PUT line $varying32767. l; MPRINT(_COPYFILE): RUN; NOTE: UNBUFFERED is the default with RECFM=N. NOTE: The infile "C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\report4.pdf" is: Dateiname=C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\report4.pdf, RECFM=N,LRECL=1048576,Dateigröße (Byte)=98969, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: UNBUFFERED is the default with RECFM=N. NOTE: The file "c:/.jenkins/jobs/SASUnit Build Release ZIP-File/workspace/v1.3/example/doc/sasunit/de/tst/_001_004_001_assertreport/_man_act.pdf" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\_001_004_001_assertreport\_man_act.pdf, RECFM=N,LRECL=32768,Dateigröße (Byte)=0, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ASSERTREPORT): ; NOTE(SASUNIT): assertReport: assert passed, but manual check necessary. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 4 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 4 ,1 ,"assertReport" ,"please compare chart with specification in source code " ," " ,".pdf " ,1 ,"assertReport: assert passed, but manual check necessary." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds ========================== Check 4.1 (assertReport) ===================================== 61 62 /*-- only two visits ---------------------------------------------------------*/ 63 %initTestcase(i_object=boxplot.sas, i_desc=only two visits) 41 Das SAS System 11:39 Friday, March 21, 20 MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCASE): SELECT count(*) INTO :l_assertLog FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 4 AND tst_type='assertLog'; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ASSERTLOG): PROC SQL NOPRINT; MPRINT(ASSERTLOG): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(ASSERTLOG): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_CHECKLOG): DATA _null_; MPRINT(_CHECKLOG): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_004.log" TRUNCOVER end=eof; MPRINT(_CHECKLOG): INPUT logline $char255.; MPRINT(_CHECKLOG): ATTRIB _errorPatternId LENGTH = 8 _ignoreErrPatternId LENGTH = 8 _warningPatternId LENGTH = 8 _errcount LENGTH = 8 _warncount LENGTH = 8 ; MPRINT(_CHECKLOG): RETAIN _errorPatternId 0 _ignoreErrPatternId 0 _warningPatternId 0 _errcount 0 _warncount 0 ; MPRINT(_CHECKLOG): IF _n_=1 THEN DO; MPRINT(_CHECKLOG): _errorPatternId = prxparse("/^ERROR[: ]/"); MPRINT(_CHECKLOG): _warningPatternId = prxparse("/^WARNING[: ]/"); MPRINT(_CHECKLOG): _ignoreErrPatternId = prxparse("/^ERROR: Errors printed on page/"); MPRINT(_CHECKLOG): END; MPRINT(_CHECKLOG): IF prxmatch (_errorPatternId, logline) AND (NOT prxmatch (_ignoreErrPatternId, logline)) THEN DO; MPRINT(_CHECKLOG): _errcount = _errcount+1; MPRINT(_CHECKLOG): END; MPRINT(_CHECKLOG): ELSE IF prxmatch (_warningPatternId, logline) THEN DO; MPRINT(_CHECKLOG): _warncount = _warncount+1; MPRINT(_CHECKLOG): END; MPRINT(_CHECKLOG): IF eof THEN DO; MPRINT(_CHECKLOG): CALL symputx ("l_error_count" , put(_errcount,8.)); MPRINT(_CHECKLOG): CALL symputx ("l_warning_count", put(_warncount,8.)); MPRINT(_CHECKLOG): END; MPRINT(_CHECKLOG): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_004.log" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\log\001_004.log, RECFM=V,LRECL=256,Dateigröße (Byte)=6616, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 144 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_004.log". The minimum record length was 0. The maximum record length was 256. One or more lines were truncated. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE(SASUNIT): assertLog: assert passed. 42 Das SAS System 11:39 Friday, March 21, 20 MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 4 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 4 ,2 ,"assertLog" ,"Scan log for errors " ,"0#0 " ,"0#0 " ,0 ,"assertLog: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 4.2 (assertLog) ===================================== MPRINT(ENDTESTCASE): QUIT; MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max (tst_res) INTO :l_result FROM target.tst WHERE tst_scnid=001 AND tst_casid=4; MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): UPDATE target.cas SET cas_res = 1 WHERE cas_scnid = 001 AND cas_id = 4; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(INITTESTCASE): ; MPRINT(INITTESTCASE): PROC SQL NOPRINT; MPRINT(INITTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(INITTESTCASE): INSERT INTO target.cas VALUES ( 001 ,5 ,2 ,"boxplot.sas" ,"only two visits" , MPRINT(INITTESTCASE): "" ,1711021159.751 ,. ,. ); NOTE: 1 row was inserted into TARGET.CAS. MPRINT(INITTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== test case 5 ====================================================== MPRINT(INITTESTCASE): PROC PRINTTO NEW LOG="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_005.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_005.lst" ; MPRINT(INITTESTCASE): RUN; NOTE: PROZEDUR PRINTTO used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): UPDATE target.cas SET cas_end = 1711021159.952 WHERE cas_scnid = 001 AND cas_id = 5; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): 46 Das SAS System 11:39 Friday, March 21, 20 real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): DATA _null_; MPRINT(ENDTESTCALL): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_005.lst"; MPRINT(ENDTESTCALL): INPUT; MPRINT(ENDTESTCALL): CALL symput ('l_filled','1'); MPRINT(ENDTESTCALL): STOP; MPRINT(ENDTESTCALL): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_005.lst" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\001_005.lst, RECFM=V,LRECL=256,Dateigröße (Byte)=0, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 0 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_005.lst". NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): ODS _ALL_ CLOSE; MPRINT(ASSERTREPORT): ; MPRINT(_TEMPFILENAME): DATA; MPRINT(_TEMPFILENAME): STOP; MPRINT(_TEMPFILENAME): RUN; NOTE: The data set WORK.DATA15 has 0 observations and 0 variables. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE(SASUNIT): Temporary dataset &d_dir is WORK.DATA15 MPRINT(_TEMPFILENAME): PROC SQL NOPRINT; MPRINT(_TEMPFILENAME): DROP TABLE WORK.DATA15; NOTE: Table WORK.DATA15 has been dropped. MPRINT(_TEMPFILENAME): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_DIR): proc sql noprint; MPRINT(_DIR): create table WORK.DATA15 (filename char(255)); NOTE: Table WORK.DATA15 created, with 0 rows and 1 columns. MPRINT(_DIR): quit; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 47 Das SAS System 11:39 Friday, March 21, 20 MPRINT(_DIR): options noxwait xsync xmin; MPRINT(_DIR): filename _dirfile "C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\___dir.txt" encoding=pcoem850; NOTE(SASUNIT): Directory search is: C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\report5.pdf MPRINT(_DIR): options XWAIT XSYNC NOXMIN; MPRINT(_DIR): data WORK.DATA15 (keep=filename changed); MPRINT(_DIR): length dir filename $255 language $2; MPRINT(_DIR): retain language "__" dir FilePos; MPRINT(_DIR): infile _dirfile truncover; MPRINT(_DIR): input line $char255. @; MPRINT(_DIR): if index (line, "Directory of") or index (line, "Verzeichnis von") then do; MPRINT(_DIR): if index (line, "Directory of") then do; MPRINT(_DIR): dir = substr(line, index (line, "Directory of")+length("Directory of")+1); MPRINT(_DIR): end; MPRINT(_DIR): else do; MPRINT(_DIR): dir = substr(line, index (line, "Verzeichnis von")+length("Verzeichnis von")+1); MPRINT(_DIR): end; MPRINT(_DIR): end; MPRINT(_DIR): if substr(line,1,1) ne ' ' then do; MPRINT(_DIR): * Check for presence of AM/PM in time value, because you can specify AM/PM timeformat in German Windows *; MPRINT(_DIR): if (language = "__") then do; MPRINT(_DIR): Detect_AM_PM = upcase (scan (line, 3, " ")); MPRINT(_DIR): if (Detect_AM_PM in ("AM", "PM")) then do; MPRINT(_DIR): Filenamepart = scan (line,5, " "); MPRINT(_DIR): Filepos = index (line, trim(Filenamepart)); MPRINT(_DIR): language = "EN"; MPRINT(_DIR): end; MPRINT(_DIR): else do; MPRINT(_DIR): Filenamepart = scan (line,4, " "); MPRINT(_DIR): Filepos = index (line, trim(Filenamepart)); MPRINT(_DIR): language = "DE"; MPRINT(_DIR): end; MPRINT(_DIR): end; MPRINT(_DIR): if language='DE' then do; MPRINT(_DIR): input @1 d ddmmyy10. +2 t time5. ; MPRINT(_DIR): end; MPRINT(_DIR): else do; MPRINT(_DIR): input @1 d mmddyy10. +2 t time9. ; MPRINT(_DIR): end; MPRINT(_DIR): changed = dhms (d, hour(t), minute(t), 0); MPRINT(_DIR): format changed datetime20.; MPRINT(_DIR): filename = translate(trim(dir) !! '/' !! substr (line,FilePos),'/','\'); MPRINT(_DIR): output; MPRINT(_DIR): end; MPRINT(_DIR): run; NOTE: The infile _DIRFILE is: Dateiname=C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\___dir.txt, RECFM=V,LRECL=256,Dateigröße (Byte)=339, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 8 records were read from the infile _DIRFILE. The minimum record length was 0. The maximum record length was 94. 48 Das SAS System 11:39 Friday, March 21, 20 NOTE: The data set WORK.DATA15 has 1 observations and 2 variables. NOTE: DATA-Anweisung used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(_DIR): filename _dirfile; NOTE: Fileref _DIRFILE has been deassigned. MPRINT(ASSERTREPORT): data _null_; MPRINT(ASSERTREPORT): set WORK.DATA15 nobs=nobs; MPRINT(ASSERTREPORT): if nobs ne 1 then stop; MPRINT(ASSERTREPORT): if changed < dhms (today(), hour (input ("11:39",time5.)), minute (input ("11:39",time5.)), 0) then do; MPRINT(ASSERTREPORT): stop; MPRINT(ASSERTREPORT): end; MPRINT(ASSERTREPORT): call symput ('l_result', '1'); MPRINT(ASSERTREPORT): stop; MPRINT(ASSERTREPORT): run; NOTE: There were 1 observations read from the data set WORK.DATA15. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ASSERTREPORT): proc sql; MPRINT(ASSERTREPORT): drop table WORK.DATA15; NOTE: Table WORK.DATA15 has been dropped. MPRINT(ASSERTREPORT): quit; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_GETSCENARIOTESTID): PROC SQL NOPRINT; MPRINT(_GETSCENARIOTESTID): *** determine number of the current test case ****; MPRINT(_GETSCENARIOTESTID): SELECT max(cas_id) INTO :l_casid_gti FROM target.cas WHERE cas_scnid = 001; MPRINT(_GETSCENARIOTESTID): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_GETSCENARIOTESTID): PROC SQL NOPRINT; MPRINT(_GETSCENARIOTESTID): *** determine number of the current test case ****; MPRINT(_GETSCENARIOTESTID): SELECT max(tst_id) INTO :l_tstid_gti FROM target.tst WHERE tst_scnid = 001 AND tst_casid= 5; MPRINT(_GETSCENARIOTESTID): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ASSERTREPORT): ; MPRINT(_CREATETESTSUBFOLDER): ; MPRINT(_MKDIR): options noxwait xsync xmin; 49 Das SAS System 11:39 Friday, March 21, 20 MPRINT(_MKDIR): options XWAIT XSYNC NOXMIN; MPRINT(_CREATETESTSUBFOLDER): ; MPRINT(ASSERTREPORT): ; MPRINT(_COPYFILE): DATA _null_; MPRINT(_COPYFILE): INFILE "C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\report5.pdf" RECFM=N LRECL=1048576 LENGTH=l SHAREBUFFERS BLKSIZE=32768; MPRINT(_COPYFILE): FILE "c:/.jenkins/jobs/SASUnit Build Release ZIP-File/workspace/v1.3/example/doc/sasunit/de/tst/_001_005_001_assertreport/_man_act.pdf" RECFM=N LRECL=32768 BLKSIZE=1048576; MPRINT(_COPYFILE): INPUT line $char32767.; MPRINT(_COPYFILE): PUT line $varying32767. l; MPRINT(_COPYFILE): RUN; NOTE: UNBUFFERED is the default with RECFM=N. NOTE: The infile "C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\report5.pdf" is: Dateiname=C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\report5.pdf, RECFM=N,LRECL=1048576,Dateigröße (Byte)=98320, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: UNBUFFERED is the default with RECFM=N. NOTE: The file "c:/.jenkins/jobs/SASUnit Build Release ZIP-File/workspace/v1.3/example/doc/sasunit/de/tst/_001_005_001_assertreport/_man_act.pdf" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\_001_005_001_assertreport\_man_act.pdf, RECFM=N,LRECL=32768,Dateigröße (Byte)=0, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ASSERTREPORT): ; NOTE(SASUNIT): assertReport: assert passed, but manual check necessary. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 5 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 5 ,1 ,"assertReport" ,"please compare chart with specification in source code " ," " ,".pdf " ,1 ,"assertReport: assert passed, but manual check necessary." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 5.1 (assertReport) ===================================== 71 72 /*-- Error: only one visit ---------------------------------------------------*/ 73 %initTestcase(i_object=boxplot.sas, i_desc=only one visit) MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCASE): SELECT count(*) INTO :l_assertLog FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 5 AND tst_type='assertLog'; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 50 Das SAS System 11:39 Friday, March 21, 20 MPRINT(ASSERTLOG): PROC SQL NOPRINT; MPRINT(ASSERTLOG): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(ASSERTLOG): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_CHECKLOG): DATA _null_; MPRINT(_CHECKLOG): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_005.log" TRUNCOVER end=eof; MPRINT(_CHECKLOG): INPUT logline $char255.; MPRINT(_CHECKLOG): ATTRIB _errorPatternId LENGTH = 8 _ignoreErrPatternId LENGTH = 8 _warningPatternId LENGTH = 8 _errcount LENGTH = 8 _warncount LENGTH = 8 ; MPRINT(_CHECKLOG): RETAIN _errorPatternId 0 _ignoreErrPatternId 0 _warningPatternId 0 _errcount 0 _warncount 0 ; MPRINT(_CHECKLOG): IF _n_=1 THEN DO; MPRINT(_CHECKLOG): _errorPatternId = prxparse("/^ERROR[: ]/"); MPRINT(_CHECKLOG): _warningPatternId = prxparse("/^WARNING[: ]/"); MPRINT(_CHECKLOG): _ignoreErrPatternId = prxparse("/^ERROR: Errors printed on page/"); MPRINT(_CHECKLOG): END; MPRINT(_CHECKLOG): IF prxmatch (_errorPatternId, logline) AND (NOT prxmatch (_ignoreErrPatternId, logline)) THEN DO; MPRINT(_CHECKLOG): _errcount = _errcount+1; MPRINT(_CHECKLOG): END; MPRINT(_CHECKLOG): ELSE IF prxmatch (_warningPatternId, logline) THEN DO; MPRINT(_CHECKLOG): _warncount = _warncount+1; MPRINT(_CHECKLOG): END; MPRINT(_CHECKLOG): IF eof THEN DO; MPRINT(_CHECKLOG): CALL symputx ("l_error_count" , put(_errcount,8.)); MPRINT(_CHECKLOG): CALL symputx ("l_warning_count", put(_warncount,8.)); MPRINT(_CHECKLOG): END; MPRINT(_CHECKLOG): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_005.log" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\log\001_005.log, RECFM=V,LRECL=256,Dateigröße (Byte)=6828, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 146 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_005.log". The minimum record length was 0. The maximum record length was 256. One or more lines were truncated. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE(SASUNIT): assertLog: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 5 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 5 ,2 ,"assertLog" ,"Scan log for errors " ,"0#0 " ,"0#0 " ,0 ,"assertLog: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; 51 Das SAS System 11:39 Friday, March 21, 20 NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 5.2 (assertLog) ===================================== MPRINT(ENDTESTCASE): QUIT; MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max (tst_res) INTO :l_result FROM target.tst WHERE tst_scnid=001 AND tst_casid=5; MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): UPDATE target.cas SET cas_res = 1 WHERE cas_scnid = 001 AND cas_id = 5; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(INITTESTCASE): ; MPRINT(INITTESTCASE): PROC SQL NOPRINT; MPRINT(INITTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(INITTESTCASE): INSERT INTO target.cas VALUES ( 001 ,6 ,2 ,"boxplot.sas" ,"only one visit" , MPRINT(INITTESTCASE): "" ,1711021160.045 ,. ,. ); NOTE: 1 row was inserted into TARGET.CAS. MPRINT(INITTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds ========================== test case 6 ====================================================== MPRINT(INITTESTCASE): PROC PRINTTO NEW LOG="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_006.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_006.lst" ; MPRINT(INITTESTCASE): RUN; NOTE: PROZEDUR PRINTTO used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): UPDATE target.cas SET cas_end = 1711021160.107 WHERE cas_scnid = 001 AND cas_id = 6; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; 54 Das SAS System 11:39 Friday, March 21, 20 MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): DATA _null_; MPRINT(ENDTESTCALL): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_006.lst"; MPRINT(ENDTESTCALL): INPUT; MPRINT(ENDTESTCALL): CALL symput ('l_filled','1'); MPRINT(ENDTESTCALL): STOP; MPRINT(ENDTESTCALL): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_006.lst" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\001_006.lst, RECFM=V,LRECL=256,Dateigröße (Byte)=0, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 0 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_006.lst". NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): ODS _ALL_ CLOSE; MPRINT(ASSERTLOGMSG): ; MPRINT(ASSERTLOGMSG): PROC SQL NOPRINT; MPRINT(ASSERTLOGMSG): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(ASSERTLOGMSG): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ASSERTLOGMSG): DATA _null_; MPRINT(ASSERTLOGMSG): RETAIN pattern_id; MPRINT(ASSERTLOGMSG): IF _n_=1 THEN DO; MPRINT(ASSERTLOGMSG): pattern_id = prxparse("/ERROR: BOXPLOT: X VARIABLE MUST HAVE AT LEAST TWO VALUES/"); MPRINT(ASSERTLOGMSG): END; MPRINT(ASSERTLOGMSG): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_006.log" END=eof TRUNCOVER; MPRINT(ASSERTLOGMSG): INPUT logrec $char256.; MPRINT(ASSERTLOGMSG): logrec = upcase(logrec); MPRINT(ASSERTLOGMSG): IF prxmatch (pattern_id, logrec) THEN DO; MPRINT(ASSERTLOGMSG): call symput ('l_msg_found', '1'); MPRINT(ASSERTLOGMSG): END; MPRINT(ASSERTLOGMSG): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_006.log" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\log\001_006.log, RECFM=V,LRECL=256,Dateigröße (Byte)=4418, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr 55 Das SAS System 11:39 Friday, March 21, 20 NOTE: 100 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_006.log". The minimum record length was 0. The maximum record length was 256. One or more lines were truncated. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE(SASUNIT): assertLogMsg: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 6 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 6 ,1 ,"assertLogMsg" ,"Scan for log messages " ,"1ERROR: boxplot: x variable must have at least two values " ,"1 " ,0 ,"assertLogMsg: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds ========================== Check 6.1 (assertLogMsg) ===================================== 80 %assertEquals(i_actual=%sysfunc(fileexist(&g_work\report6.pdf)), i_expected=0, i_desc=no report created) NOTE: The macro ASSERTEQUALS completed compilation without errors. 99 instructions 2452 bytes. NOTE(SASUNIT): assertEquals: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 6 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 6 ,2 ,"assertEquals" ,"no report created " ,"0 " ,"0 " ,0 ,"assertEquals: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 6.2 (assertEquals) ===================================== 81 %endTestcase(i_assertLog=0) MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max (tst_res) INTO :l_result FROM target.tst WHERE tst_scnid=001 AND tst_casid=6; MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): 56 Das SAS System 11:39 Friday, March 21, 20 real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): UPDATE target.cas SET cas_res = 0 WHERE cas_scnid = 001 AND cas_id = 6; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.00 seconds 82 83 /*-- 18 visits ---------------------------------------------------------------*/ 84 %initTestcase(i_object=boxplot.sas, i_desc=18 visits) MPRINT(INITTESTCASE): PROC SQL NOPRINT; MPRINT(INITTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(INITTESTCASE): INSERT INTO target.cas VALUES ( 001 ,7 ,2 ,"boxplot.sas" ,"18 visits" , MPRINT(INITTESTCASE): "" ,1711021160.138 ,. ,. ); NOTE: 1 row was inserted into TARGET.CAS. MPRINT(INITTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== test case 7 ====================================================== MPRINT(INITTESTCASE): PROC PRINTTO NEW LOG="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_007.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_007.lst" ; MPRINT(INITTESTCASE): RUN; NOTE: PROZEDUR PRINTTO used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): UPDATE target.cas SET cas_end = 1711021160.355 WHERE cas_scnid = 001 AND cas_id = 7; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): DATA _null_; MPRINT(ENDTESTCALL): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_007.lst"; MPRINT(ENDTESTCALL): INPUT; MPRINT(ENDTESTCALL): CALL symput ('l_filled','1'); MPRINT(ENDTESTCALL): STOP; MPRINT(ENDTESTCALL): RUN; 60 Das SAS System 11:39 Friday, March 21, 20 NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_007.lst" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\001_007.lst, RECFM=V,LRECL=256,Dateigröße (Byte)=0, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 0 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_007.lst". NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): ODS _ALL_ CLOSE; MPRINT(ASSERTREPORT): ; MPRINT(_TEMPFILENAME): DATA; MPRINT(_TEMPFILENAME): STOP; MPRINT(_TEMPFILENAME): RUN; NOTE: The data set WORK.DATA19 has 0 observations and 0 variables. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE(SASUNIT): Temporary dataset &d_dir is WORK.DATA19 MPRINT(_TEMPFILENAME): PROC SQL NOPRINT; MPRINT(_TEMPFILENAME): DROP TABLE WORK.DATA19; NOTE: Table WORK.DATA19 has been dropped. MPRINT(_TEMPFILENAME): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_DIR): proc sql noprint; MPRINT(_DIR): create table WORK.DATA19 (filename char(255)); NOTE: Table WORK.DATA19 created, with 0 rows and 1 columns. MPRINT(_DIR): quit; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(_DIR): options noxwait xsync xmin; MPRINT(_DIR): filename _dirfile "C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\___dir.txt" encoding=pcoem850; NOTE(SASUNIT): Directory search is: C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\report7.pdf MPRINT(_DIR): options XWAIT XSYNC NOXMIN; MPRINT(_DIR): data WORK.DATA19 (keep=filename changed); MPRINT(_DIR): length dir filename $255 language $2; MPRINT(_DIR): retain language "__" dir FilePos; MPRINT(_DIR): infile _dirfile truncover; MPRINT(_DIR): input line $char255. @; MPRINT(_DIR): if index (line, "Directory of") or index (line, "Verzeichnis von") then do; 61 Das SAS System 11:39 Friday, March 21, 20 MPRINT(_DIR): if index (line, "Directory of") then do; MPRINT(_DIR): dir = substr(line, index (line, "Directory of")+length("Directory of")+1); MPRINT(_DIR): end; MPRINT(_DIR): else do; MPRINT(_DIR): dir = substr(line, index (line, "Verzeichnis von")+length("Verzeichnis von")+1); MPRINT(_DIR): end; MPRINT(_DIR): end; MPRINT(_DIR): if substr(line,1,1) ne ' ' then do; MPRINT(_DIR): * Check for presence of AM/PM in time value, because you can specify AM/PM timeformat in German Windows *; MPRINT(_DIR): if (language = "__") then do; MPRINT(_DIR): Detect_AM_PM = upcase (scan (line, 3, " ")); MPRINT(_DIR): if (Detect_AM_PM in ("AM", "PM")) then do; MPRINT(_DIR): Filenamepart = scan (line,5, " "); MPRINT(_DIR): Filepos = index (line, trim(Filenamepart)); MPRINT(_DIR): language = "EN"; MPRINT(_DIR): end; MPRINT(_DIR): else do; MPRINT(_DIR): Filenamepart = scan (line,4, " "); MPRINT(_DIR): Filepos = index (line, trim(Filenamepart)); MPRINT(_DIR): language = "DE"; MPRINT(_DIR): end; MPRINT(_DIR): end; MPRINT(_DIR): if language='DE' then do; MPRINT(_DIR): input @1 d ddmmyy10. +2 t time5. ; MPRINT(_DIR): end; MPRINT(_DIR): else do; MPRINT(_DIR): input @1 d mmddyy10. +2 t time9. ; MPRINT(_DIR): end; MPRINT(_DIR): changed = dhms (d, hour(t), minute(t), 0); MPRINT(_DIR): format changed datetime20.; MPRINT(_DIR): filename = translate(trim(dir) !! '/' !! substr (line,FilePos),'/','\'); MPRINT(_DIR): output; MPRINT(_DIR): end; MPRINT(_DIR): run; NOTE: The infile _DIRFILE is: Dateiname=C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\___dir.txt, RECFM=V,LRECL=256,Dateigröße (Byte)=339, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 8 records were read from the infile _DIRFILE. The minimum record length was 0. The maximum record length was 94. NOTE: The data set WORK.DATA19 has 1 observations and 2 variables. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_DIR): filename _dirfile; NOTE: Fileref _DIRFILE has been deassigned. MPRINT(ASSERTREPORT): data _null_; MPRINT(ASSERTREPORT): set WORK.DATA19 nobs=nobs; 62 Das SAS System 11:39 Friday, March 21, 20 MPRINT(ASSERTREPORT): if nobs ne 1 then stop; MPRINT(ASSERTREPORT): if changed < dhms (today(), hour (input ("11:39",time5.)), minute (input ("11:39",time5.)), 0) then do; MPRINT(ASSERTREPORT): stop; MPRINT(ASSERTREPORT): end; MPRINT(ASSERTREPORT): call symput ('l_result', '1'); MPRINT(ASSERTREPORT): stop; MPRINT(ASSERTREPORT): run; NOTE: There were 1 observations read from the data set WORK.DATA19. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ASSERTREPORT): proc sql; MPRINT(ASSERTREPORT): drop table WORK.DATA19; NOTE: Table WORK.DATA19 has been dropped. MPRINT(ASSERTREPORT): quit; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_GETSCENARIOTESTID): PROC SQL NOPRINT; MPRINT(_GETSCENARIOTESTID): *** determine number of the current test case ****; MPRINT(_GETSCENARIOTESTID): SELECT max(cas_id) INTO :l_casid_gti FROM target.cas WHERE cas_scnid = 001; MPRINT(_GETSCENARIOTESTID): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_GETSCENARIOTESTID): PROC SQL NOPRINT; MPRINT(_GETSCENARIOTESTID): *** determine number of the current test case ****; MPRINT(_GETSCENARIOTESTID): SELECT max(tst_id) INTO :l_tstid_gti FROM target.tst WHERE tst_scnid = 001 AND tst_casid= 7; MPRINT(_GETSCENARIOTESTID): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(ASSERTREPORT): ; MPRINT(_CREATETESTSUBFOLDER): ; MPRINT(_MKDIR): options noxwait xsync xmin; MPRINT(_MKDIR): options XWAIT XSYNC NOXMIN; MPRINT(_CREATETESTSUBFOLDER): ; MPRINT(ASSERTREPORT): ; MPRINT(_COPYFILE): DATA _null_; MPRINT(_COPYFILE): INFILE "C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\report7.pdf" RECFM=N LRECL=1048576 LENGTH=l SHAREBUFFERS BLKSIZE=32768; MPRINT(_COPYFILE): FILE "c:/.jenkins/jobs/SASUnit Build Release ZIP-File/workspace/v1.3/example/doc/sasunit/de/tst/_001_007_001_assertreport/_man_act.pdf" RECFM=N LRECL=32768 BLKSIZE=1048576; MPRINT(_COPYFILE): INPUT line $char32767.; MPRINT(_COPYFILE): PUT line $varying32767. l; MPRINT(_COPYFILE): RUN; 63 Das SAS System 11:39 Friday, March 21, 20 NOTE: UNBUFFERED is the default with RECFM=N. NOTE: The infile "C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\report7.pdf" is: Dateiname=C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\report7.pdf, RECFM=N,LRECL=1048576,Dateigröße (Byte)=100774, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: UNBUFFERED is the default with RECFM=N. NOTE: The file "c:/.jenkins/jobs/SASUnit Build Release ZIP-File/workspace/v1.3/example/doc/sasunit/de/tst/_001_007_001_assertreport/_man_act.pdf" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\_001_007_001_assertreport\_man_act.pdf, RECFM=N,LRECL=32768,Dateigröße (Byte)=0, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ASSERTREPORT): ; NOTE(SASUNIT): assertReport: assert passed, but manual check necessary. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 7 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 7 ,1 ,"assertReport" ,"please compare chart with specification in source code " ," " ,".pdf " ,1 ,"assertReport: assert passed, but manual check necessary." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 7.1 (assertReport) ===================================== 97 98 /*-- Error: invalid input data set -------------------------------------------*/ 99 %initTestcase(i_object=boxplot.sas, i_desc=invalid input data set) MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCASE): SELECT count(*) INTO :l_assertLog FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 7 AND tst_type='assertLog'; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ASSERTLOG): PROC SQL NOPRINT; MPRINT(ASSERTLOG): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(ASSERTLOG): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_CHECKLOG): DATA _null_; 64 Das SAS System 11:39 Friday, March 21, 20 MPRINT(_CHECKLOG): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_007.log" TRUNCOVER end=eof; MPRINT(_CHECKLOG): INPUT logline $char255.; MPRINT(_CHECKLOG): ATTRIB _errorPatternId LENGTH = 8 _ignoreErrPatternId LENGTH = 8 _warningPatternId LENGTH = 8 _errcount LENGTH = 8 _warncount LENGTH = 8 ; MPRINT(_CHECKLOG): RETAIN _errorPatternId 0 _ignoreErrPatternId 0 _warningPatternId 0 _errcount 0 _warncount 0 ; MPRINT(_CHECKLOG): IF _n_=1 THEN DO; MPRINT(_CHECKLOG): _errorPatternId = prxparse("/^ERROR[: ]/"); MPRINT(_CHECKLOG): _warningPatternId = prxparse("/^WARNING[: ]/"); MPRINT(_CHECKLOG): _ignoreErrPatternId = prxparse("/^ERROR: Errors printed on page/"); MPRINT(_CHECKLOG): END; MPRINT(_CHECKLOG): IF prxmatch (_errorPatternId, logline) AND (NOT prxmatch (_ignoreErrPatternId, logline)) THEN DO; MPRINT(_CHECKLOG): _errcount = _errcount+1; MPRINT(_CHECKLOG): END; MPRINT(_CHECKLOG): ELSE IF prxmatch (_warningPatternId, logline) THEN DO; MPRINT(_CHECKLOG): _warncount = _warncount+1; MPRINT(_CHECKLOG): END; MPRINT(_CHECKLOG): IF eof THEN DO; MPRINT(_CHECKLOG): CALL symputx ("l_error_count" , put(_errcount,8.)); MPRINT(_CHECKLOG): CALL symputx ("l_warning_count", put(_warncount,8.)); MPRINT(_CHECKLOG): END; MPRINT(_CHECKLOG): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_007.log" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\log\001_007.log, RECFM=V,LRECL=256,Dateigröße (Byte)=7277, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 152 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_007.log". The minimum record length was 0. The maximum record length was 256. One or more lines were truncated. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE(SASUNIT): assertLog: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 7 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 7 ,2 ,"assertLog" ,"Scan log for errors " ,"0#0 " ,"0#0 " ,0 ,"assertLog: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 7.2 (assertLog) ===================================== MPRINT(ENDTESTCASE): QUIT; MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max (tst_res) INTO :l_result FROM target.tst WHERE tst_scnid=001 AND tst_casid=7; MPRINT(ENDTESTCASE): QUIT; 65 Das SAS System 11:39 Friday, March 21, 20 NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): UPDATE target.cas SET cas_res = 1 WHERE cas_scnid = 001 AND cas_id = 7; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(INITTESTCASE): ; MPRINT(INITTESTCASE): PROC SQL NOPRINT; MPRINT(INITTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(INITTESTCASE): INSERT INTO target.cas VALUES ( 001 ,8 ,2 ,"boxplot.sas" ,"invalid input data set" , MPRINT(INITTESTCASE): "" ,1711021160.447 ,. ,. ); NOTE: 1 row was inserted into TARGET.CAS. MPRINT(INITTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== test case 8 ====================================================== MPRINT(INITTESTCASE): PROC PRINTTO NEW LOG="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_008.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_008.lst" ; MPRINT(INITTESTCASE): RUN; NOTE: PROZEDUR PRINTTO used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 66 Das SAS System 11:39 Friday, March 21, 20 MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): UPDATE target.cas SET cas_end = 1711021160.463 WHERE cas_scnid = 001 AND cas_id = 8; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): DATA _null_; MPRINT(ENDTESTCALL): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_008.lst"; MPRINT(ENDTESTCALL): INPUT; MPRINT(ENDTESTCALL): CALL symput ('l_filled','1'); MPRINT(ENDTESTCALL): STOP; MPRINT(ENDTESTCALL): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_008.lst" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\001_008.lst, RECFM=V,LRECL=256,Dateigröße (Byte)=0, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 0 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_008.lst". NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): ODS _ALL_ CLOSE; MPRINT(ASSERTLOGMSG): ; MPRINT(ASSERTLOGMSG): PROC SQL NOPRINT; MPRINT(ASSERTLOGMSG): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(ASSERTLOGMSG): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ASSERTLOGMSG): DATA _null_; MPRINT(ASSERTLOGMSG): RETAIN pattern_id; MPRINT(ASSERTLOGMSG): IF _n_=1 THEN DO; MPRINT(ASSERTLOGMSG): pattern_id = prxparse("/ERROR: BOXPLOT: DATA SET XXXXX DOES NOT EXIST/"); MPRINT(ASSERTLOGMSG): END; 67 Das SAS System 11:39 Friday, March 21, 20 MPRINT(ASSERTLOGMSG): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_008.log" END=eof TRUNCOVER; MPRINT(ASSERTLOGMSG): INPUT logrec $char256.; MPRINT(ASSERTLOGMSG): logrec = upcase(logrec); MPRINT(ASSERTLOGMSG): IF prxmatch (pattern_id, logrec) THEN DO; MPRINT(ASSERTLOGMSG): call symput ('l_msg_found', '1'); MPRINT(ASSERTLOGMSG): END; MPRINT(ASSERTLOGMSG): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_008.log" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\log\001_008.log, RECFM=V,LRECL=256,Dateigröße (Byte)=638, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 11 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_008.log". The minimum record length was 0. The maximum record length was 247. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE(SASUNIT): assertLogMsg: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 8 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 8 ,1 ,"assertLogMsg" ,"Scan for log messages " ,"1ERROR: boxplot: Data set XXXXX does not exist " ,"1 " ,0 ,"assertLogMsg: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 8.1 (assertLogMsg) ===================================== 102 %assertEquals(i_actual=%sysfunc(fileexist(&g_work\report8.pdf)), i_expected=0, i_desc=no report created) NOTE(SASUNIT): assertEquals: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 8 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 8 ,2 ,"assertEquals" ,"no report created " ,"0 " ,"0 " ,0 ,"assertEquals: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 8.2 (assertEquals) ===================================== 103 %endTestcase(i_assertLog=0) MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; 68 Das SAS System 11:39 Friday, March 21, 20 MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max (tst_res) INTO :l_result FROM target.tst WHERE tst_scnid=001 AND tst_casid=8; MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): UPDATE target.cas SET cas_res = 0 WHERE cas_scnid = 001 AND cas_id = 8; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 104 105 /*-- Error: input data set missing -------------------------------------------*/ 106 %initTestcase(i_object=boxplot.sas, i_desc=input data set missing) MPRINT(INITTESTCASE): PROC SQL NOPRINT; MPRINT(INITTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(INITTESTCASE): INSERT INTO target.cas VALUES ( 001 ,9 ,2 ,"boxplot.sas" ,"input data set missing" , MPRINT(INITTESTCASE): "" ,1711021160.494 ,. ,. ); NOTE: 1 row was inserted into TARGET.CAS. MPRINT(INITTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== test case 9 ====================================================== MPRINT(INITTESTCASE): PROC PRINTTO NEW LOG="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_009.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_009.lst" ; MPRINT(INITTESTCASE): RUN; NOTE: PROZEDUR PRINTTO used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): UPDATE target.cas SET cas_end = 1711021160.509 WHERE cas_scnid = 001 AND cas_id = 9; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(ENDTESTCALL): DATA _null_; MPRINT(ENDTESTCALL): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_009.lst"; MPRINT(ENDTESTCALL): INPUT; MPRINT(ENDTESTCALL): CALL symput ('l_filled','1'); MPRINT(ENDTESTCALL): STOP; MPRINT(ENDTESTCALL): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_009.lst" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\001_009.lst, RECFM=V,LRECL=256,Dateigröße (Byte)=0, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 0 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_009.lst". NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): ODS _ALL_ CLOSE; MPRINT(ASSERTLOGMSG): ; MPRINT(ASSERTLOGMSG): PROC SQL NOPRINT; MPRINT(ASSERTLOGMSG): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; 70 Das SAS System 11:39 Friday, March 21, 20 MPRINT(ASSERTLOGMSG): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ASSERTLOGMSG): DATA _null_; MPRINT(ASSERTLOGMSG): RETAIN pattern_id; MPRINT(ASSERTLOGMSG): IF _n_=1 THEN DO; MPRINT(ASSERTLOGMSG): pattern_id = prxparse("/ERROR: BOXPLOT: DATA SET DOES NOT EXIST/"); MPRINT(ASSERTLOGMSG): END; MPRINT(ASSERTLOGMSG): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_009.log" END=eof TRUNCOVER; MPRINT(ASSERTLOGMSG): INPUT logrec $char256.; MPRINT(ASSERTLOGMSG): logrec = upcase(logrec); MPRINT(ASSERTLOGMSG): IF prxmatch (pattern_id, logrec) THEN DO; MPRINT(ASSERTLOGMSG): call symput ('l_msg_found', '1'); MPRINT(ASSERTLOGMSG): END; MPRINT(ASSERTLOGMSG): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_009.log" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\log\001_009.log, RECFM=V,LRECL=256,Dateigröße (Byte)=883, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 13 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_009.log". The minimum record length was 0. The maximum record length was 256. One or more lines were truncated. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE(SASUNIT): assertLogMsg: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 9 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 9 ,1 ,"assertLogMsg" ,"Scan for log messages " ,"1ERROR: boxplot: Data set does not exist " ,"1 " ,0 ,"assertLogMsg: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 9.1 (assertLogMsg) ===================================== 109 %assertEquals(i_actual=%sysfunc(fileexist(&g_work\report9.pdf)), i_expected=0, i_desc=no report created) NOTE(SASUNIT): assertEquals: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 9 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 9 ,2 ,"assertEquals" ,"no report created " ,"0 " ,"0 " ,0 ,"assertEquals: assert passed." ); 71 Das SAS System 11:39 Friday, March 21, 20 NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds ========================== Check 9.2 (assertEquals) ===================================== 110 %endTestcase(i_assertLog=0) MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max (tst_res) INTO :l_result FROM target.tst WHERE tst_scnid=001 AND tst_casid=9; MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): UPDATE target.cas SET cas_res = 0 WHERE cas_scnid = 001 AND cas_id = 9; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 111 112 /*-- Error: invalid x variable -----------------------------------------------*/ 113 %initTestcase(i_object=boxplot.sas, i_desc=invalid x variable) MPRINT(INITTESTCASE): PROC SQL NOPRINT; MPRINT(INITTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(INITTESTCASE): INSERT INTO target.cas VALUES ( 001 ,10 ,2 ,"boxplot.sas" ,"invalid x variable" , MPRINT(INITTESTCASE): "" ,1711021160.54 ,. ,. ); NOTE: 1 row was inserted into TARGET.CAS. MPRINT(INITTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== test case 10 ====================================================== MPRINT(INITTESTCASE): PROC PRINTTO NEW LOG="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_010.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_010.lst" ; 72 Das SAS System 11:39 Friday, March 21, 20 MPRINT(INITTESTCASE): RUN; NOTE: PROZEDUR PRINTTO used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): UPDATE target.cas SET cas_end = 1711021160.571 WHERE cas_scnid = 001 AND cas_id = 10; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): DATA _null_; MPRINT(ENDTESTCALL): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_010.lst"; MPRINT(ENDTESTCALL): INPUT; MPRINT(ENDTESTCALL): CALL symput ('l_filled','1'); MPRINT(ENDTESTCALL): STOP; MPRINT(ENDTESTCALL): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_010.lst" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\001_010.lst, RECFM=V,LRECL=256,Dateigröße (Byte)=0, Zuletzt geändert=21. März 2014 11.39 Uhr, 73 Das SAS System 11:39 Friday, March 21, 20 Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 0 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_010.lst". NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): ODS _ALL_ CLOSE; MPRINT(ASSERTLOGMSG): ; MPRINT(ASSERTLOGMSG): PROC SQL NOPRINT; MPRINT(ASSERTLOGMSG): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(ASSERTLOGMSG): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ASSERTLOGMSG): DATA _null_; MPRINT(ASSERTLOGMSG): RETAIN pattern_id; MPRINT(ASSERTLOGMSG): IF _n_=1 THEN DO; MPRINT(ASSERTLOGMSG): pattern_id = prxparse("/ERROR: BOXPLOT: VARIABLE VISITXXX DOES NOT EXIST IN DATA SET TESTDATA.BLOOD_PRESSURE/"); MPRINT(ASSERTLOGMSG): END; MPRINT(ASSERTLOGMSG): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_010.log" END=eof TRUNCOVER; MPRINT(ASSERTLOGMSG): INPUT logrec $char256.; MPRINT(ASSERTLOGMSG): logrec = upcase(logrec); MPRINT(ASSERTLOGMSG): IF prxmatch (pattern_id, logrec) THEN DO; MPRINT(ASSERTLOGMSG): call symput ('l_msg_found', '1'); MPRINT(ASSERTLOGMSG): END; MPRINT(ASSERTLOGMSG): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_010.log" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\log\001_010.log, RECFM=V,LRECL=256,Dateigröße (Byte)=738, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 11 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_010.log". The minimum record length was 0. The maximum record length was 247. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE(SASUNIT): assertLogMsg: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 10 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 10 ,1 ,"assertLogMsg" ,"Scan for log messages " ,"1ERROR: boxplot: Variable visitXXX does not exist in data set testdata.blood_pressure " ,"1 " ,0 ,"assertLogMsg: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): 74 Das SAS System 11:39 Friday, March 21, 20 real time 0.00 seconds cpu time 0.00 seconds ========================== Check 10.1 (assertLogMsg) ===================================== 116 %assertEquals(i_actual=%sysfunc(fileexist(&g_work\report10.pdf)), i_expected=0, i_desc=no report created) NOTE(SASUNIT): assertEquals: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 10 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 10 ,2 ,"assertEquals" ,"no report created " ,"0 " ,"0 " ,0 ,"assertEquals: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 10.2 (assertEquals) ===================================== 117 %endTestcase(i_assertLog=0) MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max (tst_res) INTO :l_result FROM target.tst WHERE tst_scnid=001 AND tst_casid=10; MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): UPDATE target.cas SET cas_res = 0 WHERE cas_scnid = 001 AND cas_id = 10; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 118 119 /*-- Error: x variable missing -----------------------------------------------*/ 120 %initTestcase(i_object=boxplot.sas, i_desc=x variable missing) MPRINT(INITTESTCASE): PROC SQL NOPRINT; MPRINT(INITTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(INITTESTCASE): INSERT INTO target.cas VALUES ( 001 ,11 ,2 ,"boxplot.sas" ,"x variable missing" , MPRINT(INITTESTCASE): "" ,1711021160.587 ,. ,. ); 75 Das SAS System 11:39 Friday, March 21, 20 NOTE: 1 row was inserted into TARGET.CAS. MPRINT(INITTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== test case 11 ====================================================== MPRINT(INITTESTCASE): PROC PRINTTO NEW LOG="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_011.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_011.lst" ; MPRINT(INITTESTCASE): RUN; NOTE: PROZEDUR PRINTTO used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): UPDATE target.cas SET cas_end = 1711021160.618 WHERE cas_scnid = 001 AND cas_id = 11; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 76 Das SAS System 11:39 Friday, March 21, 20 MPRINT(ENDTESTCALL): DATA _null_; MPRINT(ENDTESTCALL): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_011.lst"; MPRINT(ENDTESTCALL): INPUT; MPRINT(ENDTESTCALL): CALL symput ('l_filled','1'); MPRINT(ENDTESTCALL): STOP; MPRINT(ENDTESTCALL): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_011.lst" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\001_011.lst, RECFM=V,LRECL=256,Dateigröße (Byte)=0, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 0 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_011.lst". NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): ODS _ALL_ CLOSE; MPRINT(ASSERTLOGMSG): ; MPRINT(ASSERTLOGMSG): PROC SQL NOPRINT; MPRINT(ASSERTLOGMSG): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(ASSERTLOGMSG): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ASSERTLOGMSG): DATA _null_; MPRINT(ASSERTLOGMSG): RETAIN pattern_id; MPRINT(ASSERTLOGMSG): IF _n_=1 THEN DO; MPRINT(ASSERTLOGMSG): pattern_id = prxparse("/ERROR: BOXPLOT: X VARIABLE NOT SPECIFIED/"); MPRINT(ASSERTLOGMSG): END; MPRINT(ASSERTLOGMSG): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_011.log" END=eof TRUNCOVER; MPRINT(ASSERTLOGMSG): INPUT logrec $char256.; MPRINT(ASSERTLOGMSG): logrec = upcase(logrec); MPRINT(ASSERTLOGMSG): IF prxmatch (pattern_id, logrec) THEN DO; MPRINT(ASSERTLOGMSG): call symput ('l_msg_found', '1'); MPRINT(ASSERTLOGMSG): END; MPRINT(ASSERTLOGMSG): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_011.log" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\log\001_011.log, RECFM=V,LRECL=256,Dateigröße (Byte)=642, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 11 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_011.log". The minimum record length was 0. The maximum record length was 247. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 77 Das SAS System 11:39 Friday, March 21, 20 NOTE(SASUNIT): assertLogMsg: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 11 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 11 ,1 ,"assertLogMsg" ,"Scan for log messages " ,"1ERROR: boxplot: X variable not specified " ,"1 " ,0 ,"assertLogMsg: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 11.1 (assertLogMsg) ===================================== 123 %assertEquals(i_actual=%sysfunc(fileexist(&g_work\report11.pdf)), i_expected=0, i_desc=no report created) NOTE(SASUNIT): assertEquals: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 11 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 11 ,2 ,"assertEquals" ,"no report created " ,"0 " ,"0 " ,0 ,"assertEquals: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 11.2 (assertEquals) ===================================== 124 %endTestcase(i_assertLog=0) MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max (tst_res) INTO :l_result FROM target.tst WHERE tst_scnid=001 AND tst_casid=11; MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): UPDATE target.cas SET cas_res = 0 WHERE cas_scnid = 001 AND cas_id = 11; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): 78 Das SAS System 11:39 Friday, March 21, 20 real time 0.00 seconds cpu time 0.00 seconds 125 126 /*-- Error: x variable not numeric -------------------------------------------*/ 127 %initTestcase(i_object=boxplot.sas, i_desc=x variable not numeric) MPRINT(INITTESTCASE): PROC SQL NOPRINT; MPRINT(INITTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(INITTESTCASE): INSERT INTO target.cas VALUES ( 001 ,12 ,2 ,"boxplot.sas" ,"x variable not numeric" , MPRINT(INITTESTCASE): "" ,1711021160.648 ,. ,. ); NOTE: 1 row was inserted into TARGET.CAS. MPRINT(INITTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== test case 12 ====================================================== MPRINT(INITTESTCASE): PROC PRINTTO NEW LOG="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_012.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_012.lst" ; MPRINT(INITTESTCASE): RUN; NOTE: PROZEDUR PRINTTO used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; 79 Das SAS System 11:39 Friday, March 21, 20 NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): UPDATE target.cas SET cas_end = 1711021160.679 WHERE cas_scnid = 001 AND cas_id = 12; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): DATA _null_; MPRINT(ENDTESTCALL): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_012.lst"; MPRINT(ENDTESTCALL): INPUT; MPRINT(ENDTESTCALL): CALL symput ('l_filled','1'); MPRINT(ENDTESTCALL): STOP; MPRINT(ENDTESTCALL): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_012.lst" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\001_012.lst, RECFM=V,LRECL=256,Dateigröße (Byte)=0, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 0 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_012.lst". NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): ODS _ALL_ CLOSE; MPRINT(ASSERTLOGMSG): ; MPRINT(ASSERTLOGMSG): PROC SQL NOPRINT; MPRINT(ASSERTLOGMSG): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(ASSERTLOGMSG): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ASSERTLOGMSG): DATA _null_; MPRINT(ASSERTLOGMSG): RETAIN pattern_id; 80 Das SAS System 11:39 Friday, March 21, 20 MPRINT(ASSERTLOGMSG): IF _n_=1 THEN DO; MPRINT(ASSERTLOGMSG): pattern_id = prxparse("/ERROR: BOXPLOT: VARIABLE VISITC IN DATA SET BLOOD_PRESSURE MUST BE NUMERIC/"); MPRINT(ASSERTLOGMSG): END; MPRINT(ASSERTLOGMSG): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_012.log" END=eof TRUNCOVER; MPRINT(ASSERTLOGMSG): INPUT logrec $char256.; MPRINT(ASSERTLOGMSG): logrec = upcase(logrec); MPRINT(ASSERTLOGMSG): IF prxmatch (pattern_id, logrec) THEN DO; MPRINT(ASSERTLOGMSG): call symput ('l_msg_found', '1'); MPRINT(ASSERTLOGMSG): END; MPRINT(ASSERTLOGMSG): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_012.log" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\log\001_012.log, RECFM=V,LRECL=256,Dateigröße (Byte)=1144, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 23 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_012.log". The minimum record length was 0. The maximum record length was 247. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE(SASUNIT): assertLogMsg: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 12 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 12 ,1 ,"assertLogMsg" ,"Scan for log messages " ,"1ERROR: boxplot: Variable visitc in data set blood_pressure must be numeric " ,"1 " ,0 ,"assertLogMsg: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 12.1 (assertLogMsg) ===================================== 134 %assertEquals(i_actual=%sysfunc(fileexist(&g_work\report12.pdf)), i_expected=0, i_desc=no report created) NOTE(SASUNIT): assertEquals: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 12 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 12 ,2 ,"assertEquals" ,"no report created " ,"0 " ,"0 " ,0 ,"assertEquals: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 12.2 (assertEquals) ===================================== 81 Das SAS System 11:39 Friday, March 21, 20 135 %endTestcase(i_assertLog=0) MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max (tst_res) INTO :l_result FROM target.tst WHERE tst_scnid=001 AND tst_casid=12; MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): UPDATE target.cas SET cas_res = 0 WHERE cas_scnid = 001 AND cas_id = 12; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 136 137 /*-- Error: x variable values not equidistant --------------------------------*/ 138 %initTestcase(i_object=boxplot.sas, i_desc=x variable values not equidistant) MPRINT(INITTESTCASE): PROC SQL NOPRINT; MPRINT(INITTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(INITTESTCASE): INSERT INTO target.cas VALUES ( 001 ,13 ,2 ,"boxplot.sas" ,"x variable values not equidistant" , MPRINT(INITTESTCASE): "" ,1711021160.695 ,. ,. ); NOTE: 1 row was inserted into TARGET.CAS. MPRINT(INITTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds ========================== test case 13 ====================================================== MPRINT(INITTESTCASE): PROC PRINTTO NEW LOG="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_013.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_013.lst" ; MPRINT(INITTESTCASE): RUN; NOTE: PROZEDUR PRINTTO used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): UPDATE target.cas SET cas_end = 1711021160.757 WHERE cas_scnid = 001 AND cas_id = 13; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds 84 Das SAS System 11:39 Friday, March 21, 20 cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): DATA _null_; MPRINT(ENDTESTCALL): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_013.lst"; MPRINT(ENDTESTCALL): INPUT; MPRINT(ENDTESTCALL): CALL symput ('l_filled','1'); MPRINT(ENDTESTCALL): STOP; MPRINT(ENDTESTCALL): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_013.lst" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\001_013.lst, RECFM=V,LRECL=256,Dateigröße (Byte)=0, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 0 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_013.lst". NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): ODS _ALL_ CLOSE; MPRINT(ASSERTLOGMSG): ; MPRINT(ASSERTLOGMSG): PROC SQL NOPRINT; MPRINT(ASSERTLOGMSG): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(ASSERTLOGMSG): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ASSERTLOGMSG): DATA _null_; MPRINT(ASSERTLOGMSG): RETAIN pattern_id; MPRINT(ASSERTLOGMSG): IF _n_=1 THEN DO; MPRINT(ASSERTLOGMSG): pattern_id = prxparse("/ERROR: BOXPLOT: VALUES OF X VARIABLE ARE NOT EQUIDISTANT/"); MPRINT(ASSERTLOGMSG): END; MPRINT(ASSERTLOGMSG): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_013.log" END=eof TRUNCOVER; MPRINT(ASSERTLOGMSG): INPUT logrec $char256.; MPRINT(ASSERTLOGMSG): logrec = upcase(logrec); MPRINT(ASSERTLOGMSG): IF prxmatch (pattern_id, logrec) THEN DO; MPRINT(ASSERTLOGMSG): call symput ('l_msg_found', '1'); MPRINT(ASSERTLOGMSG): END; MPRINT(ASSERTLOGMSG): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_013.log" is: 85 Das SAS System 11:39 Friday, March 21, 20 Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\log\001_013.log, RECFM=V,LRECL=256,Dateigröße (Byte)=4430, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 100 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_013.log". The minimum record length was 0. The maximum record length was 256. One or more lines were truncated. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE(SASUNIT): assertLogMsg: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 13 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 13 ,1 ,"assertLogMsg" ,"Scan for log messages " ,"1ERROR: boxplot: Values of x variable are not equidistant " ,"1 " ,0 ,"assertLogMsg: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds ========================== Check 13.1 (assertLogMsg) ===================================== 145 %assertEquals(i_actual=%sysfunc(fileexist(&g_work\report13.pdf)), i_expected=0, i_desc=no report created) NOTE(SASUNIT): assertEquals: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 13 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 13 ,2 ,"assertEquals" ,"no report created " ,"0 " ,"0 " ,0 ,"assertEquals: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 13.2 (assertEquals) ===================================== 146 %endTestcase(i_assertLog=0) MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max (tst_res) INTO :l_result FROM target.tst WHERE tst_scnid=001 AND tst_casid=13; 86 Das SAS System 11:39 Friday, March 21, 20 MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): UPDATE target.cas SET cas_res = 0 WHERE cas_scnid = 001 AND cas_id = 13; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 147 148 /*-- Error: x variable has missing values ------------------------------------*/ 149 %initTestcase(i_object=boxplot.sas, i_desc=x variable has missing values) MPRINT(INITTESTCASE): PROC SQL NOPRINT; MPRINT(INITTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(INITTESTCASE): INSERT INTO target.cas VALUES ( 001 ,14 ,2 ,"boxplot.sas" ,"x variable has missing values" , MPRINT(INITTESTCASE): "" ,1711021160.788 ,. ,. ); NOTE: 1 row was inserted into TARGET.CAS. MPRINT(INITTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds ========================== test case 14 ====================================================== MPRINT(INITTESTCASE): PROC PRINTTO NEW LOG="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_014.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_014.lst" ; MPRINT(INITTESTCASE): RUN; NOTE: PROZEDUR PRINTTO used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): UPDATE target.cas SET cas_end = 1711021160.834 WHERE cas_scnid = 001 AND cas_id = 14; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 89 Das SAS System 11:39 Friday, March 21, 20 MPRINT(ENDTESTCALL): DATA _null_; MPRINT(ENDTESTCALL): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_014.lst"; MPRINT(ENDTESTCALL): INPUT; MPRINT(ENDTESTCALL): CALL symput ('l_filled','1'); MPRINT(ENDTESTCALL): STOP; MPRINT(ENDTESTCALL): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_014.lst" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\001_014.lst, RECFM=V,LRECL=256,Dateigröße (Byte)=0, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 0 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_014.lst". NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): ODS _ALL_ CLOSE; MPRINT(ASSERTLOGMSG): ; MPRINT(ASSERTLOGMSG): PROC SQL NOPRINT; MPRINT(ASSERTLOGMSG): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(ASSERTLOGMSG): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ASSERTLOGMSG): DATA _null_; MPRINT(ASSERTLOGMSG): RETAIN pattern_id; MPRINT(ASSERTLOGMSG): IF _n_=1 THEN DO; MPRINT(ASSERTLOGMSG): pattern_id = prxparse("/ERROR: BOXPLOT: MISSING VALUES IN X VARIABLE ARE NOT ALLOWED/"); MPRINT(ASSERTLOGMSG): END; MPRINT(ASSERTLOGMSG): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_014.log" END=eof TRUNCOVER; MPRINT(ASSERTLOGMSG): INPUT logrec $char256.; MPRINT(ASSERTLOGMSG): logrec = upcase(logrec); MPRINT(ASSERTLOGMSG): IF prxmatch (pattern_id, logrec) THEN DO; MPRINT(ASSERTLOGMSG): call symput ('l_msg_found', '1'); MPRINT(ASSERTLOGMSG): END; MPRINT(ASSERTLOGMSG): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_014.log" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\log\001_014.log, RECFM=V,LRECL=256,Dateigröße (Byte)=4443, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 101 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_014.log". The minimum record length was 0. The maximum record length was 256. One or more lines were truncated. NOTE: DATA-Anweisung used (Total process time): 90 Das SAS System 11:39 Friday, March 21, 20 real time 0.00 seconds cpu time 0.00 seconds NOTE(SASUNIT): assertLogMsg: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 14 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 14 ,1 ,"assertLogMsg" ,"Scan for log messages " ,"1ERROR: boxplot: Missing values in x variable are not allowed " ,"1 " ,0 ,"assertLogMsg: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds ========================== Check 14.1 (assertLogMsg) ===================================== 158 %assertEquals(i_actual=%sysfunc(fileexist(&g_work\report14.pdf)), i_expected=0, i_desc=no report created) NOTE(SASUNIT): assertEquals: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 14 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 14 ,2 ,"assertEquals" ,"no report created " ,"0 " ,"0 " ,0 ,"assertEquals: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 14.2 (assertEquals) ===================================== 159 %endTestcase(i_assertLog=0) MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max (tst_res) INTO :l_result FROM target.tst WHERE tst_scnid=001 AND tst_casid=14; MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): UPDATE target.cas SET cas_res = 0 WHERE cas_scnid = 001 AND cas_id = 14; NOTE: 1 row was updated in TARGET.CAS. 91 Das SAS System 11:39 Friday, March 21, 20 MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 160 161 /*-- Error: invalid y variable -----------------------------------------------*/ 162 %initTestcase(i_object=boxplot.sas, i_desc=invalid y variable) MPRINT(INITTESTCASE): PROC SQL NOPRINT; MPRINT(INITTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(INITTESTCASE): INSERT INTO target.cas VALUES ( 001 ,15 ,2 ,"boxplot.sas" ,"invalid y variable" , MPRINT(INITTESTCASE): "" ,1711021160.865 ,. ,. ); NOTE: 1 row was inserted into TARGET.CAS. MPRINT(INITTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== test case 15 ====================================================== MPRINT(INITTESTCASE): PROC PRINTTO NEW LOG="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_015.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_015.lst" ; MPRINT(INITTESTCASE): RUN; NOTE: PROZEDUR PRINTTO used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; NOTE: PROZEDUR SQL used (Total process time): 92 Das SAS System 11:39 Friday, March 21, 20 real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): UPDATE target.cas SET cas_end = 1711021160.88 WHERE cas_scnid = 001 AND cas_id = 15; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): DATA _null_; MPRINT(ENDTESTCALL): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_015.lst"; MPRINT(ENDTESTCALL): INPUT; MPRINT(ENDTESTCALL): CALL symput ('l_filled','1'); MPRINT(ENDTESTCALL): STOP; MPRINT(ENDTESTCALL): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_015.lst" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\001_015.lst, RECFM=V,LRECL=256,Dateigröße (Byte)=0, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 0 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_015.lst". NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): ODS _ALL_ CLOSE; MPRINT(ASSERTLOGMSG): ; MPRINT(ASSERTLOGMSG): PROC SQL NOPRINT; MPRINT(ASSERTLOGMSG): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(ASSERTLOGMSG): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ASSERTLOGMSG): DATA _null_; MPRINT(ASSERTLOGMSG): RETAIN pattern_id; MPRINT(ASSERTLOGMSG): IF _n_=1 THEN DO; 93 Das SAS System 11:39 Friday, March 21, 20 MPRINT(ASSERTLOGMSG): pattern_id = prxparse("/ERROR: BOXPLOT: VARIABLE SBPXXX DOES NOT EXIST IN DATA SET TESTDATA.BLOOD_PRESSURE/"); MPRINT(ASSERTLOGMSG): END; MPRINT(ASSERTLOGMSG): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_015.log" END=eof TRUNCOVER; MPRINT(ASSERTLOGMSG): INPUT logrec $char256.; MPRINT(ASSERTLOGMSG): logrec = upcase(logrec); MPRINT(ASSERTLOGMSG): IF prxmatch (pattern_id, logrec) THEN DO; MPRINT(ASSERTLOGMSG): call symput ('l_msg_found', '1'); MPRINT(ASSERTLOGMSG): END; MPRINT(ASSERTLOGMSG): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_015.log" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\log\001_015.log, RECFM=V,LRECL=256,Dateigröße (Byte)=1144, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 20 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_015.log". The minimum record length was 0. The maximum record length was 247. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE(SASUNIT): assertLogMsg: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 15 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 15 ,1 ,"assertLogMsg" ,"Scan for log messages " ,"1ERROR: boxplot: Variable sbpXXX does not exist in data set testdata.blood_pressure " ,"1 " ,0 ,"assertLogMsg: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 15.1 (assertLogMsg) ===================================== 165 %assertEquals(i_actual=%sysfunc(fileexist(&g_work\report15.pdf)), i_expected=0, i_desc=no report created) NOTE(SASUNIT): assertEquals: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 15 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 15 ,2 ,"assertEquals" ,"no report created " ,"0 " ,"0 " ,0 ,"assertEquals: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 15.2 (assertEquals) ===================================== 166 %endTestcase(i_assertLog=0) 94 Das SAS System 11:39 Friday, March 21, 20 MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max (tst_res) INTO :l_result FROM target.tst WHERE tst_scnid=001 AND tst_casid=15; MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): UPDATE target.cas SET cas_res = 0 WHERE cas_scnid = 001 AND cas_id = 15; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 167 168 /*-- Error: y variable not specified -----------------------------------------*/ 169 %initTestcase(i_object=boxplot.sas, i_desc=y variable not specified) MPRINT(INITTESTCASE): PROC SQL NOPRINT; MPRINT(INITTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(INITTESTCASE): INSERT INTO target.cas VALUES ( 001 ,16 ,2 ,"boxplot.sas" ,"y variable not specified" , MPRINT(INITTESTCASE): "" ,1711021160.911 ,. ,. ); NOTE: 1 row was inserted into TARGET.CAS. MPRINT(INITTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== test case 16 ====================================================== MPRINT(INITTESTCASE): PROC PRINTTO NEW LOG="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_016.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_016.lst" ; MPRINT(INITTESTCASE): RUN; NOTE: PROZEDUR PRINTTO used (Total process time): real time 0.01 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): UPDATE target.cas SET cas_end = 1711021160.942 WHERE cas_scnid = 001 AND cas_id = 16; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): DATA _null_; MPRINT(ENDTESTCALL): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_016.lst"; MPRINT(ENDTESTCALL): INPUT; MPRINT(ENDTESTCALL): CALL symput ('l_filled','1'); MPRINT(ENDTESTCALL): STOP; MPRINT(ENDTESTCALL): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_016.lst" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\001_016.lst, RECFM=V,LRECL=256,Dateigröße (Byte)=0, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr 96 Das SAS System 11:39 Friday, March 21, 20 NOTE: 0 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_016.lst". NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): ODS _ALL_ CLOSE; MPRINT(ASSERTLOGMSG): ; MPRINT(ASSERTLOGMSG): PROC SQL NOPRINT; MPRINT(ASSERTLOGMSG): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(ASSERTLOGMSG): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ASSERTLOGMSG): DATA _null_; MPRINT(ASSERTLOGMSG): RETAIN pattern_id; MPRINT(ASSERTLOGMSG): IF _n_=1 THEN DO; MPRINT(ASSERTLOGMSG): pattern_id = prxparse("/ERROR: BOXPLOT: Y VARIABLE NOT SPECIFIED/"); MPRINT(ASSERTLOGMSG): END; MPRINT(ASSERTLOGMSG): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_016.log" END=eof TRUNCOVER; MPRINT(ASSERTLOGMSG): INPUT logrec $char256.; MPRINT(ASSERTLOGMSG): logrec = upcase(logrec); MPRINT(ASSERTLOGMSG): IF prxmatch (pattern_id, logrec) THEN DO; MPRINT(ASSERTLOGMSG): call symput ('l_msg_found', '1'); MPRINT(ASSERTLOGMSG): END; MPRINT(ASSERTLOGMSG): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_016.log" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\log\001_016.log, RECFM=V,LRECL=256,Dateigröße (Byte)=1315, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 22 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_016.log". The minimum record length was 0. The maximum record length was 256. One or more lines were truncated. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE(SASUNIT): assertLogMsg: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 16 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 16 ,1 ,"assertLogMsg" ,"Scan for log messages " ,"1ERROR: boxplot: Y variable not specified " ,"1 " ,0 ,"assertLogMsg: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): 97 Das SAS System 11:39 Friday, March 21, 20 real time 0.01 seconds cpu time 0.01 seconds ========================== Check 16.1 (assertLogMsg) ===================================== 172 %assertEquals(i_actual=%sysfunc(fileexist(&g_work\report16.pdf)), i_expected=0, i_desc=no report created) NOTE(SASUNIT): assertEquals: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 16 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 16 ,2 ,"assertEquals" ,"no report created " ,"0 " ,"0 " ,0 ,"assertEquals: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 16.2 (assertEquals) ===================================== 173 %endTestcase(i_assertLog=0) MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max (tst_res) INTO :l_result FROM target.tst WHERE tst_scnid=001 AND tst_casid=16; MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): UPDATE target.cas SET cas_res = 0 WHERE cas_scnid = 001 AND cas_id = 16; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 174 175 /*-- Error: y variable not numeric -------------------------------------------*/ 176 %initTestcase(i_object=boxplot.sas, i_desc=y variable not numeric) MPRINT(INITTESTCASE): PROC SQL NOPRINT; MPRINT(INITTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(INITTESTCASE): INSERT INTO target.cas VALUES ( 001 ,17 ,2 ,"boxplot.sas" ,"y variable not numeric" , MPRINT(INITTESTCASE): "" ,1711021160.973 ,. ,. ); 98 Das SAS System 11:39 Friday, March 21, 20 NOTE: 1 row was inserted into TARGET.CAS. MPRINT(INITTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds ========================== test case 17 ====================================================== MPRINT(INITTESTCASE): PROC PRINTTO NEW LOG="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_017.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_017.lst" ; MPRINT(INITTESTCASE): RUN; NOTE: PROZEDUR PRINTTO used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds 99 Das SAS System 11:39 Friday, March 21, 20 cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): UPDATE target.cas SET cas_end = 1711021161.004 WHERE cas_scnid = 001 AND cas_id = 17; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): DATA _null_; MPRINT(ENDTESTCALL): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_017.lst"; MPRINT(ENDTESTCALL): INPUT; MPRINT(ENDTESTCALL): CALL symput ('l_filled','1'); MPRINT(ENDTESTCALL): STOP; MPRINT(ENDTESTCALL): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_017.lst" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\001_017.lst, RECFM=V,LRECL=256,Dateigröße (Byte)=0, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 0 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_017.lst". NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): ODS _ALL_ CLOSE; MPRINT(ASSERTLOGMSG): ; MPRINT(ASSERTLOGMSG): PROC SQL NOPRINT; MPRINT(ASSERTLOGMSG): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(ASSERTLOGMSG): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ASSERTLOGMSG): DATA _null_; MPRINT(ASSERTLOGMSG): RETAIN pattern_id; MPRINT(ASSERTLOGMSG): IF _n_=1 THEN DO; MPRINT(ASSERTLOGMSG): pattern_id = prxparse("/ERROR: BOXPLOT: VARIABLE SBPC IN DATA SET BLOOD_PRESSURE MUST BE NUMERIC/"); 100 Das SAS System 11:39 Friday, March 21, 20 MPRINT(ASSERTLOGMSG): END; MPRINT(ASSERTLOGMSG): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_017.log" END=eof TRUNCOVER; MPRINT(ASSERTLOGMSG): INPUT logrec $char256.; MPRINT(ASSERTLOGMSG): logrec = upcase(logrec); MPRINT(ASSERTLOGMSG): IF prxmatch (pattern_id, logrec) THEN DO; MPRINT(ASSERTLOGMSG): call symput ('l_msg_found', '1'); MPRINT(ASSERTLOGMSG): END; MPRINT(ASSERTLOGMSG): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_017.log" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\log\001_017.log, RECFM=V,LRECL=256,Dateigröße (Byte)=1533, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 32 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_017.log". The minimum record length was 0. The maximum record length was 247. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE(SASUNIT): assertLogMsg: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 17 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 17 ,1 ,"assertLogMsg" ,"Scan for log messages " ,"1ERROR: boxplot: Variable sbpc in data set blood_pressure must be numeric " ,"1 " ,0 ,"assertLogMsg: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 17.1 (assertLogMsg) ===================================== 183 %assertEquals(i_actual=%sysfunc(fileexist(&g_work\report17.pdf)), i_expected=0, i_desc=no report created) NOTE(SASUNIT): assertEquals: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 17 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 17 ,2 ,"assertEquals" ,"no report created " ,"0 " ,"0 " ,0 ,"assertEquals: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 17.2 (assertEquals) ===================================== 184 %endTestcase(i_assertLog=0) MPRINT(ENDTESTCASE): PROC SQL NOPRINT; 101 Das SAS System 11:39 Friday, March 21, 20 MPRINT(ENDTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max (tst_res) INTO :l_result FROM target.tst WHERE tst_scnid=001 AND tst_casid=17; MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): UPDATE target.cas SET cas_res = 0 WHERE cas_scnid = 001 AND cas_id = 17; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 185 186 /*-- Error: invalid group variable -------------------------------------------*/ 187 %initTestcase(i_object=boxplot.sas, i_desc=invalid group variable) MPRINT(INITTESTCASE): PROC SQL NOPRINT; MPRINT(INITTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(INITTESTCASE): INSERT INTO target.cas VALUES ( 001 ,18 ,2 ,"boxplot.sas" ,"invalid group variable" , MPRINT(INITTESTCASE): "" ,1711021161.035 ,. ,. ); NOTE: 1 row was inserted into TARGET.CAS. MPRINT(INITTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== test case 18 ====================================================== MPRINT(INITTESTCASE): PROC PRINTTO NEW LOG="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_018.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_018.lst" ; MPRINT(INITTESTCASE): RUN; NOTE: PROZEDUR PRINTTO used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): UPDATE target.cas SET cas_end = 1711021161.051 WHERE cas_scnid = 001 AND cas_id = 18; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): DATA _null_; MPRINT(ENDTESTCALL): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_018.lst"; MPRINT(ENDTESTCALL): INPUT; MPRINT(ENDTESTCALL): CALL symput ('l_filled','1'); MPRINT(ENDTESTCALL): STOP; MPRINT(ENDTESTCALL): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_018.lst" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\001_018.lst, RECFM=V,LRECL=256,Dateigröße (Byte)=0, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr 103 Das SAS System 11:39 Friday, March 21, 20 NOTE: 0 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_018.lst". NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): ODS _ALL_ CLOSE; MPRINT(ASSERTLOGMSG): ; MPRINT(ASSERTLOGMSG): PROC SQL NOPRINT; MPRINT(ASSERTLOGMSG): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(ASSERTLOGMSG): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ASSERTLOGMSG): DATA _null_; MPRINT(ASSERTLOGMSG): RETAIN pattern_id; MPRINT(ASSERTLOGMSG): IF _n_=1 THEN DO; MPRINT(ASSERTLOGMSG): pattern_id = prxparse("/ERROR: BOXPLOT: VARIABLE MEDXXX DOES NOT EXIST IN DATA SET TESTDATA.BLOOD_PRESSURE/"); MPRINT(ASSERTLOGMSG): END; MPRINT(ASSERTLOGMSG): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_018.log" END=eof TRUNCOVER; MPRINT(ASSERTLOGMSG): INPUT logrec $char256.; MPRINT(ASSERTLOGMSG): logrec = upcase(logrec); MPRINT(ASSERTLOGMSG): IF prxmatch (pattern_id, logrec) THEN DO; MPRINT(ASSERTLOGMSG): call symput ('l_msg_found', '1'); MPRINT(ASSERTLOGMSG): END; MPRINT(ASSERTLOGMSG): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_018.log" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\log\001_018.log, RECFM=V,LRECL=256,Dateigröße (Byte)=1405, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 22 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_018.log". The minimum record length was 0. The maximum record length was 256. One or more lines were truncated. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE(SASUNIT): assertLogMsg: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 18 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 18 ,1 ,"assertLogMsg" ,"Scan for log messages " ,"1ERROR: boxplot: Variable medXXX does not exist in data set testdata.blood_pressure " ,"1 " ,0 ,"assertLogMsg: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds 104 Das SAS System 11:39 Friday, March 21, 20 cpu time 0.00 seconds ========================== Check 18.1 (assertLogMsg) ===================================== 190 %assertEquals(i_actual=%sysfunc(fileexist(&g_work\report18.pdf)), i_expected=0, i_desc=no report created) NOTE(SASUNIT): assertEquals: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 18 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 18 ,2 ,"assertEquals" ,"no report created " ,"0 " ,"0 " ,0 ,"assertEquals: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds ========================== Check 18.2 (assertEquals) ===================================== 191 %endTestcase(i_assertLog=0) MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max (tst_res) INTO :l_result FROM target.tst WHERE tst_scnid=001 AND tst_casid=18; MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): UPDATE target.cas SET cas_res = 0 WHERE cas_scnid = 001 AND cas_id = 18; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 192 193 /*-- Error: group variable not specified -------------------------------------*/ 194 %initTestcase(i_object=boxplot.sas, i_desc=group variable not specified) MPRINT(INITTESTCASE): PROC SQL NOPRINT; MPRINT(INITTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(INITTESTCASE): INSERT INTO target.cas VALUES ( 001 ,19 ,2 ,"boxplot.sas" ,"group variable not specified" , MPRINT(INITTESTCASE): "" ,1711021161.082 ,. ,. ); NOTE: 1 row was inserted into TARGET.CAS. 105 Das SAS System 11:39 Friday, March 21, 20 MPRINT(INITTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== test case 19 ====================================================== MPRINT(INITTESTCASE): PROC PRINTTO NEW LOG="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_019.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_019.lst" ; MPRINT(INITTESTCASE): RUN; NOTE: PROZEDUR PRINTTO used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): UPDATE target.cas SET cas_end = 1711021161.112 WHERE cas_scnid = 001 AND cas_id = 19; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 106 Das SAS System 11:39 Friday, March 21, 20 MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): DATA _null_; MPRINT(ENDTESTCALL): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_019.lst"; MPRINT(ENDTESTCALL): INPUT; MPRINT(ENDTESTCALL): CALL symput ('l_filled','1'); MPRINT(ENDTESTCALL): STOP; MPRINT(ENDTESTCALL): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_019.lst" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\001_019.lst, RECFM=V,LRECL=256,Dateigröße (Byte)=0, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 0 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_019.lst". NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): ODS _ALL_ CLOSE; MPRINT(ASSERTLOGMSG): ; MPRINT(ASSERTLOGMSG): PROC SQL NOPRINT; MPRINT(ASSERTLOGMSG): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(ASSERTLOGMSG): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(ASSERTLOGMSG): DATA _null_; MPRINT(ASSERTLOGMSG): RETAIN pattern_id; MPRINT(ASSERTLOGMSG): IF _n_=1 THEN DO; MPRINT(ASSERTLOGMSG): pattern_id = prxparse("/ERROR: BOXPLOT: GROUP VARIABLE NOT SPECIFIED/"); MPRINT(ASSERTLOGMSG): END; MPRINT(ASSERTLOGMSG): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_019.log" END=eof TRUNCOVER; MPRINT(ASSERTLOGMSG): INPUT logrec $char256.; MPRINT(ASSERTLOGMSG): logrec = upcase(logrec); MPRINT(ASSERTLOGMSG): IF prxmatch (pattern_id, logrec) THEN DO; MPRINT(ASSERTLOGMSG): call symput ('l_msg_found', '1'); MPRINT(ASSERTLOGMSG): END; MPRINT(ASSERTLOGMSG): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_019.log" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\log\001_019.log, RECFM=V,LRECL=256,Dateigröße (Byte)=1066, Zuletzt geändert=21. März 2014 11.39 Uhr, 107 Das SAS System 11:39 Friday, March 21, 20 Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 20 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_019.log". The minimum record length was 0. The maximum record length was 247. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE(SASUNIT): assertLogMsg: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 19 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 19 ,1 ,"assertLogMsg" ,"Scan for log messages " ,"1ERROR: boxplot: Group variable not specified " ,"1 " ,0 ,"assertLogMsg: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 19.1 (assertLogMsg) ===================================== 197 %assertEquals(i_actual=%sysfunc(fileexist(&g_work\report19.pdf)), i_expected=0, i_desc=no report created) NOTE(SASUNIT): assertEquals: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 19 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 19 ,2 ,"assertEquals" ,"no report created " ,"0 " ,"0 " ,0 ,"assertEquals: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 19.2 (assertEquals) ===================================== 198 %endTestcase(i_assertLog=0) MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max (tst_res) INTO :l_result FROM target.tst WHERE tst_scnid=001 AND tst_casid=19; MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 108 Das SAS System 11:39 Friday, March 21, 20 MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): UPDATE target.cas SET cas_res = 0 WHERE cas_scnid = 001 AND cas_id = 19; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 199 200 /*-- Error: group variable has only one value --------------------------------*/ 201 %initTestcase(i_object=boxplot.sas, i_desc=group variable has only one value) MPRINT(INITTESTCASE): PROC SQL NOPRINT; MPRINT(INITTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(INITTESTCASE): INSERT INTO target.cas VALUES ( 001 ,20 ,2 ,"boxplot.sas" ,"group variable has only one value" , MPRINT(INITTESTCASE): "" ,1711021161.143 ,. ,. ); NOTE: 1 row was inserted into TARGET.CAS. MPRINT(INITTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== test case 20 ====================================================== MPRINT(INITTESTCASE): PROC PRINTTO NEW LOG="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_020.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_020.lst" ; MPRINT(INITTESTCASE): RUN; NOTE: PROZEDUR PRINTTO used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): UPDATE target.cas SET cas_end = 1711021161.174 WHERE cas_scnid = 001 AND cas_id = 20; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): DATA _null_; MPRINT(ENDTESTCALL): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_020.lst"; MPRINT(ENDTESTCALL): INPUT; MPRINT(ENDTESTCALL): CALL symput ('l_filled','1'); MPRINT(ENDTESTCALL): STOP; 110 Das SAS System 11:39 Friday, March 21, 20 MPRINT(ENDTESTCALL): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_020.lst" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\001_020.lst, RECFM=V,LRECL=256,Dateigröße (Byte)=0, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 0 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_020.lst". NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): ODS _ALL_ CLOSE; MPRINT(ASSERTLOGMSG): ; MPRINT(ASSERTLOGMSG): PROC SQL NOPRINT; MPRINT(ASSERTLOGMSG): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(ASSERTLOGMSG): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(ASSERTLOGMSG): DATA _null_; MPRINT(ASSERTLOGMSG): RETAIN pattern_id; MPRINT(ASSERTLOGMSG): IF _n_=1 THEN DO; MPRINT(ASSERTLOGMSG): pattern_id = prxparse("/ERROR: BOXPLOT: VARIABLE MED MUST HAVE EXACTLY TWO VALUES/"); MPRINT(ASSERTLOGMSG): END; MPRINT(ASSERTLOGMSG): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_020.log" END=eof TRUNCOVER; MPRINT(ASSERTLOGMSG): INPUT logrec $char256.; MPRINT(ASSERTLOGMSG): logrec = upcase(logrec); MPRINT(ASSERTLOGMSG): IF prxmatch (pattern_id, logrec) THEN DO; MPRINT(ASSERTLOGMSG): call symput ('l_msg_found', '1'); MPRINT(ASSERTLOGMSG): END; MPRINT(ASSERTLOGMSG): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_020.log" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\log\001_020.log, RECFM=V,LRECL=256,Dateigröße (Byte)=2096, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 43 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_020.log". The minimum record length was 0. The maximum record length was 256. One or more lines were truncated. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE(SASUNIT): assertLogMsg: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; 111 Das SAS System 11:39 Friday, March 21, 20 MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 20 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 20 ,1 ,"assertLogMsg" ,"Scan for log messages " ,"1ERROR: boxplot: Variable med must have exactly two values " ,"1 " ,0 ,"assertLogMsg: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 20.1 (assertLogMsg) ===================================== 208 %assertEquals(i_actual=%sysfunc(fileexist(&g_work\report20.pdf)), i_expected=0, i_desc=no report created) NOTE(SASUNIT): assertEquals: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 20 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 20 ,2 ,"assertEquals" ,"no report created " ,"0 " ,"0 " ,0 ,"assertEquals: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 20.2 (assertEquals) ===================================== 209 %endTestcase(i_assertLog=0) MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max (tst_res) INTO :l_result FROM target.tst WHERE tst_scnid=001 AND tst_casid=20; MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): UPDATE target.cas SET cas_res = 0 WHERE cas_scnid = 001 AND cas_id = 20; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 112 Das SAS System 11:39 Friday, March 21, 20 210 211 /*-- Error: group variable has more than two values -------------------------*/ 212 %initTestcase(i_object=boxplot.sas, i_desc=group variable has more than two values) MPRINT(INITTESTCASE): PROC SQL NOPRINT; MPRINT(INITTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(INITTESTCASE): INSERT INTO target.cas VALUES ( 001 ,21 ,2 ,"boxplot.sas" ,"group variable has more than two values" , MPRINT(INITTESTCASE): "" ,1711021161.205 ,. ,. ); NOTE: 1 row was inserted into TARGET.CAS. MPRINT(INITTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== test case 21 ====================================================== MPRINT(INITTESTCASE): PROC PRINTTO NEW LOG="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_021.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_021.lst" ; MPRINT(INITTESTCASE): RUN; NOTE: PROZEDUR PRINTTO used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): UPDATE target.cas SET cas_end = 1711021161.236 WHERE cas_scnid = 001 AND cas_id = 21; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): DATA _null_; MPRINT(ENDTESTCALL): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_021.lst"; MPRINT(ENDTESTCALL): INPUT; MPRINT(ENDTESTCALL): CALL symput ('l_filled','1'); MPRINT(ENDTESTCALL): STOP; MPRINT(ENDTESTCALL): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_021.lst" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\001_021.lst, RECFM=V,LRECL=256,Dateigröße (Byte)=0, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr 114 Das SAS System 11:39 Friday, March 21, 20 NOTE: 0 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_021.lst". NOTE: DATA-Anweisung used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(ENDTESTCALL): ODS _ALL_ CLOSE; MPRINT(ASSERTLOGMSG): ; MPRINT(ASSERTLOGMSG): PROC SQL NOPRINT; MPRINT(ASSERTLOGMSG): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(ASSERTLOGMSG): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ASSERTLOGMSG): DATA _null_; MPRINT(ASSERTLOGMSG): RETAIN pattern_id; MPRINT(ASSERTLOGMSG): IF _n_=1 THEN DO; MPRINT(ASSERTLOGMSG): pattern_id = prxparse("/ERROR: BOXPLOT: VARIABLE MED MUST HAVE EXACTLY TWO VALUES/"); MPRINT(ASSERTLOGMSG): END; MPRINT(ASSERTLOGMSG): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_021.log" END=eof TRUNCOVER; MPRINT(ASSERTLOGMSG): INPUT logrec $char256.; MPRINT(ASSERTLOGMSG): logrec = upcase(logrec); MPRINT(ASSERTLOGMSG): IF prxmatch (pattern_id, logrec) THEN DO; MPRINT(ASSERTLOGMSG): call symput ('l_msg_found', '1'); MPRINT(ASSERTLOGMSG): END; MPRINT(ASSERTLOGMSG): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_021.log" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\log\001_021.log, RECFM=V,LRECL=256,Dateigröße (Byte)=2236, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 48 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_021.log". The minimum record length was 0. The maximum record length was 256. One or more lines were truncated. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE(SASUNIT): assertLogMsg: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 21 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 21 ,1 ,"assertLogMsg" ,"Scan for log messages " ,"1ERROR: boxplot: Variable med must have exactly two values " ,"1 " ,0 ,"assertLogMsg: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): 115 Das SAS System 11:39 Friday, March 21, 20 real time 0.00 seconds cpu time 0.00 seconds ========================== Check 21.1 (assertLogMsg) ===================================== 224 %assertEquals(i_actual=%sysfunc(fileexist(&g_work\report21.pdf)), i_expected=0, i_desc=no report created) NOTE(SASUNIT): assertEquals: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 21 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 21 ,2 ,"assertEquals" ,"no report created " ,"0 " ,"0 " ,0 ,"assertEquals: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 21.2 (assertEquals) ===================================== 225 %endTestcase(i_assertLog=0) MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max (tst_res) INTO :l_result FROM target.tst WHERE tst_scnid=001 AND tst_casid=21; MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): UPDATE target.cas SET cas_res = 0 WHERE cas_scnid = 001 AND cas_id = 21; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 226 227 /*-- Error: group variable has missing values --------------------------------*/ 228 %initTestcase(i_object=boxplot.sas, i_desc=group variable has missing values) MPRINT(INITTESTCASE): PROC SQL NOPRINT; MPRINT(INITTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(INITTESTCASE): INSERT INTO target.cas VALUES ( 001 ,22 ,2 ,"boxplot.sas" ,"group variable has missing values" , MPRINT(INITTESTCASE): "" ,1711021161.267 ,. ,. ); 116 Das SAS System 11:39 Friday, March 21, 20 NOTE: 1 row was inserted into TARGET.CAS. MPRINT(INITTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== test case 22 ====================================================== MPRINT(INITTESTCASE): PROC PRINTTO NEW LOG="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_022.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_022.lst" ; MPRINT(INITTESTCASE): RUN; NOTE: PROZEDUR PRINTTO used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): UPDATE target.cas SET cas_end = 1711021161.298 WHERE cas_scnid = 001 AND cas_id = 22; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): PROC SQL NOPRINT; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCALL): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): DATA _null_; MPRINT(ENDTESTCALL): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_022.lst"; MPRINT(ENDTESTCALL): INPUT; MPRINT(ENDTESTCALL): CALL symput ('l_filled','1'); MPRINT(ENDTESTCALL): STOP; MPRINT(ENDTESTCALL): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_022.lst" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\001_022.lst, RECFM=V,LRECL=256,Dateigröße (Byte)=0, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 0 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001_022.lst". NOTE: DATA-Anweisung used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(ENDTESTCALL): ODS _ALL_ CLOSE; MPRINT(ASSERTLOGMSG): ; 118 Das SAS System 11:39 Friday, March 21, 20 MPRINT(ASSERTLOGMSG): PROC SQL NOPRINT; MPRINT(ASSERTLOGMSG): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 001; MPRINT(ASSERTLOGMSG): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ASSERTLOGMSG): DATA _null_; MPRINT(ASSERTLOGMSG): RETAIN pattern_id; MPRINT(ASSERTLOGMSG): IF _n_=1 THEN DO; MPRINT(ASSERTLOGMSG): pattern_id = prxparse("/ERROR: BOXPLOT: MISSING VALUES IN GROUP VARIABLE ARE NOT ALLOWED/"); MPRINT(ASSERTLOGMSG): END; MPRINT(ASSERTLOGMSG): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_022.log" END=eof TRUNCOVER; MPRINT(ASSERTLOGMSG): INPUT logrec $char256.; MPRINT(ASSERTLOGMSG): logrec = upcase(logrec); MPRINT(ASSERTLOGMSG): IF prxmatch (pattern_id, logrec) THEN DO; MPRINT(ASSERTLOGMSG): call symput ('l_msg_found', '1'); MPRINT(ASSERTLOGMSG): END; MPRINT(ASSERTLOGMSG): RUN; NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_022.log" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\log\001_022.log, RECFM=V,LRECL=256,Dateigröße (Byte)=2196, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 46 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001_022.log". The minimum record length was 0. The maximum record length was 256. One or more lines were truncated. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE(SASUNIT): assertLogMsg: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 22 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 22 ,1 ,"assertLogMsg" ,"Scan for log messages " ,"1ERROR: boxplot: Missing values in group variable are not allowed " ,"1 " ,0 ,"assertLogMsg: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 22.1 (assertLogMsg) ===================================== 238 %assertEquals(i_actual=%sysfunc(fileexist(&g_work\report22.pdf)), i_expected=0, i_desc=no report created) NOTE(SASUNIT): assertEquals: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; 119 Das SAS System 11:39 Friday, March 21, 20 MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 001 AND tst_casid = 22 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 001 , 22 ,2 ,"assertEquals" ,"no report created " ,"0 " ,"0 " ,0 ,"assertEquals: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 22.2 (assertEquals) ===================================== 239 %endTestcase(i_assertLog=0) MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=001; MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max (tst_res) INTO :l_result FROM target.tst WHERE tst_scnid=001 AND tst_casid=22; MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): UPDATE target.cas SET cas_res = 0 WHERE cas_scnid = 001 AND cas_id = 22; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 240 241 /** \endcond */ NOTE: The macro _TERMSCENARIO completed compilation without errors. 26 instructions 520 bytes. NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414 NOTE: Das SAS System used: real time 3.34 seconds cpu time 2.68 seconds