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.12 seconds
 
NOTE: The macro _SCENARIO completed compilation without errors.
      56 instructions 1692 bytes.
MPRINT(_SCENARIO):  =MAX;
NOTE: The macro _INITERRORHANDLER completed compilation without errors.
      24 instructions 444 bytes.
MPRINT(_SCENARIO):  ;
NOTE: The macro _HANDLEERROR completed compilation without errors.
      70 instructions 1712 bytes.
NOTE: The macro _EXISTDIR completed compilation without errors.
      40 instructions 824 bytes.
MPRINT(_SCENARIO):   LIBNAME target "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de";
NOTE: Libref TARGET was successfully assigned as follows:
      Engine:        V9
      Physical Name: c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de
NOTE: The macro _LOADENVIRONMENT completed compilation without errors.
      213 instructions 7032 bytes.
NOTE: The macro _NOBS completed compilation without errors.
      32 instructions 640 bytes.
MPRINT(_LOADENVIRONMENT):   DATA _null_;
MPRINT(_LOADENVIRONMENT):   SET target.tsu;
MPRINT(_LOADENVIRONMENT):   call symput ('g_project' , tsu_project);
MPRINT(_LOADENVIRONMENT):   call symput ('g_root' , tsu_root);
MPRINT(_LOADENVIRONMENT):   call symput ('g_sasunitroot' , tsu_sasunitroot);
MPRINT(_LOADENVIRONMENT):   call symput ('g_sasunit' , tsu_sasunit);
MPRINT(_LOADENVIRONMENT):   call symput ('g_sasunit_os' , tsu_sasunit_os);
MPRINT(_LOADENVIRONMENT):   call symput ('g_sasautos' , tsu_sasautos);
MPRINT(_LOADENVIRONMENT):   call symput ('g_sasautos0' , tsu_sasautos);
MPRINT(_LOADENVIRONMENT):   call symput ("g_sasautos1" , tsu_sasautos1);
MPRINT(_LOADENVIRONMENT):   call symput ("g_sasautos2" , tsu_sasautos2);
MPRINT(_LOADENVIRONMENT):   call symput ("g_sasautos3" , tsu_sasautos3);
MPRINT(_LOADENVIRONMENT):   call symput ("g_sasautos4" , tsu_sasautos4);
MPRINT(_LOADENVIRONMENT):   call symput ("g_sasautos5" , tsu_sasautos5);
MPRINT(_LOADENVIRONMENT):   call symput ("g_sasautos6" , tsu_sasautos6);
MPRINT(_LOADENVIRONMENT):   call symput ("g_sasautos7" , tsu_sasautos7);
MPRINT(_LOADENVIRONMENT):   call symput ("g_sasautos8" , tsu_sasautos8);
MPRINT(_LOADENVIRONMENT):   call symput ("g_sasautos9" , tsu_sasautos9);
MPRINT(_LOADENVIRONMENT):   call symput ('g_autoexec' , tsu_autoexec);
MPRINT(_LOADENVIRONMENT):   call symput ('g_sascfg' , tsu_sascfg);
MPRINT(_LOADENVIRONMENT):   call symput ('g_sasuser' , tsu_sasuser);
2                                                                                                                        Das SAS System                                                                                             11:39 Friday, March 21, 20
 
MPRINT(_LOADENVIRONMENT):   call symput ('g_testdata' , tsu_testdata);
MPRINT(_LOADENVIRONMENT):   call symput ('g_refdata' , tsu_refdata);
MPRINT(_LOADENVIRONMENT):   call symput ('g_doc' , tsu_doc);
MPRINT(_LOADENVIRONMENT):   call symput ('g_testcoverage', put (tsu_testcoverage, z1.));
MPRINT(_LOADENVIRONMENT):   call symput ('g_verbose' , put (tsu_verbose, z1.));
MPRINT(_LOADENVIRONMENT):   RUN;
 
NOTE: There were 1 observations read from the data set TARGET.TSU.
NOTE: DATA-Anweisung used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
NOTE: The macro _ABSPATH completed compilation without errors.
      54 instructions 1224 bytes.
NOTE: The macro _DETECTSYMBOLS completed compilation without errors.
      39 instructions 1268 bytes.
MPRINT(_DETECTSYMBOLS):   proc printto log=work.detect.note.log new;
MPRINT(_DETECTSYMBOLS):   run;
 
NOTE: PROZEDUR PRINTTO used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
MPRINT(_DETECTSYMBOLS):   filename _detect catalog "work.detect.note.log";
MPRINT(_DETECTSYMBOLS):   data _null_;
MPRINT(_DETECTSYMBOLS):   infile _detect truncover;
MPRINT(_DETECTSYMBOLS):   input line $char256.;
MPRINT(_DETECTSYMBOLS):   call symput ("g_note", scan(line, 1, ':'));
MPRINT(_DETECTSYMBOLS):   stop;
MPRINT(_DETECTSYMBOLS):   run;
 
