Errors : 0
Warnings: 0
1 The 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.16 seconds cpu time 0.18 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\en"; 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\en 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 The 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 statement used (Total process time): real time 0.06 seconds cpu time 0.03 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: PROCEDURE 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, Catalog Page Size=4096, Number of Catalog Pages=4, Created=Freitag, 21. März 2014 11.39 Uhr, Last Modified=Freitag, 21. März 2014 11.39 Uhr, Filename=C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2920_HD1PCMS0104_\detect.sas7bcat, Release Created=9.0301M2,Host Created=X64_7PRO NOTE: 1 record was read from the infile _DETECT. The minimum record length was 50. The maximum record length was 50. NOTE: DATA statement used (Total process time): 3 The SAS System 11:39 Friday, March 21, 20 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: PROCEDURE DATASETS used (Total process time): real time 0.07 seconds cpu time 0.07 seconds MPRINT(_LOADENVIRONMENT): LIBNAME testout "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\en/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\en\tst MPRINT(_LOADENVIRONMENT): FILENAME testout "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\en/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 refers to the same physical library as 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\en/tst GLOBAL G_LOG c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\en/log GLOBAL G_SASCFG c:.jenkinsjobsSASUnit Build Release ZIPFileworkspacev1.3/examplebinsasunit.9.3.windows.en.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 GLOBAL G_SASAUTOS7 4 The SAS System 11:39 Friday, March 21, 20 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\en 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\_TD2920_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 nobs.sas - has to fail! 6 7 Examplpe for a test scenario with the following features: 8 - create simple test scenario 9 - check value of macro symbol with assertEquals.sas 10 11 \version \$Revision: 315 $ 12 \author \$Author: klandwich $ 13 \date \$Date: 2014-02-28 10:25:18 +0100 (Fr, 28 Feb 2014) $ 14 \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> 15 \sa \$HeadURL: https://svn.code.sf.net/p/sasunit/code/trunk/example/saspgm/nobs_test.sas $ 16 \copyright Copyright 2010, 2012 HMS Analytical Software GmbH. 17 This file is part of SASUnit, the Unit testing framework for SAS(R) programs. 18 For terms of usage under the GPL license see included file readme.txt 19 or https://sourceforge.net/p/sasunit/wiki/readme.v1.2/. 20 */ /** \cond */ 21 22 /*-- simple example with sashelp.class ---------------------------------------*/ 23 %initTestcase(i_object=nobs.sas, i_desc=simple example with sashelp.class) 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 = 005; MPRINT(INITTESTCASE): INSERT INTO target.cas VALUES ( 005 ,1 ,2 ,"nobs.sas" ,"simple example with sashelp.class" , MPRINT(INITTESTCASE): "" ,1711021194.353 ,. ,. ); NOTE: 1 row was inserted into TARGET.CAS. 5 The SAS System 11:39 Friday, March 21, 20 MPRINT(INITTESTCASE): QUIT; NOTE: PROCEDURE 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\en/log/005_001.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\en/tst/005_001.lst" ; MPRINT(INITTESTCASE): RUN; NOTE: PROCEDURE 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=005; NOTE: PROCEDURE 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 = 1711021194.368 WHERE cas_scnid = 005 AND cas_id = 1; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCALL): QUIT; NOTE: PROCEDURE 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=005; MPRINT(ENDTESTCALL): QUIT; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 6 The 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\en/tst/005_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\en/tst/005_001.lst" is: Filename=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\en\tst\005_001.lst, RECFM=V,LRECL=256,File Size (bytes)=0, Last Modified=21. März 2014 11.39 Uhr, Create Time=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\en/tst/005_001.lst". NOTE: DATA statement 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; 26 %assertEquals(i_actual=&nobs, i_expected=19, i_desc=number of observations in sashelp.class) NOTE: The macro ASSERTEQUALS completed compilation without errors. 99 instructions 2452 bytes. NOTE: The macro _ASSERTS completed compilation without errors. 152 instructions 4104 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=005; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 005 AND tst_casid = 1 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 005 , 1 ,1 ,"assertEquals" ,"number of observations in sashelp.class " ,"19 " ,"19 " ,0 ,"assertEquals: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 1.1 (assertEquals) ===================================== 27 %endTestcase() 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=005; MPRINT(ENDTESTCASE): SELECT count(*) INTO :l_assertLog FROM target.tst WHERE tst_scnid = 005 AND tst_casid = 1 AND tst_type='assertLog'; NOTE: The macro ASSERTLOG completed compilation without errors. 71 instructions 2420 bytes. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 7 The 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 = 005; MPRINT(ASSERTLOG): QUIT; NOTE: PROCEDURE 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\en/log/005_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\en/log/005_001.log" is: Filename=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\en\log\005_001.log, RECFM=V,LRECL=256,File Size (bytes)=689, Last Modified=21. März 2014 11.39 Uhr, Create Time=21. März 2014 11.39 Uhr NOTE: 14 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\en/log/005_001.log". The minimum record length was 0. The maximum record length was 247. NOTE: DATA statement 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=005; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 005 AND tst_casid = 1 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 005 , 1 ,2 ,"assertLog" ,"Scan log for errors " ,"0#0 " ,"0#0 " ,0 ,"assertLog: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. 8 The SAS System 11:39 Friday, March 21, 20 MPRINT(_ASSERTS): QUIT; NOTE: PROCEDURE 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=005 AND tst_casid=1; MPRINT(ENDTESTCASE): QUIT; NOTE: PROCEDURE 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 = 005 AND cas_id = 1; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCASE): QUIT; NOTE: PROCEDURE SQL used (Total process time): real time 0.06 seconds cpu time 0.06 seconds 28 29 /*-- failed test -------------------------------------------------------------*/ 30 %initTestcase(i_object=nobs.sas, i_desc=failed test - must be red!) MPRINT(INITTESTCASE): PROC SQL NOPRINT; MPRINT(INITTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 005; MPRINT(INITTESTCASE): INSERT INTO target.cas VALUES ( 005 ,2 ,2 ,"nobs.sas" ,"failed test - must be red!" , MPRINT(INITTESTCASE): "" ,1711021194.461 ,. ,. ); NOTE: 1 row was inserted into TARGET.CAS. MPRINT(INITTESTCASE): QUIT; NOTE: PROCEDURE 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\en/log/005_002.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\en/tst/005_002.lst" ; MPRINT(INITTESTCASE): RUN; NOTE: PROCEDURE 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=005; NOTE: PROCEDURE 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 = 1711021194.477 WHERE cas_scnid = 005 AND cas_id = 2; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCALL): QUIT; NOTE: PROCEDURE 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=005; MPRINT(ENDTESTCALL): QUIT; NOTE: PROCEDURE 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\en/tst/005_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\en/tst/005_002.lst" is: Filename=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\en\tst\005_002.lst, RECFM=V,LRECL=256,File Size (bytes)=0, Last Modified=21. März 2014 11.39 Uhr, Create Time=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\en/tst/005_002.lst". NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): ODS _ALL_ CLOSE; 33 %assertEquals(i_actual=&nobs, i_expected=20, i_desc=number of observations in dataset sashelp.class - must be red!) ERROR(SASUNIT): assertEquals failed: expected value equals 20, but actual value equals 19 10 The 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=005; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 005 AND tst_casid = 2 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 005 , 2 ,1 ,"assertEquals" ,"number of observations in dataset sashelp.class - must be red! " ,"20 " ,"19 " ,2 ,"assertEquals failed: expected value equals 20, but actual value equals 19" ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 2.1 (assertEquals) ===================================== 34 %endTestcase() MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=005; MPRINT(ENDTESTCASE): SELECT count(*) INTO :l_assertLog FROM target.tst WHERE tst_scnid = 005 AND tst_casid = 2 AND tst_type='assertLog'; NOTE: PROCEDURE 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 = 005; MPRINT(ASSERTLOG): QUIT; NOTE: PROCEDURE 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\en/log/005_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\en/log/005_002.log" is: Filename=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\en\log\005_002.log, 11 The SAS System 11:39 Friday, March 21, 20 RECFM=V,LRECL=256,File Size (bytes)=754, Last Modified=21. März 2014 11.39 Uhr, Create Time=21. März 2014 11.39 Uhr NOTE: 12 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\en/log/005_002.log". The minimum record length was 0. The maximum record length was 256. One or more lines were truncated. NOTE: DATA statement 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=005; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 005 AND tst_casid = 2 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 005 , 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: PROCEDURE 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=005 AND tst_casid=2; MPRINT(ENDTESTCASE): QUIT; NOTE: PROCEDURE 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 = 2 WHERE cas_scnid = 005 AND cas_id = 2; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCASE): QUIT; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 35 36 /*-- example with big dataset ------------------------------------------------*/ 37 %initTestcase(i_object=nobs.sas, i_desc=%str(example with big dataset)) MPRINT(INITTESTCASE): PROC SQL NOPRINT; MPRINT(INITTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 005; MPRINT(INITTESTCASE): INSERT INTO target.cas VALUES ( 005 ,3 ,2 ,"nobs.sas" ,"example with big dataset" , MPRINT(INITTESTCASE): "" ,1711021194.554 ,. ,. ); NOTE: 1 row was inserted into TARGET.CAS. 12 The SAS System 11:39 Friday, March 21, 20 MPRINT(INITTESTCASE): QUIT; NOTE: PROCEDURE 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\en/log/005_003.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\en/tst/005_003.lst" ; MPRINT(INITTESTCASE): RUN; NOTE: PROCEDURE 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=005; NOTE: PROCEDURE 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 = 1711021194.724 WHERE cas_scnid = 005 AND cas_id = 3; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCALL): QUIT; NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds 13 The SAS System 11:39 Friday, March 21, 20 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=005; MPRINT(ENDTESTCALL): QUIT; NOTE: PROCEDURE 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\en/tst/005_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\en/tst/005_003.lst" is: Filename=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\en\tst\005_003.lst, RECFM=V,LRECL=256,File Size (bytes)=0, Last Modified=21. März 2014 11.39 Uhr, Create Time=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\en/tst/005_003.lst". NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): ODS _ALL_ CLOSE; 46 %assertEquals(i_actual=&nobs, i_expected=1000000, i_desc=number of observations in dataset work.big) 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=005; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 005 AND tst_casid = 3 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 005 , 3 ,1 ,"assertEquals" ,"number of observations in dataset work.big " ,"1000000 " ,"1000000 " ,0 ,"assertEquals: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 3.1 (assertEquals) ===================================== 47 %endTestcase() MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=005; MPRINT(ENDTESTCASE): SELECT count(*) INTO :l_assertLog FROM target.tst WHERE tst_scnid = 005 AND tst_casid = 3 AND tst_type='assertLog'; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 14 The 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 = 005; MPRINT(ASSERTLOG): QUIT; NOTE: PROCEDURE 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\en/log/005_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\en/log/005_003.log" is: Filename=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\en\log\005_003.log, RECFM=V,LRECL=256,File Size (bytes)=845, Last Modified=21. März 2014 11.39 Uhr, Create Time=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\en/log/005_003.log". The minimum record length was 0. The maximum record length was 247. NOTE: DATA statement 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=005; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 005 AND tst_casid = 3 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 005 , 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: PROCEDURE SQL used (Total process time): 15 The SAS System 11:39 Friday, March 21, 20 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=005 AND tst_casid=3; MPRINT(ENDTESTCASE): QUIT; NOTE: PROCEDURE 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 = 005 AND cas_id = 3; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCASE): QUIT; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 48 49 /*-- example with empty dataset ----------------------------------------------*/ 50 %initTestcase(i_object=nobs.sas, i_desc=%str(example with empty dataset)) MPRINT(INITTESTCASE): PROC SQL NOPRINT; MPRINT(INITTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 005; MPRINT(INITTESTCASE): INSERT INTO target.cas VALUES ( 005 ,4 ,2 ,"nobs.sas" ,"example with empty dataset" , MPRINT(INITTESTCASE): "" ,1711021194.801 ,. ,. ); NOTE: 1 row was inserted into TARGET.CAS. MPRINT(INITTESTCASE): QUIT; NOTE: PROCEDURE 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\en/log/005_004.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\en/tst/005_004.lst" ; MPRINT(INITTESTCASE): RUN; NOTE: PROCEDURE 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=005; NOTE: PROCEDURE 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 = 1711021194.832 WHERE cas_scnid = 005 AND cas_id = 4; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCALL): QUIT; NOTE: PROCEDURE 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=005; MPRINT(ENDTESTCALL): QUIT; NOTE: PROCEDURE 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\en/tst/005_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\en/tst/005_004.lst" is: Filename=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\en\tst\005_004.lst, RECFM=V,LRECL=256,File Size (bytes)=0, Last Modified=21. März 2014 11.39 Uhr, Create Time=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\en/tst/005_004.lst". 17 The SAS System 11:39 Friday, March 21, 20 NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): ODS _ALL_ CLOSE; 56 %assertEquals(i_actual=&nobs, i_expected=0, i_desc=number of observations in dataset work.empty) 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=005; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 005 AND tst_casid = 4 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 005 , 4 ,1 ,"assertEquals" ,"number of observations in dataset work.empty " ,"0 " ,"0 " ,0 ,"assertEquals: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 4.1 (assertEquals) ===================================== 57 %endTestcase() MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=005; MPRINT(ENDTESTCASE): SELECT count(*) INTO :l_assertLog FROM target.tst WHERE tst_scnid = 005 AND tst_casid = 4 AND tst_type='assertLog'; NOTE: PROCEDURE 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 = 005; MPRINT(ASSERTLOG): QUIT; NOTE: PROCEDURE 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\en/log/005_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; 18 The SAS System 11:39 Friday, March 21, 20 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\en/log/005_004.log" is: Filename=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\en\log\005_004.log, RECFM=V,LRECL=256,File Size (bytes)=1016, Last Modified=21. März 2014 11.39 Uhr, Create Time=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\en/log/005_004.log". The minimum record length was 0. The maximum record length was 256. One or more lines were truncated. NOTE: DATA statement 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=005; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 005 AND tst_casid = 4 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 005 , 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: PROCEDURE 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=005 AND tst_casid=4; MPRINT(ENDTESTCASE): QUIT; NOTE: PROCEDURE 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 = 005 AND cas_id = 4; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCASE): QUIT; NOTE: PROCEDURE SQL used (Total process time): real time 0.03 seconds cpu time 0.01 seconds 19 The SAS System 11:39 Friday, March 21, 20 58 59 /*-- dataset not specified ---------------------------------------------------*/ 60 %initTestcase(i_object=nobs.sas, i_desc=%str(dataset not specified)) MPRINT(INITTESTCASE): PROC SQL NOPRINT; MPRINT(INITTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 005; MPRINT(INITTESTCASE): INSERT INTO target.cas VALUES ( 005 ,5 ,2 ,"nobs.sas" ,"dataset not specified" , MPRINT(INITTESTCASE): "" ,1711021194.879 ,. ,. ); NOTE: 1 row was inserted into TARGET.CAS. MPRINT(INITTESTCASE): QUIT; NOTE: PROCEDURE 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\en/log/005_005.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\en/tst/005_005.lst" ; MPRINT(INITTESTCASE): RUN; NOTE: PROCEDURE 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=005; NOTE: PROCEDURE 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 = 1711021194.91 WHERE cas_scnid = 005 AND cas_id = 5; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCALL): QUIT; NOTE: PROCEDURE 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=005; 20 The SAS System 11:39 Friday, March 21, 20 MPRINT(ENDTESTCALL): QUIT; NOTE: PROCEDURE 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\en/tst/005_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\en/tst/005_005.lst" is: Filename=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\en\tst\005_005.lst, RECFM=V,LRECL=256,File Size (bytes)=0, Last Modified=21. März 2014 11.39 Uhr, Create Time=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\en/tst/005_005.lst". NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): ODS _ALL_ CLOSE; 63 %assertEquals(i_actual=&nobs, i_expected=, i_desc=number of observations when dataset is not specified) 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=005; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 005 AND tst_casid = 5 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 005 , 5 ,1 ,"assertEquals" ,"number of observations when dataset is not specified " ," " ," " ,0 ,"assertEquals: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 5.1 (assertEquals) ===================================== 64 %endTestcase() MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=005; MPRINT(ENDTESTCASE): SELECT count(*) INTO :l_assertLog FROM target.tst WHERE tst_scnid = 005 AND tst_casid = 5 AND tst_type='assertLog'; NOTE: PROCEDURE 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 = 005; MPRINT(ASSERTLOG): QUIT; NOTE: PROCEDURE SQL used (Total process time): 21 The SAS System 11:39 Friday, March 21, 20 real time 0.01 seconds cpu time 0.01 seconds MPRINT(_CHECKLOG): DATA _null_; MPRINT(_CHECKLOG): INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\en/log/005_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\en/log/005_005.log" is: Filename=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\en\log\005_005.log, RECFM=V,LRECL=256,File Size (bytes)=483, Last Modified=21. März 2014 11.39 Uhr, Create Time=21. März 2014 11.39 Uhr NOTE: 10 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\en/log/005_005.log". The minimum record length was 0. The maximum record length was 247. NOTE: DATA statement 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=005; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 005 AND tst_casid = 5 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 005 , 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; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 5.2 (assertLog) ===================================== 22 The SAS System 11:39 Friday, March 21, 20 MPRINT(ENDTESTCASE): QUIT; MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max (tst_res) INTO :l_result FROM target.tst WHERE tst_scnid=005 AND tst_casid=5; MPRINT(ENDTESTCASE): QUIT; NOTE: PROCEDURE SQL used (Total process time): real time 0.03 seconds cpu time 0.01 seconds MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): UPDATE target.cas SET cas_res = 0 WHERE cas_scnid = 005 AND cas_id = 5; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCASE): QUIT; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 65 66 /*-- invalid dataset ---------------------------------------------------------*/ 67 %initTestcase(i_object=nobs.sas, i_desc=%str(invalid dataset)) MPRINT(INITTESTCASE): PROC SQL NOPRINT; MPRINT(INITTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 005; MPRINT(INITTESTCASE): INSERT INTO target.cas VALUES ( 005 ,6 ,2 ,"nobs.sas" ,"invalid dataset" , MPRINT(INITTESTCASE): "" ,1711021194.971 ,. ,. ); NOTE: 1 row was inserted into TARGET.CAS. MPRINT(INITTESTCASE): QUIT; NOTE: PROCEDURE 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\en/log/005_006.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\en/tst/005_006.lst" ; MPRINT(INITTESTCASE): RUN; NOTE: PROCEDURE PRINTTO used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 23 The 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=005; NOTE: PROCEDURE 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 = 1711021194.987 WHERE cas_scnid = 005 AND cas_id = 6; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCALL): QUIT; NOTE: PROCEDURE 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=005; MPRINT(ENDTESTCALL): QUIT; NOTE: PROCEDURE 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\en/tst/005_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\en/tst/005_006.lst" is: Filename=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\en\tst\005_006.lst, RECFM=V,LRECL=256,File Size (bytes)=0, Last Modified=21. März 2014 11.39 Uhr, Create Time=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\en/tst/005_006.lst". NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ENDTESTCALL): ODS _ALL_ CLOSE; 70 %assertEquals(i_actual=&nobs, i_expected=, i_desc=number of observations with invalid dataset) 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=005; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 005 AND tst_casid = 6 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 005 , 6 ,1 ,"assertEquals" ,"number of observations with invalid dataset " ," " ," " ,0 ,"assertEquals: assert passed." ); NOTE: 1 row was inserted into TARGET.TST. MPRINT(_ASSERTS): QUIT; 24 The SAS System 11:39 Friday, March 21, 20 NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds ========================== Check 6.1 (assertEquals) ===================================== 71 %endTestcase() MPRINT(ENDTESTCASE): PROC SQL NOPRINT; MPRINT(ENDTESTCASE): SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=005; MPRINT(ENDTESTCASE): SELECT count(*) INTO :l_assertLog FROM target.tst WHERE tst_scnid = 005 AND tst_casid = 6 AND tst_type='assertLog'; NOTE: PROCEDURE 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 = 005; MPRINT(ASSERTLOG): QUIT; NOTE: PROCEDURE 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\en/log/005_006.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\en/log/005_006.log" is: Filename=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\en\log\005_006.log, RECFM=V,LRECL=256,File Size (bytes)=483, Last Modified=21. März 2014 11.39 Uhr, Create Time=21. März 2014 11.39 Uhr NOTE: 10 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\en/log/005_006.log". The minimum record length was 0. The maximum record length was 247. 25 The SAS System 11:39 Friday, March 21, 20 NOTE: DATA statement 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=005; MPRINT(_ASSERTS): SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 005 AND tst_casid = 6 ; MPRINT(_ASSERTS): INSERT INTO target.tst VALUES ( 005 , 6 ,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: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ========================== Check 6.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=005 AND tst_casid=6; MPRINT(ENDTESTCASE): QUIT; NOTE: PROCEDURE 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 = 005 AND cas_id = 6; NOTE: 1 row was updated in TARGET.CAS. MPRINT(ENDTESTCASE): QUIT; NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 72 73 /** \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: The SAS System used: real time 1.08 seconds cpu time 0.98 seconds