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