NOTE: The infile _DETECT is:
      Catalog Name=WORK.DETECT.NOTE.LOG,
      Katalogseitengröße=4096,
      Anzahl der Katalogseiten=4,
      Erstellt=Freitag, 21. März 2014 11.39 Uhr,
      Zuletzt geändert=Freitag, 21. März 2014 11.39 Uhr,
      Dateiname=C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD3424_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\_TD3424_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 getvars.sas
6
7                      Example for a test scenario with the following features:
8                      - check value of macro symbol with assertEquals.sas
9                      - scan log with assertLog.sas
10                     - omit endTestcall.sas and endTestcase.sas
11                     - check for special cases
12
13         \version    \$Revision: 315 $
14         \author     \$Author: klandwich $
15         \date       \$Date: 2014-02-28 10:25:18 +0100 (Fr, 28 Feb 2014) $
16         \sa         For further information please refer to <A href="https://sourceforge.net/p/sasunit/wiki/User's%20Guide/" target="_blank">SASUnit User's Guide</A>
17         \sa         \$HeadURL: https://svn.code.sf.net/p/sasunit/code/trunk/example/saspgm/getvars_test.sas $
18         \copyright  Copyright 2010, 2012 HMS Analytical Software GmbH.
19                     This file is part of SASUnit, the Unit testing framework for SAS(R) programs.
20                     For terms of usage under the GPL license see included file readme.txt
21                     or https://sourceforge.net/p/sasunit/wiki/readme.v1.2/.
22         */ /** \cond */
23
24         /*-- simple example with sashelp.class ---------------------------------------*/
25         %initTestcase(i_object=getvars.sas, i_desc=simple example with sashelp.class)
NOTE: The macro INITTESTCASE completed compilation without errors.
      99 instructions 2784 bytes.
NOTE: The macro LOWCASE completed compilation without errors.
      29 instructions 504 bytes.
NOTE: The macro _GETAUTOCALLNUMBER completed compilation without errors.
      61 instructions 1180 bytes.
MPRINT(INITTESTCASE):   PROC SQL NOPRINT;
MPRINT(INITTESTCASE):   SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 004;
MPRINT(INITTESTCASE):   INSERT INTO target.cas VALUES ( 004 ,1 ,2 ,"getvars.sas" ,"simple example with sashelp.class" ,
5                                                                                                                        Das SAS System                                                                                             11:39 Friday, March 21, 20
 
MPRINT(INITTESTCASE):  "" ,1711021164.423 ,. ,. );
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/004_001.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release
ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/004_001.lst" ;
MPRINT(INITTESTCASE):   RUN;
 
NOTE: PROZEDUR PRINTTO used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
MPRINT(ENDTESTCALL):   PROC SQL NOPRINT;
MPRINT(ENDTESTCALL):   SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=004;
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.5 WHERE cas_scnid = 004 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;
6                                                                                                                        Das SAS System                                                                                             11:39 Friday, March 21, 20
 
MPRINT(ENDTESTCALL):   SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=004;
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/004_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/004_001.lst" is:
      Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\004_001.lst,
      RECFM=V,LRECL=256,Dateigröße (Byte)=0,
      Zuletzt geändert=21. März 2014 11.39 Uhr,
      Erstellungsuhrzeit=21. März 2014 11.39 Uhr
 
NOTE: 0 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/004_001.lst".
NOTE: DATA-Anweisung used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
NOTE: The macro _DELFILE completed compilation without errors.
      26 instructions 552 bytes.
MPRINT(ENDTESTCALL):   ODS _ALL_ CLOSE;
MPRINT(ASSERTEQUALS):  ;
NOTE: The macro _ASSERTS completed compilation without errors.
      152 instructions 4104 bytes.
NOTE(SASUNIT): assertEquals: assert passed.
MPRINT(_ASSERTS):   PROC SQL NOPRINT;
MPRINT(_ASSERTS):   SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=004;
MPRINT(_ASSERTS):   SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 004 AND tst_casid = 1 ;
MPRINT(_ASSERTS):   INSERT INTO target.tst VALUES ( 004 , 1 ,1 ,"assertEquals" ,"Variablen prüfen " ,"Name Sex Age Height Weight " ,"Name Sex Age Height Weight " ,0 ,"assertEquals: assert passed." );
NOTE: 1 row was inserted into TARGET.TST.
 
