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.10 seconds cpu time 0.10 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\_TD824_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\_TD824_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 generate.sas 6 7 Example for a test scenario with the following features: 8 - generate test data as part of the test scenario 9 - compare whole library with assertLibrary.sas 10 - generate various test cases 11 - check error handling with assertLogMsg.sas 12 - suppress automatic log scanning in endTestcase.sas 13 14 \version \$Revision: 315 $ - KL: Added hint for support of different languages in test assertion.\n 15 Revision: 40 - KL: Added support for different languages in test assertion. 16 \author \$Author: klandwich $ 17 \date \$Date: 2014-02-28 10:25:18 +0100 (Fr, 28 Feb 2014) $ 18 \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> 19 \sa \$HeadURL: https://svn.code.sf.net/p/sasunit/code/trunk/example/saspgm/generate_test.sas $ 20 \copyright Copyright 2010, 2012 HMS Analytical Software GmbH. 21 This file is part of SASUnit, the Unit testing framework for SAS(R) programs. 22 For terms of usage under the GPL license see included file readme.txt 23 or https://sourceforge.net/p/sasunit/wiki/readme.v1.2/. 24 */ /** \cond */ 25 26 /*-- Testcase 1: one by variable ---------------------------------------------*/ 27 %initTestcase(i_object=generate.sas, i_desc=example with one by variable) 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; 5 Das SAS System 11:39 Friday, March 21, 20 MPRINT(INITTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 003; MPRINT(INITTESTCASE): INSERT INTO target.cas VALUES ( 003 ,1 ,2 ,"generate.sas" ,"example with one by variable" , MPRINT(INITTESTCASE): "" ,1711021162.814 ,. ,. ); 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/003_001.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/003_001.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=003; 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 = 1711021162.922 WHERE cas_scnid = 003 AND cas_id = 1; 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=003; 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/003_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/003_001.lst" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\003_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 9 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/003_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; 46 %assertLibrary(i_actual=test1, i_expected=test2, i_desc=check libraries) NOTE: The macro ASSERTLIBRARY completed compilation without errors. 205 instructions 5848 bytes. NOTE: The macro _GETSCENARIOTESTID completed compilation without errors. 137 instructions 3692 bytes. 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 = 003; 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 = 003 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(ASSERTLIBRARY): ; NOTE: The macro TRIM completed compilation without errors. 42 instructions 800 bytes. NOTE: The macro _ASSERTLIBRARY completed compilation without errors. 288 instructions 10860 bytes. MPRINT(_ASSERTLIBRARY): proc sql noprint; MPRINT(_ASSERTLIBRARY): create table WORK._assertLibraryActual as select libname as BaseLibname, memname as BaseMemName, nlobs as BaseObs format=commax18., nvar as BaseNVar format=commax18. from dictionary.tables where libname = "TEST1" order by memname NOTE: Table WORK._ASSERTLIBRARYACTUAL created, with 2 rows and 4 columns. MPRINT(_ASSERTLIBRARY): create table WORK._assertLibraryExpected as select libname as CmpLibname, memname as CmpMemName, nlobs as CmpObs format=commax18., nvar as CmpNVar format=commax18. from dictionary.tables where libname = "TEST2" order by memname; NOTE: Table WORK._ASSERTLIBRARYEXPECTED created, with 2 rows and 4 columns. MPRINT(_ASSERTLIBRARY): quit; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(_ASSERTLIBRARY): data work._ergebnis; MPRINT(_ASSERTLIBRARY): length DoCompare CompareFailed l_rc 8; MPRINT(_ASSERTLIBRARY): merge WORK._assertLibraryActual (in=InAct rename=(BaseMemname=memname)) WORK._assertLibraryExpected (in=InExp rename=(CmpMemname=memname)); 10 Das SAS System 11:39 Friday, March 21, 20 MPRINT(_ASSERTLIBRARY): by memname; MPRINT(_ASSERTLIBRARY): l_rc = .; MPRINT(_ASSERTLIBRARY): InActual=InAct; MPRINT(_ASSERTLIBRARY): InExpected=InExp; MPRINT(_ASSERTLIBRARY): if (InAct AND inExp) then do; MPRINT(_ASSERTLIBRARY): DoCompare=1; MPRINT(_ASSERTLIBRARY): CompareFailed=2; MPRINT(_ASSERTLIBRARY): if (BaseObs ne CmpObs) then do; MPRINT(_ASSERTLIBRARY): if ("STRICT" = "STRICT" OR "STRICT" = "MORECOLUMNS") then do; MPRINT(_ASSERTLIBRARY): DoCompare=0; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): if (BaseNVar ne CmpNVar) then do; MPRINT(_ASSERTLIBRARY): if ("STRICT" = "STRICT" OR "STRICT" = "MOREOBS") then do; MPRINT(_ASSERTLIBRARY): DoCompare=0; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): else if (InAct AND not inExp AND "STRICT" ne "STRICT") then do; MPRINT(_ASSERTLIBRARY): DoCompare=0; MPRINT(_ASSERTLIBRARY): CompareFailed=0; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): else do; MPRINT(_ASSERTLIBRARY): DoCompare=0; MPRINT(_ASSERTLIBRARY): CompareFailed=2; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): run; NOTE: There were 2 observations read from the data set WORK._ASSERTLIBRARYACTUAL. NOTE: There were 2 observations read from the data set WORK._ASSERTLIBRARYEXPECTED. NOTE: The data set WORK._ERGEBNIS has 2 observations and 12 variables. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_ASSERTLIBRARY): proc sql noprint; MPRINT(_ASSERTLIBRARY): select sum (DoCompare) into :AnzCompares from work._ergebnis; MPRINT(_ASSERTLIBRARY): quit; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(_ASSERTLIBRARY): proc sql noprint; MPRINT(_ASSERTLIBRARY): select memname into :Memname1-: MPRINT(TRIM): Memname2 MPRINT(_ASSERTLIBRARY): from work._ergebnis where DoCompare=1; MPRINT(_ASSERTLIBRARY): quit; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 11 Das SAS System 11:39 Friday, March 21, 20 MPRINT(_ASSERTLIBRARY): proc sql noprint; MPRINT(_ASSERTLIBRARY): select count (*) into :OpenODSDestinations from sashelp.vdest; MPRINT(_ASSERTLIBRARY): quit; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_ASSERTLIBRARY): ods listing; MPRINT(_ASSERTLIBRARY): proc compare base=test2.CLASS1 compare=test1.CLASS1 noprint; MPRINT(_ASSERTLIBRARY): run; NOTE: There were 9 observations read from the data set TEST2.CLASS1. NOTE: There were 9 observations read from the data set TEST1.CLASS1. NOTE: PROZEDUR COMPARE used (Total process time): real time 0.09 seconds cpu time 0.00 seconds MPRINT(_ASSERTLIBRARY): proc sql noprint; MPRINT(_ASSERTLIBRARY): update work._ergebnis set l_rc=0 where upcase (memname)="CLASS1"; NOTE: 1 row was updated in WORK._ERGEBNIS. MPRINT(_ASSERTLIBRARY): quit; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(_ASSERTLIBRARY): proc compare base=test2.CLASS2 compare=test1.CLASS2 noprint; MPRINT(_ASSERTLIBRARY): run; NOTE: There were 10 observations read from the data set TEST2.CLASS2. NOTE: There were 10 observations read from the data set TEST1.CLASS2. NOTE: PROZEDUR COMPARE used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_ASSERTLIBRARY): proc sql noprint; MPRINT(_ASSERTLIBRARY): update work._ergebnis set l_rc=0 where upcase (memname)="CLASS2"; NOTE: 1 row was updated in WORK._ERGEBNIS. MPRINT(_ASSERTLIBRARY): quit; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_ASSERTLIBRARY): ods listing close; MPRINT(_ASSERTLIBRARY): data work._ergebnis; MPRINT(_ASSERTLIBRARY): set work._ergebnis; MPRINT(_ASSERTLIBRARY): select (l_rc); MPRINT(_ASSERTLIBRARY): when (0) Comparefailed=0; 12 Das SAS System 11:39 Friday, March 21, 20 MPRINT(_ASSERTLIBRARY): when (128) do; MPRINT(_ASSERTLIBRARY): if ("STRICT" = "MOREOBS" OR "STRICT" = "MORECOLSNOBS") then do; MPRINT(_ASSERTLIBRARY): Comparefailed=0; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): when (2048) do; MPRINT(_ASSERTLIBRARY): if ("STRICT" = "MORECOLUMNS" OR "STRICT" = "MORECOLSNOBS") then do; MPRINT(_ASSERTLIBRARY): Comparefailed=0; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): when (2176) do; MPRINT(_ASSERTLIBRARY): if ("STRICT" = "MORECOLSNOBS") then do; MPRINT(_ASSERTLIBRARY): Comparefailed=0; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): otherwise; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): run; NOTE: There were 2 observations read from the data set WORK._ERGEBNIS. NOTE: The data set WORK._ERGEBNIS has 2 observations and 12 variables. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_ASSERTLIBRARY): data work._ergebnis; MPRINT(_ASSERTLIBRARY): length i_LibraryCheck i_CompareCheck $15 i_id i_ExcludeList $80; MPRINT(_ASSERTLIBRARY): set work._ergebnis; MPRINT(_ASSERTLIBRARY): i_LibraryCheck="STRICT"; MPRINT(_ASSERTLIBRARY): i_CompareCheck="STRICT"; MPRINT(_ASSERTLIBRARY): i_id="_NONE_"; MPRINT(_ASSERTLIBRARY): i_ExcludeList="_NONE_"; MPRINT(_ASSERTLIBRARY): run; NOTE: There were 2 observations read from the data set WORK._ERGEBNIS. NOTE: The data set WORK._ERGEBNIS has 2 observations and 16 variables. NOTE: DATA-Anweisung used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(_ASSERTLIBRARY): proc sql noprint; MPRINT(_ASSERTLIBRARY): select max (CompareFailed) into :l_rc from work._ergebnis; MPRINT(_ASSERTLIBRARY): 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 = 003; MPRINT(_GETSCENARIOTESTID): QUIT; 13 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 = 003 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(_ASSERTLIBRARY): ; 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): ; MPRINT(_MKDIR): options noxwait xsync xmin; MPRINT(_MKDIR): options XWAIT XSYNC NOXMIN; MPRINT(_CREATETESTSUBFOLDER): ; MPRINT(_ASSERTLIBRARY): ; MPRINT(_ASSERTLIBRARY): *** Capture tables instead of ODS DOCUMENT ***; MPRINT(_ASSERTLIBRARY): libname _alLib "c:/.jenkins/jobs/SASUnit Build Release ZIP-File/workspace/v1.3/example/doc/sasunit/de/tst/_003_001_001_assertlibrary"; NOTE: Libref _ALLIB 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\_003_001_001_assertlibrary MPRINT(_ASSERTLIBRARY): ods document name=_alLib._Library_act(WRITE); MPRINT(_ASSERTLIBRARY): proc print data=WORK._assertLibraryActual label noobs; MPRINT(_ASSERTLIBRARY): run; NOTE: There were 2 observations read from the data set WORK._ASSERTLIBRARYACTUAL. NOTE: PROZEDUR PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_ASSERTLIBRARY): ods document close; MPRINT(_ASSERTLIBRARY): ods document name=_alLib._Library_exp(WRITE); MPRINT(_ASSERTLIBRARY): proc print data=WORK._assertLibraryExpected label noobs; MPRINT(_ASSERTLIBRARY): run; NOTE: There were 2 observations read from the data set WORK._ASSERTLIBRARYEXPECTED. NOTE: PROZEDUR PRINT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(_ASSERTLIBRARY): ods document close; MPRINT(_ASSERTLIBRARY): data _alLib._Library_rep; MPRINT(_ASSERTLIBRARY): set work._ergebnis; MPRINT(_ASSERTLIBRARY): run; 14 Das SAS System 11:39 Friday, March 21, 20 NOTE: There were 2 observations read from the data set WORK._ERGEBNIS. NOTE: The data set _ALLIB._LIBRARY_REP has 2 observations and 16 variables. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_ASSERTLIBRARY): libname _alLib clear; NOTE: Libref _ALLIB has been deassigned. MPRINT(_ASSERTLIBRARY): proc datasets lib=work nolist memtype=(data view); MPRINT(_ASSERTLIBRARY): delete _ergebnis _assertLibraryActual _assertLibraryExpected; MPRINT(_ASSERTLIBRARY): quit; NOTE: Deleting WORK._ERGEBNIS (memtype=DATA). NOTE: Deleting WORK._ASSERTLIBRARYACTUAL (memtype=DATA). NOTE: Deleting WORK._ASSERTLIBRARYEXPECTED (memtype=DATA). NOTE: PROZEDUR DATASETS used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ASSERTLIBRARY): ; MPRINT(ASSERTLIBRARY): ; MPRINT(ASSERTLIBRARY): *** update result in test database ***; NOTE: The macro _ASSERTS completed compilation without errors. 152 instructions 4104 bytes. NOTE(SASUNIT): assertLibrary: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=003; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 003 AND tst_casid = 1 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 003 , 1 ,1 ,"assertLibrary" ,"check libraries " ,"test2 " ,"test1 " ,0 ,"assertLibrary: 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.1 (assertLibrary) ===================================== 47 %endTestcase() /* assertLog is called implicitly */ 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=003; MPRINT(ENDTESTCASE): SELECT count(*) INTO :l_assertLog FROM target.tst WHERE tst_scnid = 003 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; 15 Das SAS System 11:39 Friday, March 21, 20 MPRINT(ASSERTLOG): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 003; 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/003_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[: ]/"); 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/003_001.log" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\log\003_001.log, RECFM=V,LRECL=256,Dateigröße (Byte)=6991, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 164 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/003_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.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=003; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 003 AND tst_casid = 1 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 003 , 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; 16 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 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=003 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 = 0 WHERE cas_scnid = 003 AND cas_id = 1; 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 48 49 /*-- Testcase 2: two by variables --------------------------------------------*/ 50 %initTestcase(i_object=generate.sas, i_desc=example with two by variables) MPRINT(INITTESTCASE): PROC SQL NOPRINT; MPRINT(INITTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 003; MPRINT(INITTESTCASE): INSERT INTO target.cas VALUES ( 003 ,2 ,2 ,"generate.sas" ,"example with two by variables" , MPRINT(INITTESTCASE): "" ,1711021163.201 ,. ,. ); 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 2 ====================================================== MPRINT(INITTESTCASE): PROC PRINTTO NEW LOG="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/003_002.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/003_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=003; 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 = 1711021163.34 WHERE cas_scnid = 003 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.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=003; 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/003_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/003_002.lst" is: 21 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\tst\003_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/003_002.lst". NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): ODS _ALL_ CLOSE; 73 %assertLibrary(i_actual=test1, i_expected=test2, i_desc=check libraries) 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 = 003; 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 = 003 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(ASSERTLIBRARY): ; MPRINT(_ASSERTLIBRARY): proc sql noprint; MPRINT(_ASSERTLIBRARY): create table WORK._assertLibraryActual as select libname as BaseLibname, memname as BaseMemName, nlobs as BaseObs format=commax18., nvar as BaseNVar format=commax18. from dictionary.tables where libname = "TEST1" order by memname NOTE: Table WORK._ASSERTLIBRARYACTUAL created, with 4 rows and 4 columns. MPRINT(_ASSERTLIBRARY): create table WORK._assertLibraryExpected as select libname as CmpLibname, memname as CmpMemName, nlobs as CmpObs format=commax18., nvar as CmpNVar format=commax18. from dictionary.tables where libname = "TEST2" order by memname; NOTE: Table WORK._ASSERTLIBRARYEXPECTED created, with 4 rows and 4 columns. MPRINT(_ASSERTLIBRARY): quit; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(_ASSERTLIBRARY): data work._ergebnis; MPRINT(_ASSERTLIBRARY): length DoCompare CompareFailed l_rc 8; MPRINT(_ASSERTLIBRARY): merge WORK._assertLibraryActual (in=InAct rename=(BaseMemname=memname)) WORK._assertLibraryExpected (in=InExp rename=(CmpMemname=memname)); MPRINT(_ASSERTLIBRARY): by memname; MPRINT(_ASSERTLIBRARY): l_rc = .; MPRINT(_ASSERTLIBRARY): InActual=InAct; MPRINT(_ASSERTLIBRARY): InExpected=InExp; MPRINT(_ASSERTLIBRARY): if (InAct AND inExp) then do; MPRINT(_ASSERTLIBRARY): DoCompare=1; 22 Das SAS System 11:39 Friday, March 21, 20 MPRINT(_ASSERTLIBRARY): CompareFailed=2; MPRINT(_ASSERTLIBRARY): if (BaseObs ne CmpObs) then do; MPRINT(_ASSERTLIBRARY): if ("STRICT" = "STRICT" OR "STRICT" = "MORECOLUMNS") then do; MPRINT(_ASSERTLIBRARY): DoCompare=0; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): if (BaseNVar ne CmpNVar) then do; MPRINT(_ASSERTLIBRARY): if ("STRICT" = "STRICT" OR "STRICT" = "MOREOBS") then do; MPRINT(_ASSERTLIBRARY): DoCompare=0; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): else if (InAct AND not inExp AND "STRICT" ne "STRICT") then do; MPRINT(_ASSERTLIBRARY): DoCompare=0; MPRINT(_ASSERTLIBRARY): CompareFailed=0; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): else do; MPRINT(_ASSERTLIBRARY): DoCompare=0; MPRINT(_ASSERTLIBRARY): CompareFailed=2; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): run; NOTE: There were 4 observations read from the data set WORK._ASSERTLIBRARYACTUAL. NOTE: There were 4 observations read from the data set WORK._ASSERTLIBRARYEXPECTED. NOTE: The data set WORK._ERGEBNIS has 4 observations and 12 variables. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_ASSERTLIBRARY): proc sql noprint; MPRINT(_ASSERTLIBRARY): select sum (DoCompare) into :AnzCompares from work._ergebnis; MPRINT(_ASSERTLIBRARY): quit; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_ASSERTLIBRARY): proc sql noprint; MPRINT(_ASSERTLIBRARY): select memname into :Memname1-: MPRINT(TRIM): Memname4 MPRINT(_ASSERTLIBRARY): from work._ergebnis where DoCompare=1; MPRINT(_ASSERTLIBRARY): quit; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_ASSERTLIBRARY): proc sql noprint; MPRINT(_ASSERTLIBRARY): select count (*) into :OpenODSDestinations from sashelp.vdest; MPRINT(_ASSERTLIBRARY): quit; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 23 Das SAS System 11:39 Friday, March 21, 20 MPRINT(_ASSERTLIBRARY): ods listing; MPRINT(_ASSERTLIBRARY): proc compare base=test2.PRDSALE1 compare=test1.PRDSALE1 noprint; MPRINT(_ASSERTLIBRARY): run; NOTE: There were 360 observations read from the data set TEST2.PRDSALE1. NOTE: There were 360 observations read from the data set TEST1.PRDSALE1. NOTE: PROZEDUR COMPARE used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_ASSERTLIBRARY): proc sql noprint; MPRINT(_ASSERTLIBRARY): update work._ergebnis set l_rc=0 where upcase (memname)="PRDSALE1"; NOTE: 1 row was updated in WORK._ERGEBNIS. MPRINT(_ASSERTLIBRARY): quit; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_ASSERTLIBRARY): proc compare base=test2.PRDSALE2 compare=test1.PRDSALE2 noprint; MPRINT(_ASSERTLIBRARY): run; NOTE: There were 360 observations read from the data set TEST2.PRDSALE2. NOTE: There were 360 observations read from the data set TEST1.PRDSALE2. NOTE: PROZEDUR COMPARE used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(_ASSERTLIBRARY): proc sql noprint; MPRINT(_ASSERTLIBRARY): update work._ergebnis set l_rc=0 where upcase (memname)="PRDSALE2"; NOTE: 1 row was updated in WORK._ERGEBNIS. MPRINT(_ASSERTLIBRARY): quit; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_ASSERTLIBRARY): proc compare base=test2.PRDSALE3 compare=test1.PRDSALE3 noprint; MPRINT(_ASSERTLIBRARY): run; NOTE: There were 360 observations read from the data set TEST2.PRDSALE3. NOTE: There were 360 observations read from the data set TEST1.PRDSALE3. NOTE: PROZEDUR COMPARE used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_ASSERTLIBRARY): proc sql noprint; 24 Das SAS System 11:39 Friday, March 21, 20 MPRINT(_ASSERTLIBRARY): update work._ergebnis set l_rc=0 where upcase (memname)="PRDSALE3"; NOTE: 1 row was updated in WORK._ERGEBNIS. MPRINT(_ASSERTLIBRARY): quit; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_ASSERTLIBRARY): proc compare base=test2.PRDSALE4 compare=test1.PRDSALE4 noprint; MPRINT(_ASSERTLIBRARY): run; NOTE: There were 360 observations read from the data set TEST2.PRDSALE4. NOTE: There were 360 observations read from the data set TEST1.PRDSALE4. NOTE: PROZEDUR COMPARE used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_ASSERTLIBRARY): proc sql noprint; MPRINT(_ASSERTLIBRARY): update work._ergebnis set l_rc=0 where upcase (memname)="PRDSALE4"; NOTE: 1 row was updated in WORK._ERGEBNIS. MPRINT(_ASSERTLIBRARY): quit; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(_ASSERTLIBRARY): ods listing close; MPRINT(_ASSERTLIBRARY): data work._ergebnis; MPRINT(_ASSERTLIBRARY): set work._ergebnis; MPRINT(_ASSERTLIBRARY): select (l_rc); MPRINT(_ASSERTLIBRARY): when (0) Comparefailed=0; MPRINT(_ASSERTLIBRARY): when (128) do; MPRINT(_ASSERTLIBRARY): if ("STRICT" = "MOREOBS" OR "STRICT" = "MORECOLSNOBS") then do; MPRINT(_ASSERTLIBRARY): Comparefailed=0; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): when (2048) do; MPRINT(_ASSERTLIBRARY): if ("STRICT" = "MORECOLUMNS" OR "STRICT" = "MORECOLSNOBS") then do; MPRINT(_ASSERTLIBRARY): Comparefailed=0; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): when (2176) do; MPRINT(_ASSERTLIBRARY): if ("STRICT" = "MORECOLSNOBS") then do; MPRINT(_ASSERTLIBRARY): Comparefailed=0; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): otherwise; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): run; NOTE: There were 4 observations read from the data set WORK._ERGEBNIS. 25 Das SAS System 11:39 Friday, March 21, 20 NOTE: The data set WORK._ERGEBNIS has 4 observations and 12 variables. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_ASSERTLIBRARY): data work._ergebnis; MPRINT(_ASSERTLIBRARY): length i_LibraryCheck i_CompareCheck $15 i_id i_ExcludeList $80; MPRINT(_ASSERTLIBRARY): set work._ergebnis; MPRINT(_ASSERTLIBRARY): i_LibraryCheck="STRICT"; MPRINT(_ASSERTLIBRARY): i_CompareCheck="STRICT"; MPRINT(_ASSERTLIBRARY): i_id="_NONE_"; MPRINT(_ASSERTLIBRARY): i_ExcludeList="_NONE_"; MPRINT(_ASSERTLIBRARY): run; NOTE: There were 4 observations read from the data set WORK._ERGEBNIS. NOTE: The data set WORK._ERGEBNIS has 4 observations and 16 variables. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_ASSERTLIBRARY): proc sql noprint; MPRINT(_ASSERTLIBRARY): select max (CompareFailed) into :l_rc from work._ergebnis; MPRINT(_ASSERTLIBRARY): 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 = 003; MPRINT(_GETSCENARIOTESTID): 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(tst_id) INTO :l_tstid_gti FROM target.tst WHERE tst_scnid = 003 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(_ASSERTLIBRARY): ; MPRINT(_CREATETESTSUBFOLDER): ; MPRINT(_MKDIR): options noxwait xsync xmin; MPRINT(_MKDIR): options XWAIT XSYNC NOXMIN; MPRINT(_CREATETESTSUBFOLDER): ; MPRINT(_ASSERTLIBRARY): ; 26 Das SAS System 11:39 Friday, March 21, 20 MPRINT(_ASSERTLIBRARY): *** Capture tables instead of ODS DOCUMENT ***; MPRINT(_ASSERTLIBRARY): libname _alLib "c:/.jenkins/jobs/SASUnit Build Release ZIP-File/workspace/v1.3/example/doc/sasunit/de/tst/_003_002_001_assertlibrary"; NOTE: Libref _ALLIB 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\_003_002_001_assertlibrary MPRINT(_ASSERTLIBRARY): ods document name=_alLib._Library_act(WRITE); MPRINT(_ASSERTLIBRARY): proc print data=WORK._assertLibraryActual label noobs; MPRINT(_ASSERTLIBRARY): run; NOTE: There were 4 observations read from the data set WORK._ASSERTLIBRARYACTUAL. NOTE: PROZEDUR PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_ASSERTLIBRARY): ods document close; MPRINT(_ASSERTLIBRARY): ods document name=_alLib._Library_exp(WRITE); MPRINT(_ASSERTLIBRARY): proc print data=WORK._assertLibraryExpected label noobs; MPRINT(_ASSERTLIBRARY): run; NOTE: There were 4 observations read from the data set WORK._ASSERTLIBRARYEXPECTED. NOTE: PROZEDUR PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_ASSERTLIBRARY): ods document close; MPRINT(_ASSERTLIBRARY): data _alLib._Library_rep; MPRINT(_ASSERTLIBRARY): set work._ergebnis; MPRINT(_ASSERTLIBRARY): run; NOTE: There were 4 observations read from the data set WORK._ERGEBNIS. NOTE: The data set _ALLIB._LIBRARY_REP has 4 observations and 16 variables. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_ASSERTLIBRARY): libname _alLib clear; NOTE: Libref _ALLIB has been deassigned. MPRINT(_ASSERTLIBRARY): proc datasets lib=work nolist memtype=(data view); MPRINT(_ASSERTLIBRARY): delete _ergebnis _assertLibraryActual _assertLibraryExpected; MPRINT(_ASSERTLIBRARY): quit; NOTE: Deleting WORK._ERGEBNIS (memtype=DATA). NOTE: Deleting WORK._ASSERTLIBRARYACTUAL (memtype=DATA). NOTE: Deleting WORK._ASSERTLIBRARYEXPECTED (memtype=DATA). NOTE: PROZEDUR DATASETS used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(ASSERTLIBRARY): ; MPRINT(ASSERTLIBRARY): ; MPRINT(ASSERTLIBRARY): *** update result in test database ***; 27 Das SAS System 11:39 Friday, March 21, 20 NOTE(SASUNIT): assertLibrary: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=003; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 003 AND tst_casid = 2 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 003 , 2 ,1 ,"assertLibrary" ,"check libraries " ,"test2 " ,"test1 " ,0 ,"assertLibrary: 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.1 (assertLibrary) ===================================== 74 %endTestcase() MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=003; MPRINT(ENDTESTCASE): SELECT count(*) INTO :l_assertLog FROM target.tst WHERE tst_scnid = 003 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 = 003; 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/003_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/003_002.log" is: 28 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\003_002.log, RECFM=V,LRECL=256,Dateigröße (Byte)=8689, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 195 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/003_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.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=003; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 003 AND tst_casid = 2 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 003 , 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=003 AND tst_casid=2; 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 = 003 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 75 76 /*-- Testcase 3: one by variable with only one value -------------------------*/ 77 %initTestcase(i_object=generate.sas, i_desc=example with one by variable with only one value) MPRINT(INITTESTCASE): PROC SQL NOPRINT; MPRINT(INITTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 003; MPRINT(INITTESTCASE): INSERT INTO target.cas VALUES ( 003 ,3 ,2 ,"generate.sas" ,"example with one by variable with only one value" , MPRINT(INITTESTCASE): "" ,1711021163.572 ,. ,. ); 29 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 3 ====================================================== MPRINT(INITTESTCASE): PROC PRINTTO NEW LOG="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/003_003.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/003_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=003; 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 = 1711021163.634 WHERE cas_scnid = 003 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.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=003; 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/003_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/003_003.lst" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\003_003.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/003_003.lst". 33 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(ENDTESTCALL): ODS _ALL_ CLOSE; 94 %assertLibrary(i_actual=test1, i_expected=test2, i_desc=check libraries) 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 = 003; 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 = 003 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(ASSERTLIBRARY): ; MPRINT(_ASSERTLIBRARY): proc sql noprint; MPRINT(_ASSERTLIBRARY): create table WORK._assertLibraryActual as select libname as BaseLibname, memname as BaseMemName, nlobs as BaseObs format=commax18., nvar as BaseNVar format=commax18. from dictionary.tables where libname = "TEST1" order by memname NOTE: Table WORK._ASSERTLIBRARYACTUAL created, with 1 rows and 4 columns. MPRINT(_ASSERTLIBRARY): create table WORK._assertLibraryExpected as select libname as CmpLibname, memname as CmpMemName, nlobs as CmpObs format=commax18., nvar as CmpNVar format=commax18. from dictionary.tables where libname = "TEST2" order by memname; NOTE: Table WORK._ASSERTLIBRARYEXPECTED created, with 1 rows and 4 columns. MPRINT(_ASSERTLIBRARY): quit; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(_ASSERTLIBRARY): data work._ergebnis; MPRINT(_ASSERTLIBRARY): length DoCompare CompareFailed l_rc 8; MPRINT(_ASSERTLIBRARY): merge WORK._assertLibraryActual (in=InAct rename=(BaseMemname=memname)) WORK._assertLibraryExpected (in=InExp rename=(CmpMemname=memname)); MPRINT(_ASSERTLIBRARY): by memname; MPRINT(_ASSERTLIBRARY): l_rc = .; MPRINT(_ASSERTLIBRARY): InActual=InAct; MPRINT(_ASSERTLIBRARY): InExpected=InExp; MPRINT(_ASSERTLIBRARY): if (InAct AND inExp) then do; MPRINT(_ASSERTLIBRARY): DoCompare=1; MPRINT(_ASSERTLIBRARY): CompareFailed=2; MPRINT(_ASSERTLIBRARY): if (BaseObs ne CmpObs) then do; MPRINT(_ASSERTLIBRARY): if ("STRICT" = "STRICT" OR "STRICT" = "MORECOLUMNS") then do; MPRINT(_ASSERTLIBRARY): DoCompare=0; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): end; 34 Das SAS System 11:39 Friday, March 21, 20 MPRINT(_ASSERTLIBRARY): if (BaseNVar ne CmpNVar) then do; MPRINT(_ASSERTLIBRARY): if ("STRICT" = "STRICT" OR "STRICT" = "MOREOBS") then do; MPRINT(_ASSERTLIBRARY): DoCompare=0; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): else if (InAct AND not inExp AND "STRICT" ne "STRICT") then do; MPRINT(_ASSERTLIBRARY): DoCompare=0; MPRINT(_ASSERTLIBRARY): CompareFailed=0; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): else do; MPRINT(_ASSERTLIBRARY): DoCompare=0; MPRINT(_ASSERTLIBRARY): CompareFailed=2; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): run; NOTE: There were 1 observations read from the data set WORK._ASSERTLIBRARYACTUAL. NOTE: There were 1 observations read from the data set WORK._ASSERTLIBRARYEXPECTED. NOTE: The data set WORK._ERGEBNIS has 1 observations and 12 variables. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_ASSERTLIBRARY): proc sql noprint; MPRINT(_ASSERTLIBRARY): select sum (DoCompare) into :AnzCompares from work._ergebnis; MPRINT(_ASSERTLIBRARY): quit; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_ASSERTLIBRARY): proc sql noprint; MPRINT(_ASSERTLIBRARY): select memname into :Memname1-: MPRINT(TRIM): Memname1 MPRINT(_ASSERTLIBRARY): from work._ergebnis where DoCompare=1; MPRINT(_ASSERTLIBRARY): quit; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_ASSERTLIBRARY): proc sql noprint; MPRINT(_ASSERTLIBRARY): select count (*) into :OpenODSDestinations from sashelp.vdest; MPRINT(_ASSERTLIBRARY): quit; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(_ASSERTLIBRARY): ods listing; MPRINT(_ASSERTLIBRARY): proc compare base=test2.CLASS1 compare=test1.CLASS1 noprint; MPRINT(_ASSERTLIBRARY): run; 35 Das SAS System 11:39 Friday, March 21, 20 NOTE: There were 9 observations read from the data set TEST2.CLASS1. NOTE: There were 9 observations read from the data set TEST1.CLASS1. NOTE: PROZEDUR COMPARE used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_ASSERTLIBRARY): proc sql noprint; MPRINT(_ASSERTLIBRARY): update work._ergebnis set l_rc=0 where upcase (memname)="CLASS1"; NOTE: 1 row was updated in WORK._ERGEBNIS. MPRINT(_ASSERTLIBRARY): quit; NOTE: PROZEDUR SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(_ASSERTLIBRARY): ods listing close; MPRINT(_ASSERTLIBRARY): data work._ergebnis; MPRINT(_ASSERTLIBRARY): set work._ergebnis; MPRINT(_ASSERTLIBRARY): select (l_rc); MPRINT(_ASSERTLIBRARY): when (0) Comparefailed=0; MPRINT(_ASSERTLIBRARY): when (128) do; MPRINT(_ASSERTLIBRARY): if ("STRICT" = "MOREOBS" OR "STRICT" = "MORECOLSNOBS") then do; MPRINT(_ASSERTLIBRARY): Comparefailed=0; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): when (2048) do; MPRINT(_ASSERTLIBRARY): if ("STRICT" = "MORECOLUMNS" OR "STRICT" = "MORECOLSNOBS") then do; MPRINT(_ASSERTLIBRARY): Comparefailed=0; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): when (2176) do; MPRINT(_ASSERTLIBRARY): if ("STRICT" = "MORECOLSNOBS") then do; MPRINT(_ASSERTLIBRARY): Comparefailed=0; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): otherwise; MPRINT(_ASSERTLIBRARY): end; MPRINT(_ASSERTLIBRARY): run; NOTE: There were 1 observations read from the data set WORK._ERGEBNIS. NOTE: The data set WORK._ERGEBNIS has 1 observations and 12 variables. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_ASSERTLIBRARY): data work._ergebnis; MPRINT(_ASSERTLIBRARY): length i_LibraryCheck i_CompareCheck $15 i_id i_ExcludeList $80; MPRINT(_ASSERTLIBRARY): set work._ergebnis; MPRINT(_ASSERTLIBRARY): i_LibraryCheck="STRICT"; MPRINT(_ASSERTLIBRARY): i_CompareCheck="STRICT"; MPRINT(_ASSERTLIBRARY): i_id="_NONE_"; 36 Das SAS System 11:39 Friday, March 21, 20 MPRINT(_ASSERTLIBRARY): i_ExcludeList="_NONE_"; MPRINT(_ASSERTLIBRARY): run; NOTE: There were 1 observations read from the data set WORK._ERGEBNIS. NOTE: The data set WORK._ERGEBNIS has 1 observations and 16 variables. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_ASSERTLIBRARY): proc sql noprint; MPRINT(_ASSERTLIBRARY): select max (CompareFailed) into :l_rc from work._ergebnis; MPRINT(_ASSERTLIBRARY): 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 = 003; 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 = 003 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(_ASSERTLIBRARY): ; MPRINT(_CREATETESTSUBFOLDER): ; MPRINT(_MKDIR): options noxwait xsync xmin; MPRINT(_MKDIR): options XWAIT XSYNC NOXMIN; MPRINT(_CREATETESTSUBFOLDER): ; MPRINT(_ASSERTLIBRARY): ; MPRINT(_ASSERTLIBRARY): *** Capture tables instead of ODS DOCUMENT ***; MPRINT(_ASSERTLIBRARY): libname _alLib "c:/.jenkins/jobs/SASUnit Build Release ZIP-File/workspace/v1.3/example/doc/sasunit/de/tst/_003_003_001_assertlibrary"; NOTE: Libref _ALLIB 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\_003_003_001_assertlibrary MPRINT(_ASSERTLIBRARY): ods document name=_alLib._Library_act(WRITE); MPRINT(_ASSERTLIBRARY): proc print data=WORK._assertLibraryActual label noobs; MPRINT(_ASSERTLIBRARY): run; NOTE: There were 1 observations read from the data set WORK._ASSERTLIBRARYACTUAL. NOTE: PROZEDUR PRINT 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(_ASSERTLIBRARY): ods document close; MPRINT(_ASSERTLIBRARY): ods document name=_alLib._Library_exp(WRITE); MPRINT(_ASSERTLIBRARY): proc print data=WORK._assertLibraryExpected label noobs; MPRINT(_ASSERTLIBRARY): run; NOTE: There were 1 observations read from the data set WORK._ASSERTLIBRARYEXPECTED. NOTE: PROZEDUR PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_ASSERTLIBRARY): ods document close; MPRINT(_ASSERTLIBRARY): data _alLib._Library_rep; MPRINT(_ASSERTLIBRARY): set work._ergebnis; MPRINT(_ASSERTLIBRARY): run; NOTE: There were 1 observations read from the data set WORK._ERGEBNIS. NOTE: The data set _ALLIB._LIBRARY_REP has 1 observations and 16 variables. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(_ASSERTLIBRARY): libname _alLib clear; NOTE: Libref _ALLIB has been deassigned. MPRINT(_ASSERTLIBRARY): proc datasets lib=work nolist memtype=(data view); MPRINT(_ASSERTLIBRARY): delete _ergebnis _assertLibraryActual _assertLibraryExpected; MPRINT(_ASSERTLIBRARY): quit; NOTE: Deleting WORK._ERGEBNIS (memtype=DATA). NOTE: Deleting WORK._ASSERTLIBRARYACTUAL (memtype=DATA). NOTE: Deleting WORK._ASSERTLIBRARYEXPECTED (memtype=DATA). NOTE: PROZEDUR DATASETS used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(ASSERTLIBRARY): ; MPRINT(ASSERTLIBRARY): ; MPRINT(ASSERTLIBRARY): *** update result in test database ***; NOTE(SASUNIT): assertLibrary: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=003; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 003 AND tst_casid = 3 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 003 , 3 ,1 ,"assertLibrary" ,"check libraries " ,"test2 " ,"test1 " ,0 ,"assertLibrary: 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 38 Das SAS System 11:39 Friday, March 21, 20 ========================== Check 3.1 (assertLibrary) ===================================== 95 %endTestcase() MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=003; MPRINT(ENDTESTCASE): SELECT count(*) INTO :l_assertLog FROM target.tst WHERE tst_scnid = 003 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 = 003; 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/003_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/003_003.log" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\log\003_003.log, RECFM=V,LRECL=256,Dateigröße (Byte)=6595, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 165 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/003_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.01 seconds cpu time 0.01 seconds 39 Das SAS System 11:39 Friday, March 21, 20 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=003; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 003 AND tst_casid = 3 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 003 , 3 ,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 3.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=003 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 = 0 WHERE cas_scnid = 003 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.00 seconds cpu time 0.00 seconds 96 97 /*-- Testcase 4: invalid dataset ---------------------------------------------*/ 98 %initTestcase(i_object=generate.sas, i_desc=invalid dataset) MPRINT(INITTESTCASE): PROC SQL NOPRINT; MPRINT(INITTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 003; MPRINT(INITTESTCASE): INSERT INTO target.cas VALUES ( 003 ,4 ,2 ,"generate.sas" ,"invalid dataset" , MPRINT(INITTESTCASE): "" ,1711021163.773 ,. ,. ); 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/003_004.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/003_004.lst" ; MPRINT(INITTESTCASE): RUN; 40 Das SAS System 11:39 Friday, March 21, 20 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=003; 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 = 1711021163.835 WHERE cas_scnid = 003 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 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=003; 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/003_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/003_004.lst" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\003_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/003_004.lst". NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds 42 Das SAS System 11:39 Friday, March 21, 20 cpu time 0.00 seconds MPRINT(ENDTESTCALL): ODS _ALL_ CLOSE; 105 %assertLogMsg(i_logMsg=ERROR: Macro Generate: data= or by= specified incorrectly) NOTE: The macro ASSERTLOGMSG completed compilation without errors. 98 instructions 2864 bytes. MPRINT(ASSERTLOGMSG): PROC SQL NOPRINT; MPRINT(ASSERTLOGMSG): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 003; 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: MACRO GENERATE: DATA= OR BY= SPECIFIED INCORRECTLY/"); MPRINT(ASSERTLOGMSG): END; MPRINT(ASSERTLOGMSG): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/003_004.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/003_004.log" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\log\003_004.log, RECFM=V,LRECL=256,Dateigröße (Byte)=2469, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 63 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/003_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): assertLogMsg: assert passed. MPRINT(_ASSERTS): PROC SQL NOPRINT; MPRINT(_ASSERTS): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=003; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 003 AND tst_casid = 4 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 003 , 4 ,1 ,"assertLogMsg" ,"Scan for log messages " ,"1ERROR: Macro Generate: data= or by= specified incorrectly " ,"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 43 Das SAS System 11:39 Friday, March 21, 20 ========================== Check 4.1 (assertLogMsg) ===================================== 106 %endTestcase(i_assertLog=0) MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=003; 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=003 AND tst_casid=4; 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 = 003 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 107 108 /*-- Testcase 5: invalid by variable -----------------------------------------*/ 109 %initTestcase(i_object=generate.sas, i_desc=invalid by variable) MPRINT(INITTESTCASE): PROC SQL NOPRINT; MPRINT(INITTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 003; MPRINT(INITTESTCASE): INSERT INTO target.cas VALUES ( 003 ,5 ,2 ,"generate.sas" ,"invalid by variable" , MPRINT(INITTESTCASE): "" ,1711021163.866 ,. ,. ); 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/003_005.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/003_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=003; 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 = 1711021163.897 WHERE cas_scnid = 003 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=003; 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/003_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/003_005.lst" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\003_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/003_005.lst". NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): ODS _ALL_ CLOSE; 116 %assertLogMsg(i_logMsg=ERROR: Macro Generate: data= or by= specified incorrectly) MPRINT(ASSERTLOGMSG): PROC SQL NOPRINT; MPRINT(ASSERTLOGMSG): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 003; 46 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: MACRO GENERATE: DATA= OR BY= SPECIFIED INCORRECTLY/"); MPRINT(ASSERTLOGMSG): END; MPRINT(ASSERTLOGMSG): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/003_005.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/003_005.log" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\log\003_005.log, RECFM=V,LRECL=256,Dateigröße (Byte)=2623, Zuletzt geändert=21. März 2014 11.39 Uhr, Erstellungsuhrzeit=21. März 2014 11.39 Uhr NOTE: 63 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/003_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.01 seconds cpu time 0.01 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=003; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 003 AND tst_casid = 5 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 003 , 5 ,1 ,"assertLogMsg" ,"Scan for log messages " ,"1ERROR: Macro Generate: data= or by= specified incorrectly " ,"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 5.1 (assertLogMsg) ===================================== 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=003; MPRINT(ENDTESTCASE): QUIT; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds 47 Das SAS System 11:39 Friday, March 21, 20 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=003 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 = 0 WHERE cas_scnid = 003 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 118 119 /*-- Testcase 6: invalid output library --------------------------------------*/ 120 %initTestcase(i_object=generate.sas, i_desc=invalid output library) MPRINT(INITTESTCASE): PROC SQL NOPRINT; MPRINT(INITTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 003; MPRINT(INITTESTCASE): INSERT INTO target.cas VALUES ( 003 ,6 ,2 ,"generate.sas" ,"invalid output library" , MPRINT(INITTESTCASE): "" ,1711021163.912 ,. ,. ); 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 6 ====================================================== MPRINT(INITTESTCASE): PROC PRINTTO NEW LOG="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/003_006.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/003_006.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=003; 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 = 1711021164.005 WHERE cas_scnid = 003 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; MPRINT(ENDTESTCALL): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=003; 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/003_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/003_006.lst" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\003_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/003_006.lst". NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): ODS _ALL_ CLOSE; 51 Das SAS System 11:39 Friday, March 21, 20 127 %assertLogMsg(i_logMsg=ERROR: (Libname|Libref) TEST3 is not assigned|ERROR: (Libname|Libref) TEST3 ist nicht zugewiesen 128 ,i_desc=regular expression used to support different languages 129 ) MPRINT(ASSERTLOGMSG): PROC SQL NOPRINT; MPRINT(ASSERTLOGMSG): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 003; 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: (LIBNAME|LIBREF) TEST3 IS NOT ASSIGNED|ERROR: (LIBNAME|LIBREF) TEST3 IST NICHT ZUGEWIESEN/"); MPRINT(ASSERTLOGMSG): END; MPRINT(ASSERTLOGMSG): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/003_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/003_006.log" is: Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\log\003_006.log, RECFM=V,LRECL=256,Dateigröße (Byte)=5320, 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/003_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=003; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 003 AND tst_casid = 6 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 003 , 6 ,1 ,"assertLogMsg" ,"regular expression used to support different languages " ,"1ERROR: (Libname|Libref) TEST3 is not assigned|ERROR: (Libname|Libref) TEST3 ist nicht zugewiesen " ,"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 6.1 (assertLogMsg) ===================================== 52 Das SAS System 11:39 Friday, March 21, 20 130 %endTestcase(i_assertLog=0) MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=003; 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=003 AND tst_casid=6; 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 = 003 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.01 seconds 131 132 libname test1; NOTE: Libref TEST1 has been deassigned. 133 libname test2; NOTE: Libref TEST2 has been deassigned. 134 135 /** \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 1.43 seconds cpu time 1.07 seconds