Fehler : 0
Warnungen: 0
NOTE: PROZEDUR PRINTTO used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 38 data blood_pressure; 39 set testdata.blood_pressure; 40 output; 41 sbp=.; 42 output; 43 run; NOTE: There were 240 observations read from the data set TESTDATA.BLOOD_PRESSURE. NOTE: The data set WORK.BLOOD_PRESSURE has 480 observations and 5 variables. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 44 %boxplot(data=blood_pressure, x=visit, y=sbp, group=med, report=&g_work\report3.pdf) MPRINT(BOXPLOT): proc sql noprint; 24 Das SAS System 11:39 Friday, March 21, 20 MPRINT(BOXPLOT): select distinct visit into :xvalues separated by '" "' from blood_pressure; MPRINT(BOXPLOT): select distinct visit into :xvalues2 separated by ' ' from blood_pressure; MPRINT(BOXPLOT): quit; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(BOXPLOT): proc sql noprint; MPRINT(BOXPLOT): select count(distinct med) into :count from blood_pressure; MPRINT(BOXPLOT): select min(med) into :lower from blood_pressure; MPRINT(BOXPLOT): quit; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(BOXPLOT): DATA; MPRINT(BOXPLOT): RUN; NOTE: The data set WORK.DATA7 has 1 observations and 0 variables. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(BOXPLOT): proc sql noprint; MPRINT(BOXPLOT): create table WORK.DATA7 as select distinct visit from blood_pressure; NOTE: Table WORK.DATA7 created, with 6 rows and 1 columns. MPRINT(BOXPLOT): quit; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(BOXPLOT): data WORK.DATA7; MPRINT(BOXPLOT): set WORK.DATA7; MPRINT(BOXPLOT): visit = visit - lag(visit); MPRINT(BOXPLOT): if _n_>1 then output; MPRINT(BOXPLOT): run; NOTE: Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 1 at 44:125 NOTE: There were 6 observations read from the data set WORK.DATA7. NOTE: The data set WORK.DATA7 has 5 observations and 1 variables. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(BOXPLOT): proc sql noprint; MPRINT(BOXPLOT): select mean(visit), min(visit) into :xdiff1, :xdiff2 from WORK.DATA7; 25 Das SAS System 11:39 Friday, March 21, 20 MPRINT(BOXPLOT): select min(visit), max(visit) into :xmin, :xmax from blood_pressure; MPRINT(BOXPLOT): select count(*) into :misscount from blood_pressure where visit is missing; MPRINT(BOXPLOT): quit; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(BOXPLOT): run; MPRINT(BOXPLOT): data; MPRINT(BOXPLOT): SET blood_pressure (KEEP=visit sbp med); MPRINT(BOXPLOT): IF med = 0 THEN DO; MPRINT(BOXPLOT): visit = visit - 0.11* 1; MPRINT(BOXPLOT): END; MPRINT(BOXPLOT): ELSE DO; MPRINT(BOXPLOT): visit = visit + 0.11* 1; MPRINT(BOXPLOT): END; MPRINT(BOXPLOT): RUN; NOTE: There were 480 observations read from the data set WORK.BLOOD_PRESSURE. NOTE: The data set WORK.DATA8 has 480 observations and 3 variables. NOTE: DATA-Anweisung used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(BOXPLOT): GOPTIONS FTEXT="Helvetica" HTEXT=12pt hsize=16cm vsize=16cm; MPRINT(BOXPLOT): SYMBOL1 WIDTH = 3 BWIDTH = 3 COLOR = gray LINE = 2 VALUE = none INTERPOL = BOXJT00 MODE = include; MPRINT(BOXPLOT): SYMBOL2 WIDTH = 3 BWIDTH = 3 COLOR = black LINE = 1 VALUE = none INTERPOL = BOXJT00 MODE = include; MPRINT(BOXPLOT): AXIS1 LABEL=(ANGLE=90) MINOR=none; MPRINT(BOXPLOT): AXIS2 ORDER=(-1 0 1 2 3 4 5 6) VALUE=(" " "0" "1" "2" "3" "4" "5" " ") MINOR=none; MPRINT(BOXPLOT): LEGEND1 FRAME; MPRINT(BOXPLOT): ODS PDF FILE="C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\report3.pdf"; NOTE: Writing ODS PDF output to DISK destination "C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\report3.pdf", printer "PDF". MPRINT(BOXPLOT): ODS LISTING CLOSE; MPRINT(BOXPLOT): PROC GPLOT DATA=WORK.DATA8; MPRINT(BOXPLOT): PLOT sbp * visit = med / VAXIS=Axis1 HAXIS=Axis2 LEGEND=Legend1 NOFRAME; MPRINT(BOXPLOT): RUN; NOTE: 240 observation(s) contained a MISSING value for the SBP * Visit = Med request. MPRINT(BOXPLOT): QUIT; NOTE: There were 480 observations read from the data set WORK.DATA8. NOTE: PROZEDUR GPLOT used (Total process time): real time 0.03 seconds cpu time 0.03 seconds MPRINT(BOXPLOT): ODS PDF CLOSE; NOTE: ODS PDF printed 1 page to C:\Users\REDMIN~1\AppData\Local\Temp\SAS Temporary Files\_TD2808_HD1PCMS0104_\report3.pdf. MPRINT(BOXPLOT): ODS LISTING; MPRINT(BOXPLOT): proc sql noprint; MPRINT(BOXPLOT): drop table WORK.DATA8; NOTE: Table WORK.DATA8 has been dropped. 26 Das SAS System 11:39 Friday, March 21, 20 MPRINT(BOXPLOT): drop table WORK.DATA7; NOTE: Table WORK.DATA7 has been dropped. MPRINT(BOXPLOT): quit; NOTE: PROZEDUR SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 45 %assertReport(i_actual=&g_work\report3.pdf, i_expected=&g_refdata\boxplot1.pdf, 46 i_desc=%str(please compare the two charts, no changes produced by missing values in the y variable)) MPRINT(ENDTESTCALL): PROC PRINTTO LOG="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/log/001.log" PRINT="c:\.jenkins\jobs\SASUnit Build Release ZIP-File\workspace\v1.3\example\doc\sasunit\de/tst/001.lst" ; MPRINT(ENDTESTCALL): RUN;