MPRINT(_ASSERTS):   QUIT;
NOTE: PROZEDUR SQL used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
========================== Check        1.1 (assertEquals) =====================================
29         /* %endTestcase() can be omitted, will called implicitly by the next initTestcase */
30
31         /*-- simple example with sashelp.class, different delimiter ------------------*/
32         %initTestcase(i_object=getvars.sas, i_desc=%str(simple example with sashelp.class, different delimiter))
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=004;
7                                                                                                                        Das SAS System                                                                                             11:39 Friday, March 21, 20
 
MPRINT(ENDTESTCASE):   SELECT count(*) INTO :l_assertLog FROM target.tst WHERE tst_scnid = 004 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.01 seconds
      cpu time            0.01 seconds
 
 
MPRINT(ASSERTLOG):   PROC SQL NOPRINT;
MPRINT(ASSERTLOG):   SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 004;
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/004_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/004_001.log" is:
      Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\log\004_001.log,
      RECFM=V,LRECL=256,Dateigröße (Byte)=969,
      Zuletzt geändert=21. März 2014 11.39 Uhr,
      Erstellungsuhrzeit=21. März 2014 11.39 Uhr
 
NOTE: 17 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/004_001.log".
      The minimum record length was 0.
      The maximum record length was 247.
NOTE: DATA-Anweisung used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
8                                                                                                                        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=004;
MPRINT(_ASSERTS):   SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 004 AND tst_casid = 1 ;
MPRINT(_ASSERTS):   INSERT INTO target.tst VALUES ( 004 , 1 ,2 ,"assertLog" ,"Scan log for errors " ,"0#0 " ,"0#0 " ,0 ,"assertLog: assert passed." );
NOTE: 1 row was inserted into TARGET.TST.
 
MPRINT(_ASSERTS):   QUIT;
NOTE: PROZEDUR SQL used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
========================== Check        1.2 (assertLog) =====================================
MPRINT(ENDTESTCASE):   QUIT;
MPRINT(ENDTESTCASE):   PROC SQL NOPRINT;
MPRINT(ENDTESTCASE):   SELECT max (tst_res) INTO :l_result FROM target.tst WHERE tst_scnid=004 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 = 004 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.01 seconds
      cpu time            0.01 seconds
 
 
MPRINT(INITTESTCASE):  ;
MPRINT(INITTESTCASE):   PROC SQL NOPRINT;
MPRINT(INITTESTCASE):   SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 004;
MPRINT(INITTESTCASE):   INSERT INTO target.cas VALUES ( 004 ,2 ,2 ,"getvars.sas" ,"simple example with sashelp.class, different delimiter" ,
MPRINT(INITTESTCASE):  "" ,1711021164.546 ,. ,. );
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/004_002.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release
ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/004_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=004;
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.562 WHERE cas_scnid = 004 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=004;
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/004_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/004_002.lst" is:
      Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\004_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/004_002.lst".
NOTE: DATA-Anweisung used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
10                                                                                                                       Das SAS System                                                                                             11:39 Friday, March 21, 20
 
 
 
MPRINT(ENDTESTCALL):   ODS _ALL_ CLOSE;
MPRINT(ASSERTEQUALS):  ;
NOTE(SASUNIT): assertEquals: assert passed.
MPRINT(_ASSERTS):   PROC SQL NOPRINT;
MPRINT(_ASSERTS):   SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=004;
MPRINT(_ASSERTS):   SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 004 AND tst_casid = 2 ;
MPRINT(_ASSERTS):   INSERT INTO target.tst VALUES ( 004 , 2 ,1 ,"assertEquals" ,"check variables " ,"Name,Sex,Age,Height,Weight " ,"Name,Sex,Age,Height,Weight " ,0 ,"assertEquals: assert passed." );
NOTE: 1 row was inserted into TARGET.TST.
 
MPRINT(_ASSERTS):   QUIT;
NOTE: PROZEDUR SQL used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
========================== Check        2.1 (assertEquals) =====================================
35
36         /*-- example with variable names containing special characters ---------------*/
37         %initTestcase(i_object=getvars.sas, i_desc=example with variable names containing special characters)
MPRINT(ENDTESTCASE):   PROC SQL NOPRINT;
MPRINT(ENDTESTCASE):   SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=004;
MPRINT(ENDTESTCASE):   SELECT count(*) INTO :l_assertLog FROM target.tst WHERE tst_scnid = 004 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 = 004;
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/004_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;
11                                                                                                                       Das SAS System                                                                                             11:39 Friday, March 21, 20
 
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/004_002.log" is:
      Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\log\004_002.log,
      RECFM=V,LRECL=256,Dateigröße (Byte)=852,
      Zuletzt geändert=21. März 2014 11.39 Uhr,
      Erstellungsuhrzeit=21. März 2014 11.39 Uhr
 
NOTE: 12 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/004_002.log".
      The minimum record length was 0.
      The maximum record length was 256.
      One or more lines were truncated.
NOTE: DATA-Anweisung used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
NOTE(SASUNIT): assertLog: assert passed.
MPRINT(_ASSERTS):   PROC SQL NOPRINT;
MPRINT(_ASSERTS):   SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=004;
MPRINT(_ASSERTS):   SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 004 AND tst_casid = 2 ;
MPRINT(_ASSERTS):   INSERT INTO target.tst VALUES ( 004 , 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.01 seconds
      cpu time            0.01 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=004 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 = 004 AND cas_id = 2;
NOTE: 1 row was updated in TARGET.CAS.
 
MPRINT(ENDTESTCASE):   QUIT;
NOTE: PROZEDUR SQL used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
MPRINT(INITTESTCASE):  ;
12                                                                                                                       Das SAS System                                                                                             11:39 Friday, March 21, 20
 
MPRINT(INITTESTCASE):   PROC SQL NOPRINT;
MPRINT(INITTESTCASE):   SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 004;
MPRINT(INITTESTCASE):   INSERT INTO target.cas VALUES ( 004 ,3 ,2 ,"getvars.sas" ,"example with variable names containing special characters" ,
MPRINT(INITTESTCASE):  "" ,1711021164.593 ,. ,. );
NOTE: 1 row was inserted into TARGET.CAS.
 
MPRINT(INITTESTCASE):   QUIT;
NOTE: PROZEDUR SQL used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
========================== test case 3 ======================================================
MPRINT(INITTESTCASE):   PROC PRINTTO NEW LOG="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/004_003.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release
ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/004_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=004;
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.624 WHERE cas_scnid = 004 AND cas_id = 3;
13                                                                                                                       Das SAS System                                                                                             11:39 Friday, March 21, 20
 
NOTE: 1 row was updated in TARGET.CAS.
 
MPRINT(ENDTESTCALL):   QUIT;
NOTE: PROZEDUR SQL used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
MPRINT(ENDTESTCALL):   PROC SQL NOPRINT;
MPRINT(ENDTESTCALL):   SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=004;
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/004_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/004_003.lst" is:
      Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\004_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/004_003.lst".
NOTE: DATA-Anweisung used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
MPRINT(ENDTESTCALL):   ODS _ALL_ CLOSE;
MPRINT(ASSERTEQUALS):  ;
NOTE: Line generated by the macro variable "I_EXPECTED".
45         ""a b c","$6789",";6789"
           ___
           49
NOTE: Line generated by the macro variable "I_ACTUAL".
45          ""a b c","$6789",";6789"
            __
            49
NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release.  Inserting white space between a quoted string and the succeeding identifier is recommended.
 
NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release.  Inserting white space between a quoted string and the succeeding identifier is recommended.
NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release.  Inserting white space between a quoted string and the succeeding identifier is recommended.
NOTE(SASUNIT): assertEquals: assert passed.
MPRINT(_ASSERTS):   PROC SQL NOPRINT;
MPRINT(_ASSERTS):   SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=004;
MPRINT(_ASSERTS):   SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 004 AND tst_casid = 3 ;
MPRINT(_ASSERTS):   INSERT INTO target.tst VALUES ( 004 , 3 ,1 ,"assertEquals" ,"check variables " ,"""a b c"",""$6789"","";6789"" " ,"""a b c"",""$6789"","";6789"" " ,0 ,"assertEquals: assert passed." );
14                                                                                                                       Das SAS System                                                                                             11:39 Friday, March 21, 20
 
NOTE: 1 row was inserted into TARGET.TST.
 
MPRINT(_ASSERTS):   QUIT;
NOTE: PROZEDUR SQL used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
========================== Check        3.1 (assertEquals) =====================================
46         %macro al;
47         %if &sysver=9.1 %then %do;
48            %assertLog(i_warnings=1,i_desc=%str(check log, one warning due to validvarname))
49            %endTestcase(i_assertLog=0) /* no assertLog */
50         %end;
51         %mend al;
NOTE: The macro AL completed compilation without errors.
      11 instructions 272 bytes.
52         %al;
53
54         /*-- example with empty dataset ----------------------------------------------*/
55         %initTestcase(i_object=getvars.sas, i_desc=example with empty dataset)
MPRINT(ENDTESTCASE):   PROC SQL NOPRINT;
MPRINT(ENDTESTCASE):   SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=004;
MPRINT(ENDTESTCASE):   SELECT count(*) INTO :l_assertLog FROM target.tst WHERE tst_scnid = 004 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 = 004;
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/004_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;
15                                                                                                                       Das SAS System                                                                                             11:39 Friday, March 21, 20
 
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/004_003.log" is:
      Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\log\004_003.log,
      RECFM=V,LRECL=256,Dateigröße (Byte)=949,
      Zuletzt geändert=21. März 2014 11.39 Uhr,
      Erstellungsuhrzeit=21. März 2014 11.39 Uhr
 
NOTE: 23 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/004_003.log".
      The minimum record length was 0.
      The maximum record length was 247.
NOTE: DATA-Anweisung used (Total process time):
      real time           0.06 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=004;
MPRINT(_ASSERTS):   SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 004 AND tst_casid = 3 ;
MPRINT(_ASSERTS):   INSERT INTO target.tst VALUES ( 004 , 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=004 AND tst_casid=3;
MPRINT(ENDTESTCASE):   QUIT;
NOTE: PROZEDUR SQL used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
 
 
MPRINT(ENDTESTCASE):   PROC SQL NOPRINT;
MPRINT(ENDTESTCASE):   UPDATE target.cas SET cas_res = 0 WHERE cas_scnid = 004 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
 
 
MPRINT(INITTESTCASE):  ;
MPRINT(INITTESTCASE):   PROC SQL NOPRINT;
16                                                                                                                       Das SAS System                                                                                             11:39 Friday, March 21, 20
 
MPRINT(INITTESTCASE):   SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 004;
MPRINT(INITTESTCASE):   INSERT INTO target.cas VALUES ( 004 ,4 ,2 ,"getvars.sas" ,"example with empty dataset" ,
MPRINT(INITTESTCASE):  "" ,1711021164.716 ,. ,. );
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/004_004.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release
ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/004_004.lst" ;
MPRINT(INITTESTCASE):   RUN;
 
NOTE: PROZEDUR PRINTTO used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
MPRINT(ENDTESTCALL):   PROC SQL NOPRINT;
MPRINT(ENDTESTCALL):   SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=004;
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.732 WHERE cas_scnid = 004 AND cas_id = 4;
NOTE: 1 row was updated in TARGET.CAS.
 
MPRINT(ENDTESTCALL):   QUIT;
NOTE: PROZEDUR SQL used (Total process time):
17                                                                                                                       Das SAS System                                                                                             11:39 Friday, March 21, 20
 
      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=004;
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/004_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/004_004.lst" is:
      Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\004_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/004_004.lst".
NOTE: DATA-Anweisung used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
MPRINT(ENDTESTCALL):   ODS _ALL_ CLOSE;
MPRINT(ASSERTEQUALS):  ;
NOTE(SASUNIT): assertEquals: assert passed.
MPRINT(_ASSERTS):   PROC SQL NOPRINT;
MPRINT(_ASSERTS):   SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=004;
MPRINT(_ASSERTS):   SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 004 AND tst_casid = 4 ;
MPRINT(_ASSERTS):   INSERT INTO target.tst VALUES ( 004 , 4 ,1 ,"assertEquals" ,"no variables found " ," " ," " ,0 ,"assertEquals: assert passed." );
NOTE: 1 row was inserted into TARGET.TST.
 
MPRINT(_ASSERTS):   QUIT;
NOTE: PROZEDUR SQL used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
========================== Check        4.1 (assertEquals) =====================================
61
62         /*-- example without dataset specified ---------------------------------------*/
63         %initTestcase(i_object=getvars.sas, i_desc=example without dataset specified)
MPRINT(ENDTESTCASE):   PROC SQL NOPRINT;
MPRINT(ENDTESTCASE):   SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=004;
MPRINT(ENDTESTCASE):   SELECT count(*) INTO :l_assertLog FROM target.tst WHERE tst_scnid = 004 AND tst_casid = 4 AND tst_type='assertLog';
NOTE: PROZEDUR SQL used (Total process time):
18                                                                                                                       Das SAS System                                                                                             11:39 Friday, March 21, 20
 
      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 = 004;
MPRINT(ASSERTLOG):   QUIT;
NOTE: PROZEDUR SQL used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
 
 
MPRINT(_CHECKLOG):   DATA _null_;
MPRINT(_CHECKLOG):   INFILE "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/004_004.log" TRUNCOVER end=eof;
MPRINT(_CHECKLOG):   INPUT logline $char255.;
MPRINT(_CHECKLOG):   ATTRIB _errorPatternId LENGTH = 8 _ignoreErrPatternId LENGTH = 8 _warningPatternId LENGTH = 8 _errcount LENGTH = 8 _warncount LENGTH = 8 ;
MPRINT(_CHECKLOG):   RETAIN _errorPatternId 0 _ignoreErrPatternId 0 _warningPatternId 0 _errcount 0 _warncount 0 ;
MPRINT(_CHECKLOG):   IF _n_=1 THEN DO;
MPRINT(_CHECKLOG):   _errorPatternId = prxparse("/^ERROR[: ]/");
MPRINT(_CHECKLOG):   _warningPatternId = prxparse("/^WARNING[: ]/");
MPRINT(_CHECKLOG):   _ignoreErrPatternId = prxparse("/^ERROR: Errors printed on page/");
MPRINT(_CHECKLOG):   END;
MPRINT(_CHECKLOG):   IF prxmatch (_errorPatternId, logline) AND (NOT prxmatch (_ignoreErrPatternId, logline)) THEN DO;
MPRINT(_CHECKLOG):   _errcount = _errcount+1;
MPRINT(_CHECKLOG):   END;
MPRINT(_CHECKLOG):   ELSE IF prxmatch (_warningPatternId, logline) THEN DO;
MPRINT(_CHECKLOG):   _warncount = _warncount+1;
MPRINT(_CHECKLOG):   END;
MPRINT(_CHECKLOG):   IF eof THEN DO;
MPRINT(_CHECKLOG):   CALL symputx ("l_error_count" , put(_errcount,8.));
MPRINT(_CHECKLOG):   CALL symputx ("l_warning_count", put(_warncount,8.));
MPRINT(_CHECKLOG):   END;
MPRINT(_CHECKLOG):   RUN;
 
NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/004_004.log" is:
      Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\log\004_004.log,
      RECFM=V,LRECL=256,Dateigröße (Byte)=809,
      Zuletzt geändert=21. März 2014 11.39 Uhr,
      Erstellungsuhrzeit=21. März 2014 11.39 Uhr
 
NOTE: 20 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/004_004.log".
      The minimum record length was 0.
      The maximum record length was 247.
NOTE: DATA-Anweisung used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
NOTE(SASUNIT): assertLog: assert passed.
MPRINT(_ASSERTS):   PROC SQL NOPRINT;
MPRINT(_ASSERTS):   SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=004;
MPRINT(_ASSERTS):   SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 004 AND tst_casid = 4 ;
MPRINT(_ASSERTS):   INSERT INTO target.tst VALUES ( 004 , 4 ,2 ,"assertLog" ,"Scan log for errors " ,"0#0 " ,"0#0 " ,0 ,"assertLog: assert passed." );
NOTE: 1 row was inserted into TARGET.TST.
19                                                                                                                       Das SAS System                                                                                             11:39 Friday, March 21, 20
 
 
MPRINT(_ASSERTS):   QUIT;
NOTE: PROZEDUR SQL used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
========================== Check        4.2 (assertLog) =====================================
MPRINT(ENDTESTCASE):   QUIT;
MPRINT(ENDTESTCASE):   PROC SQL NOPRINT;
MPRINT(ENDTESTCASE):   SELECT max (tst_res) INTO :l_result FROM target.tst WHERE tst_scnid=004 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 = 004 AND cas_id = 4;
NOTE: 1 row was updated in TARGET.CAS.
 
MPRINT(ENDTESTCASE):   QUIT;
NOTE: PROZEDUR SQL used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
MPRINT(INITTESTCASE):  ;
MPRINT(INITTESTCASE):   PROC SQL NOPRINT;
MPRINT(INITTESTCASE):   SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 004;
MPRINT(INITTESTCASE):   INSERT INTO target.cas VALUES ( 004 ,5 ,2 ,"getvars.sas" ,"example without dataset specified" ,
MPRINT(INITTESTCASE):  "" ,1711021164.763 ,. ,. );
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 5 ======================================================
MPRINT(INITTESTCASE):   PROC PRINTTO NEW LOG="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/004_005.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release
ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/004_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=004;
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.794 WHERE cas_scnid = 004 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=004;
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/004_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/004_005.lst" is:
      Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\004_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/004_005.lst".
NOTE: DATA-Anweisung used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
MPRINT(ENDTESTCALL):   ODS _ALL_ CLOSE;
MPRINT(ASSERTEQUALS):  ;
NOTE(SASUNIT): assertEquals: assert passed.
MPRINT(_ASSERTS):   PROC SQL NOPRINT;
21                                                                                                                       Das SAS System                                                                                             11:39 Friday, March 21, 20
 
MPRINT(_ASSERTS):   SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=004;
MPRINT(_ASSERTS):   SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 004 AND tst_casid = 5 ;
MPRINT(_ASSERTS):   INSERT INTO target.tst VALUES ( 004 , 5 ,1 ,"assertEquals" ,"no variables found " ," " ," " ,0 ,"assertEquals: assert passed." );
NOTE: 1 row was inserted into TARGET.TST.
 
MPRINT(_ASSERTS):   QUIT;
NOTE: PROZEDUR SQL used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
========================== Check        5.1 (assertEquals) =====================================
66
67         /*-- example with invalid dataset --------------------------------------------*/
68         %initTestcase(i_object=getvars.sas, i_desc=example with invalid dataset)
MPRINT(ENDTESTCASE):   PROC SQL NOPRINT;
MPRINT(ENDTESTCASE):   SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=004;
MPRINT(ENDTESTCASE):   SELECT count(*) INTO :l_assertLog FROM target.tst WHERE tst_scnid = 004 AND tst_casid = 5 AND tst_type='assertLog';
NOTE: PROZEDUR SQL used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
MPRINT(ASSERTLOG):   PROC SQL NOPRINT;
MPRINT(ASSERTLOG):   SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 004;
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/004_005.log" TRUNCOVER end=eof;
MPRINT(_CHECKLOG):   INPUT logline $char255.;
MPRINT(_CHECKLOG):   ATTRIB _errorPatternId LENGTH = 8 _ignoreErrPatternId LENGTH = 8 _warningPatternId LENGTH = 8 _errcount LENGTH = 8 _warncount LENGTH = 8 ;
MPRINT(_CHECKLOG):   RETAIN _errorPatternId 0 _ignoreErrPatternId 0 _warningPatternId 0 _errcount 0 _warncount 0 ;
MPRINT(_CHECKLOG):   IF _n_=1 THEN DO;
MPRINT(_CHECKLOG):   _errorPatternId = prxparse("/^ERROR[: ]/");
MPRINT(_CHECKLOG):   _warningPatternId = prxparse("/^WARNING[: ]/");
MPRINT(_CHECKLOG):   _ignoreErrPatternId = prxparse("/^ERROR: Errors printed on page/");
MPRINT(_CHECKLOG):   END;
MPRINT(_CHECKLOG):   IF prxmatch (_errorPatternId, logline) AND (NOT prxmatch (_ignoreErrPatternId, logline)) THEN DO;
MPRINT(_CHECKLOG):   _errcount = _errcount+1;
MPRINT(_CHECKLOG):   END;
MPRINT(_CHECKLOG):   ELSE IF prxmatch (_warningPatternId, logline) THEN DO;
MPRINT(_CHECKLOG):   _warncount = _warncount+1;
MPRINT(_CHECKLOG):   END;
MPRINT(_CHECKLOG):   IF eof THEN DO;
MPRINT(_CHECKLOG):   CALL symputx ("l_error_count" , put(_errcount,8.));
MPRINT(_CHECKLOG):   CALL symputx ("l_warning_count", put(_warncount,8.));
MPRINT(_CHECKLOG):   END;
MPRINT(_CHECKLOG):   RUN;
 
NOTE: The infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/004_005.log" is:
22                                                                                                                       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\004_005.log,
      RECFM=V,LRECL=256,Dateigröße (Byte)=798,
      Zuletzt geändert=21. März 2014 11.39 Uhr,
      Erstellungsuhrzeit=21. März 2014 11.39 Uhr
 
NOTE: 12 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/004_005.log".
      The minimum record length was 0.
      The maximum record length was 256.
      One or more lines were truncated.
NOTE: DATA-Anweisung used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
NOTE(SASUNIT): assertLog: assert passed.
MPRINT(_ASSERTS):   PROC SQL NOPRINT;
MPRINT(_ASSERTS):   SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=004;
MPRINT(_ASSERTS):   SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 004 AND tst_casid = 5 ;
MPRINT(_ASSERTS):   INSERT INTO target.tst VALUES ( 004 , 5 ,2 ,"assertLog" ,"Scan log for errors " ,"0#0 " ,"0#0 " ,0 ,"assertLog: assert passed." );
NOTE: 1 row was inserted into TARGET.TST.
 
MPRINT(_ASSERTS):   QUIT;
NOTE: PROZEDUR SQL used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
========================== Check        5.2 (assertLog) =====================================
MPRINT(ENDTESTCASE):   QUIT;
MPRINT(ENDTESTCASE):   PROC SQL NOPRINT;
MPRINT(ENDTESTCASE):   SELECT max (tst_res) INTO :l_result FROM target.tst WHERE tst_scnid=004 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 = 004 AND cas_id = 5;
NOTE: 1 row was updated in TARGET.CAS.
 
MPRINT(ENDTESTCASE):   QUIT;
NOTE: PROZEDUR SQL used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
MPRINT(INITTESTCASE):  ;
MPRINT(INITTESTCASE):   PROC SQL NOPRINT;
MPRINT(INITTESTCASE):   SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid = 004;
MPRINT(INITTESTCASE):   INSERT INTO target.cas VALUES ( 004 ,6 ,2 ,"getvars.sas" ,"example with invalid dataset" ,
MPRINT(INITTESTCASE):  "" ,1711021164.871 ,. ,. );
NOTE: 1 row was inserted into TARGET.CAS.
 
23                                                                                                                       Das SAS System                                                                                             11:39 Friday, March 21, 20
 
MPRINT(INITTESTCASE):   QUIT;
NOTE: PROZEDUR SQL used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
 
 
========================== test case 6 ======================================================
MPRINT(INITTESTCASE):   PROC PRINTTO NEW LOG="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/004_006.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release
ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/004_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=004;
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.902 WHERE cas_scnid = 004 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=004;
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/004_006.lst";
MPRINT(ENDTESTCALL):   INPUT;
24                                                                                                                       Das SAS System                                                                                             11:39 Friday, March 21, 20
 
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/004_006.lst" is:
      Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\tst\004_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/004_006.lst".
NOTE: DATA-Anweisung used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
MPRINT(ENDTESTCALL):   ODS _ALL_ CLOSE;
MPRINT(ASSERTEQUALS):  ;
NOTE(SASUNIT): assertEquals: assert passed.
MPRINT(_ASSERTS):   PROC SQL NOPRINT;
MPRINT(_ASSERTS):   SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=004;
MPRINT(_ASSERTS):   SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 004 AND tst_casid = 6 ;
MPRINT(_ASSERTS):   INSERT INTO target.tst VALUES ( 004 , 6 ,1 ,"assertEquals" ,"example with invalid dataset " ," " ," " ,0 ,"assertEquals: assert passed." );
NOTE: 1 row was inserted into TARGET.TST.
 
MPRINT(_ASSERTS):   QUIT;
NOTE: PROZEDUR SQL used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
 
 
========================== Check        6.1 (assertEquals) =====================================
71         /** \endcond */
 
NOTE: The macro _TERMSCENARIO completed compilation without errors.
      26 instructions 520 bytes.
MPRINT(ENDTESTCASE):   PROC SQL NOPRINT;
MPRINT(ENDTESTCASE):   SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=004;
MPRINT(ENDTESTCASE):   SELECT count(*) INTO :l_assertLog FROM target.tst WHERE tst_scnid = 004 AND tst_casid = 6 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 = 004;
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/004_006.log" TRUNCOVER end=eof;
25                                                                                                                       Das SAS System                                                                                             11:39 Friday, March 21, 20
 
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/004_006.log" is:
      Dateiname=c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de\log\004_006.log,
      RECFM=V,LRECL=256,Dateigröße (Byte)=550,
      Zuletzt geändert=21. März 2014 11.39 Uhr,
      Erstellungsuhrzeit=21. März 2014 11.39 Uhr
 
NOTE: 10 records were read from the infile "c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/004_006.log".
      The minimum record length was 0.
      The maximum record length was 247.
NOTE: DATA-Anweisung used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
NOTE(SASUNIT): assertLog: assert passed.
MPRINT(_ASSERTS):   PROC SQL NOPRINT;
MPRINT(_ASSERTS):   SELECT max(cas_id) INTO :l_casid FROM target.cas WHERE cas_scnid=004;
MPRINT(_ASSERTS):   SELECT max(tst_id) INTO :l_tstid FROM target.tst WHERE tst_scnid = 004 AND tst_casid = 6 ;
MPRINT(_ASSERTS):   INSERT INTO target.tst VALUES ( 004 , 6 ,2 ,"assertLog" ,"Scan log for errors " ,"0#0 " ,"0#0 " ,0 ,"assertLog: assert passed." );
NOTE: 1 row was inserted into TARGET.TST.
 
MPRINT(_ASSERTS):   QUIT;
NOTE: PROZEDUR SQL used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
 
 
========================== Check        6.2 (assertLog) =====================================
MPRINT(ENDTESTCASE):   QUIT;
MPRINT(ENDTESTCASE):   PROC SQL NOPRINT;
MPRINT(ENDTESTCASE):   SELECT max (tst_res) INTO :l_result FROM target.tst WHERE tst_scnid=004 AND tst_casid=6;
MPRINT(ENDTESTCASE):   QUIT;
NOTE: PROZEDUR SQL used (Total process time):
      real time           0.00 seconds
26                                                                                                                       Das SAS System                                                                                             11:39 Friday, March 21, 20
 
      cpu time            0.00 seconds
 
 
MPRINT(ENDTESTCASE):   PROC SQL NOPRINT;
MPRINT(ENDTESTCASE):   UPDATE target.cas SET cas_res = 0 WHERE cas_scnid = 004 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.00 seconds
      cpu time            0.00 seconds
 
 
MPRINT(_TERMSCENARIO):  ;
 
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: Das SAS System used:
      real time           0.71 seconds
      cpu time            0.59 seconds