any input? Im still stuck on this. would like to stress that the code have not been changed in any way since it was working; it just suddenly doesn't work. I've resently switched to running on SAS sever instead of locally. ... View more

Running my code gives me this: The SAS System 18:09 Friday, September 6, 2019 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Program (6)'; 4 %LET _CLIENTPROCESSFLOWNAME='Process Flow'; 5 %LET _CLIENTPROJECTPATH='/sasfolders/user/mkri0225/sasuser.v94/Nekrotiserende Fascitis Kohorte.egp'; 6 %LET _CLIENTPROJECTPATHHOST='psasgridnode05.regionh.top.local'; 7 %LET _CLIENTPROJECTNAME='Nekrotiserende Fascitis Kohorte.egp'; 8 %LET _SASPROGRAMFILE=''; 9 %LET _SASPROGRAMFILEHOST=''; 10 11 ODS _ALL_ CLOSE; 12 OPTIONS DEV=PNG; 13 FILENAME EGSR TEMP; 14 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR 15 STYLE=Journal1a 16 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/Journal1a.css") 17 NOGTITLE 18 NOGFOOTNOTE 19 GPATH=&sasworklocation 20 ENCODING=UTF8 21 options(rolap="on") 22 ; NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 23 24 25 26 options mprint; 27 28 data q; 29 set nf.kohorte2; 30 keep Group strep_a_only C3 C3bc c3c_baseline C4 C4cneo tcc c4c_c4_ratio masp1 masp2 masp3 Albumin_g_pr_l ; 31 run; NOTE: There were 135 observations read from the data set NF.KOHORTE2. NOTE: The data set WORK.Q has 135 observations and 13 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 32 33 34 %summtable( 35 data= q, 36 class=strep_a_only, 37 con1=, con2=, 38 con3= C3 C3bc c3c_baseline C4 C4cneo tcc c4c_c4_ratio masp1 masp2 masp3 Albumin_g_pr_l , 39 cat1= , 40 cat2= , ord1= , 41 subset= , colpct=1, pvalues=1, cutexact=50, totalcol=1, ncol=0, 42 misscol=0, adhoc=0, oddsratios=0, unitscon1=, unitscon2=, unitscon3=, sortby= _list , list= masp1 masp2 masp3 C4 42 ! C4cneo c4c_c4_ratio C3 C3bc tcc , out=amp, rtfout=amp, rtffile= "/sasfolders/user/mkri0225/strepaonly.rtf", 43 xmlfile=, pdffile=, odsmemo=0, desclabel=0, printptype=0, sdopt=1, tbltitle=, bdytitle=0, style=Styles.Custom, 43 ! page=portrait, printfn=1, 44 addfn=, daytime=0, f1=__Countf., f2=__Estf., f3=__Pctf., f4=__Estf., pfmt=Pvaluef., lablen=$40, perfmt=5.1, cwidth1=50, 44 ! cwidth2=125, 45 cwidth3=, printp=0, prints=2 ); MPRINT(SUMMTABLE): *********************************************************************; 2 The SAS System 18:09 Friday, September 6, 2019 MPRINT(SUMMTABLE): *********************************************************************; MPRINT(SUMMTABLE): ***************** Local macro variables **********************; MPRINT(SUMMTABLE): *********************************************************************; MPRINT(SUMMTABLE): *********************************************************************; MPRINT(SUMMTABLE): *********************************************************************; MPRINT(SUMMTABLE): *********************************************************************; MPRINT(SUMMTABLE): ***************** System options **********************; MPRINT(SUMMTABLE): *********************************************************************; MPRINT(SUMMTABLE): *********************************************************************; MPRINT(SUMMTABLE): options validvarname=v7 nodate noquotelenmax nonumber; MPRINT(SUMMTABLE): *********************************************************************; MPRINT(SUMMTABLE): *********************************************************************; MPRINT(SUMMTABLE): ***************** Include default formats **********************; MPRINT(SUMMTABLE): *********************************************************************; MPRINT(SUMMTABLE): *********************************************************************; MPRINT(SUMMTABLE): proc format; MPRINT(SUMMTABLE): picture Pvaluef (round) 0.985 - high = "0.99" (NoEdit) 0.10 -< 0.985 = "9.99" 0.001 -< 0.10 = "9.999" 0 -< 0.001 = "<0.001" (NoEdit) . = " "; NOTE: Format PVALUEF has been output. MPRINT(SUMMTABLE): picture __Estf (round) low - -1.1 = "00000000000009.9" (prefix='-') -1.1 <-< 0 = "9.99" (prefix='-') 0 -< 1.1 = "9.99" 1.1 - high = "00000000000009.9"; NOTE: Format __ESTF has been output. MPRINT(SUMMTABLE): picture __Countf (round) low-high = "0000000000000009" . = " "; NOTE: Format __COUNTF has been output. MPRINT(SUMMTABLE): picture __Pctf (round) low - 0 = "9.9" 0 <-< 1 = "9.99" 1 - high = "00000000000009.9"; NOTE: Format __PCTF has been output. MPRINT(SUMMTABLE): *********************************************************************; MPRINT(SUMMTABLE): *********************************************************************; MPRINT(SUMMTABLE): ************ If ODSMEMO = 1 then make sure nothing prints ***********; MPRINT(SUMMTABLE): ************ Also make sure no ods destination is called ***********; MPRINT(SUMMTABLE): *********************************************************************; MPRINT(SUMMTABLE): *********************************************************************; MPRINT(SUMMTABLE): *********************************************************************; MPRINT(SUMMTABLE): ***************** Check errors in call **********************; MPRINT(SUMMTABLE): *********************************************************************; MPRINT(SUMMTABLE): *********************************************************************; MPRINT(SUMMTABLE): ***** Check if data set specified in call *****; MPRINT(SUMMTABLE): ***** Check if data set exists *****; MPRINT(SUMMTABLE): ***** Continue Checks if data exists *****; MPRINT(SUMMTABLE): ***** Create working data set, subset if requiered *****; NOTE: PROCEDURE FORMAT used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MPRINT(SUMMTABLE): data _tempd_; MPRINT(SUMMTABLE): set q; MPRINT(SUMMTABLE): *** Subset if requested ***; MPRINT(SUMMTABLE): *** We dont want the name of the class variable to cause problems in ODS data sets. ; MPRINT(SUMMTABLE): if strep_a_only=. then put "WARNING: Observations deleted due to missing strep_a_only variable."; MPRINT(SUMMTABLE): if strep_a_only=. then delete; MPRINT(SUMMTABLE): rename strep_a_only = ___class; MPRINT(SUMMTABLE): run; WARNING: Observations deleted due to missing strep_a_only variable. WARNING: Observations deleted due to missing strep_a_only variable. WARNING: Observations deleted due to missing strep_a_only variable. The SAS System WARNING: Observations deleted due to missing strep_a_only variable. WARNING: Observations deleted due to missing strep_a_only variable. WARNING: Observations deleted due to missing strep_a_only variable. WARNING: Observations deleted due to missing strep_a_only variable. WARNING: Observations deleted due to missing strep_a_only variable. WARNING: Observations deleted due to missing strep_a_only variable. WARNING: Observations deleted due to missing strep_a_only variable. WARNING: Observations deleted due to missing strep_a_only variable. WARNING: Observations deleted due to missing strep_a_only variable. WARNING: Observations deleted due to missing strep_a_only variable. WARNING: Observations deleted due to missing strep_a_only variable. WARNING: Observations deleted due to missing strep_a_only variable. WARNING: Observations deleted due to missing strep_a_only variable. WARNING: Observations deleted due to missing strep_a_only variable. WARNING: Observations deleted due to missing strep_a_only variable. WARNING: Observations deleted due to missing strep_a_only variable. WARNING: Observations deleted due to missing strep_a_only variable. WARNING: Observations deleted due to missing strep_a_only variable. WARNING: Observations deleted due to missing strep_a_only variable. WARNING: Observations deleted due to missing strep_a_only variable. WARNING: Observations deleted due to missing strep_a_only variable. WARNING: Observations deleted due to missing strep_a_only variable. WARNING: Observations deleted due to missing strep_a_only variable. WARNING: Observations deleted due to missing strep_a_only variable. WARNING: Observations deleted due to missing strep_a_only variable. WARNING: Observations deleted due to missing strep_a_only variable. WARNING: Observations deleted due to missing strep_a_only variable. WARNING: Observations deleted due to missing strep_a_only variable. WARNING: Observations deleted due to missing strep_a_only variable. WARNING: Observations deleted due to missing strep_a_only variable. NOTE: There were 135 observations read from the data set WORK.Q. NOTE: The data set WORK._TEMPD_ has 102 observations and 13 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MPRINT(SUMMTABLE): ***** (R.L) Check all specified variables are in data set. If not, drop from analysis *****; MPRINT(SUMMTABLE): ; MPRINT(SUMMTABLE): ; MPRINT(SUMMTABLE): ; MPRINT(SUMMTABLE): ; MPRINT(VEXIST): proc sql noprint; MPRINT(VEXIST): select left(put(count(*),8.)) into :exist from dictionary.columns where libname="WORK" and memname="_TEMPD_" and upcase(name)="C3"; MPRINT(VEXIST): quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(VEXIST): proc sql noprint; MPRINT(VEXIST): select left(put(count(*),8.)) into :exist from dictionary.columns where libname="WORK" and memname="_TEMPD_" and upcase(name)="C3BC"; MPRINT(VEXIST): quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds The SAS System MPRINT(VEXIST): proc sql noprint; MPRINT(VEXIST): select left(put(count(*),8.)) into :exist from dictionary.columns where libname="WORK" and memname="_TEMPD_" and upcase(name)="C3C_BASELINE"; MPRINT(VEXIST): quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(VEXIST): proc sql noprint; MPRINT(VEXIST): select left(put(count(*),8.)) into :exist from dictionary.columns where libname="WORK" and memname="_TEMPD_" and upcase(name)="C4"; MPRINT(VEXIST): quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MPRINT(VEXIST): proc sql noprint; MPRINT(VEXIST): select left(put(count(*),8.)) into :exist from dictionary.columns where libname="WORK" and memname="_TEMPD_" and upcase(name)="C4CNEO"; MPRINT(VEXIST): quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(VEXIST): proc sql noprint; MPRINT(VEXIST): select left(put(count(*),8.)) into :exist from dictionary.columns where libname="WORK" and memname="_TEMPD_" and upcase(name)="TCC"; MPRINT(VEXIST): quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(VEXIST): proc sql noprint; MPRINT(VEXIST): select left(put(count(*),8.)) into :exist from dictionary.columns where libname="WORK" and memname="_TEMPD_" and upcase(name)="C4C_C4_RATIO"; MPRINT(VEXIST): quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(VEXIST): proc sql noprint; MPRINT(VEXIST): select left(put(count(*),8.)) into :exist from dictionary.columns where libname="WORK" and memname="_TEMPD_" and upcase(name)="MASP1"; MPRINT(VEXIST): quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(VEXIST): proc sql noprint; MPRINT(VEXIST): select left(put(count(*),8.)) into :exist from dictionary.columns where libname="WORK" and memname="_TEMPD_" and The SAS System upcase(name)="MASP2"; MPRINT(VEXIST): quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(VEXIST): proc sql noprint; MPRINT(VEXIST): select left(put(count(*),8.)) into :exist from dictionary.columns where libname="WORK" and memname="_TEMPD_" and upcase(name)="MASP3"; MPRINT(VEXIST): quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(VEXIST): proc sql noprint; MPRINT(VEXIST): select left(put(count(*),8.)) into :exist from dictionary.columns where libname="WORK" and memname="_TEMPD_" and upcase(name)="ALBUMIN_G_PR_L"; MPRINT(VEXIST): quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MPRINT(SUMMTABLE): ; MPRINT(SUMMTABLE): ; MPRINT(SUMMTABLE): ***** ELIMINATE VARIABLES WITH COMPLETE MISSINGNESS *****; MPRINT(NEWLIST): proc means noprint data=_tempd_ n; MPRINT(NEWLIST): where missing(___class)=0; MPRINT(NEWLIST): ; MPRINT(NEWLIST): var C3 C3BC C3C_BASELINE C4 C4CNEO TCC C4C_C4_RATIO MASP1 MASP2 MASP3 ALBUMIN_G_PR_L; MPRINT(NEWLIST): output out=_misout_ n=C3 C3BC C3C_BASELINE C4 C4CNEO TCC C4C_C4_RATIO MASP1 MASP2 MASP3 ALBUMIN_G_PR_L; NOTE: There were 102 observations read from the data set WORK._TEMPD_. WHERE MISSING(___class)=0; NOTE: The data set WORK._MISOUT_ has 1 observations and 13 variables. NOTE: PROCEDURE MEANS used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MPRINT(NEWLIST): proc transpose data=_misout_ out=_Tmiss_; MPRINT(NEWLIST): run; NOTE: There were 1 observations read from the data set WORK._MISOUT_. NOTE: The data set WORK._TMISS_ has 13 observations and 3 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(NEWLIST): data _tmiss_; MPRINT(NEWLIST): set _tmiss_; MPRINT(NEWLIST): if _NAME_ ne '_TYPE_'; MPRINT(NEWLIST): if _NAME_ ne '_FREQ_'; MPRINT(NEWLIST): run; NOTE: There were 13 observations read from the data set WORK._TMISS_. The SAS System NOTE: The data set WORK._TMISS_ has 11 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(NEWLIST): data _null_; MPRINT(NEWLIST): ** Get enough variable length for _vlist_ **; MPRINT(NEWLIST): retain _vlist_ " C3 C3BC C3C_BASELINE C4 C4CNEO TCC C4C_C4_RATIO MASP1 MASP2 MASP3 ALBUMIN_G_PR_L "; MPRINT(NEWLIST): if _N_=1 then _vlist_=" "; MPRINT(NEWLIST): retain change 0; MPRINT(NEWLIST): set _Tmiss_ end=eof; MPRINT(NEWLIST): if col1 ne 0 then _vlist_=trim(left(_vlist_))||" "||_NAME_; MPRINT(NEWLIST): if col1=0 then do; MPRINT(NEWLIST): change=1; MPRINT(NEWLIST): put "WARNING: Variable " _NAME_ "in list CON3 is completely missing."; MPRINT(NEWLIST): put "WARNING: " _NAME_ "will not be analyzed."; MPRINT(NEWLIST): end; MPRINT(NEWLIST): if eof=1 then do; MPRINT(NEWLIST): if change=1 then call symput("CON3", trim(_vlist_)); MPRINT(NEWLIST): end; MPRINT(NEWLIST): run; NOTE: There were 11 observations read from the data set WORK._TMISS_. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): ; MPRINT(SUMMTABLE): ***** COUNT NUMBER OF VARIABLES *****; MPRINT(SUMMTABLE): *** end to DO UNTIL; MPRINT(SUMMTABLE): ***** Check at least one variable was specified *****; MPRINT(SUMMTABLE): ***** Check all continuous variables are SAS numeric *****; MPRINT(SUMMTABLE): data _null_; MPRINT(SUMMTABLE): set _tempd_; MPRINT(SUMMTABLE): if _N_=1; MPRINT(SUMMTABLE): badvar=0; MPRINT(SUMMTABLE): if vtype(C3)='C' then do; MPRINT(SUMMTABLE): badvar=1; MPRINT(SUMMTABLE): put "ERROR - C3 is not numeric, but was listed in CON3"; MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): if vtype(C3BC)='C' then do; MPRINT(SUMMTABLE): badvar=1; MPRINT(SUMMTABLE): put "ERROR - C3BC is not numeric, but was listed in CON3"; MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): if vtype(C3C_BASELINE)='C' then do; MPRINT(SUMMTABLE): badvar=1; MPRINT(SUMMTABLE): put "ERROR - C3C_BASELINE is not numeric, but was listed in CON3"; MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): if vtype(C4)='C' then do; MPRINT(SUMMTABLE): badvar=1; MPRINT(SUMMTABLE): put "ERROR - C4 is not numeric, but was listed in CON3"; MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): if vtype(C4CNEO)='C' then do; MPRINT(SUMMTABLE): badvar=1; MPRINT(SUMMTABLE): put "ERROR - C4CNEO is not numeric, but was listed in CON3"; MPRINT(SUMMTABLE): end; The SAS System MPRINT(SUMMTABLE): if vtype(TCC)='C' then do; MPRINT(SUMMTABLE): badvar=1; MPRINT(SUMMTABLE): put "ERROR - TCC is not numeric, but was listed in CON3"; MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): if vtype(C4C_C4_RATIO)='C' then do; MPRINT(SUMMTABLE): badvar=1; MPRINT(SUMMTABLE): put "ERROR - C4C_C4_RATIO is not numeric, but was listed in CON3"; MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): if vtype(MASP1)='C' then do; MPRINT(SUMMTABLE): badvar=1; MPRINT(SUMMTABLE): put "ERROR - MASP1 is not numeric, but was listed in CON3"; MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): if vtype(MASP2)='C' then do; MPRINT(SUMMTABLE): badvar=1; MPRINT(SUMMTABLE): put "ERROR - MASP2 is not numeric, but was listed in CON3"; MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): if vtype(MASP3)='C' then do; MPRINT(SUMMTABLE): badvar=1; MPRINT(SUMMTABLE): put "ERROR - MASP3 is not numeric, but was listed in CON3"; MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): if vtype(ALBUMIN_G_PR_L)='C' then do; MPRINT(SUMMTABLE): badvar=1; MPRINT(SUMMTABLE): put "ERROR - ALBUMIN_G_PR_L is not numeric, but was listed in CON3"; MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): if badvar=1 then call symput('ERRORFLG', left(put(badvar, 2.0))); MPRINT(SUMMTABLE): run; NOTE: There were 102 observations read from the data set WORK._TEMPD_. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): *** MAKE SURE VARIABLES WERE NOT LISTED TWICE ***; MPRINT(SUMMTABLE): data _tmpchk_; MPRINT(SUMMTABLE): attrib _var length=$32; MPRINT(SUMMTABLE): _var="C3"; MPRINT(SUMMTABLE): output; MPRINT(SUMMTABLE): _var="C3BC"; MPRINT(SUMMTABLE): output; MPRINT(SUMMTABLE): _var="C3C_BASELINE"; MPRINT(SUMMTABLE): output; MPRINT(SUMMTABLE): _var="C4"; MPRINT(SUMMTABLE): output; MPRINT(SUMMTABLE): _var="C4CNEO"; MPRINT(SUMMTABLE): output; MPRINT(SUMMTABLE): _var="TCC"; MPRINT(SUMMTABLE): output; MPRINT(SUMMTABLE): _var="C4C_C4_RATIO"; MPRINT(SUMMTABLE): output; MPRINT(SUMMTABLE): _var="MASP1"; MPRINT(SUMMTABLE): output; MPRINT(SUMMTABLE): _var="MASP2"; MPRINT(SUMMTABLE): output; MPRINT(SUMMTABLE): _var="MASP3"; MPRINT(SUMMTABLE): output; MPRINT(SUMMTABLE): _var="ALBUMIN_G_PR_L"; MPRINT(SUMMTABLE): output; The SAS System MPRINT(SUMMTABLE): run; NOTE: The data set WORK._TMPCHK_ has 11 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): proc freq noprint; MPRINT(SUMMTABLE): table _var / out=_tmpout_; MPRINT(SUMMTABLE): run; NOTE: There were 11 observations read from the data set WORK._TMPCHK_. NOTE: The data set WORK._TMPOUT_ has 11 observations and 3 variables. NOTE: PROCEDURE FREQ used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MPRINT(SUMMTABLE): data _null_; MPRINT(SUMMTABLE): set _tmpout_; MPRINT(SUMMTABLE): if count>1 then do; MPRINT(SUMMTABLE): put 'ERROR - A variable was listed more than once. ' _var= count= ; MPRINT(SUMMTABLE): dummy=1; MPRINT(SUMMTABLE): call symput('ERRORFLG', left(put(dummy, 2.0))); MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): run; NOTE: There were 11 observations read from the data set WORK._TMPOUT_. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): proc datasets nolist; MPRINT(SUMMTABLE): delete _tmpchk_ _tmpout_ _misout_ _tmiss_; MPRINT(SUMMTABLE): run; NOTE: Deleting WORK._TMPCHK_ (memtype=DATA). NOTE: Deleting WORK._TMPOUT_ (memtype=DATA). NOTE: Deleting WORK._MISOUT_ (memtype=DATA). NOTE: Deleting WORK._TMISS_ (memtype=DATA). MPRINT(SUMMTABLE): quit; NOTE: PROCEDURE DATASETS used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): ***** MAKE SURE THE SDOPT OPTION IS VALID *****; MPRINT(SUMMTABLE): ***** IF LIST IS SPECIFIED AND THE SORTBY OPTION IS NOT SPECIFIED PUT WARNING *****; MPRINT(SUMMTABLE): *** end to IF &ERRORFLG^=1 THEN DO (checks); MPRINT(SUMMTABLE): *********************************************************************; MPRINT(SUMMTABLE): *********************************************************************; MPRINT(SUMMTABLE): ***************** If no errors, begin macros **********************; MPRINT(SUMMTABLE): *********************************************************************; MPRINT(SUMMTABLE): *********************************************************************; MPRINT(SUMMTABLE): ***************************************; MPRINT(SUMMTABLE): ***** Manage titles and footnotes *****; MPRINT(SUMMTABLE): ***** If ODSMEMO=1, do not do *****; The SAS System MPRINT(SUMMTABLE): ***************************************; MPRINT(SUMMTABLE): ***** Store Footnotes *****; MPRINT(SUMMTABLE): proc sql ; MPRINT(SUMMTABLE): create table work._f as select * from dictionary.titles where type='F'; NOTE: Table WORK._F created, with 0 rows and 3 columns. MPRINT(SUMMTABLE): reset noprint; MPRINT(SUMMTABLE): quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): proc sql; MPRINT(SUMMTABLE): reset noprint; MPRINT(SUMMTABLE): select nobs into :FN from dictionary.tables where libname="WORK" & memname="_F"; MPRINT(SUMMTABLE): quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): ***** Store footnotes in macro variables *****; MPRINT(SUMMTABLE): ** Initialize at least one title **; MPRINT(SUMMTABLE): data _null_; MPRINT(SUMMTABLE): set _f; MPRINT(SUMMTABLE): run; NOTE: There were 0 observations read from the data set WORK._F. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): ***** If no base title stored, do not want to print "The SAS System" *****; MPRINT(SUMMTABLE): proc sql noprint; MPRINT(SUMMTABLE): select upcase(compress(text, ,"scp")) into :CurrentTitle from dictionary.titles where type="T" and number=1; MPRINT(SUMMTABLE): *********************************************************************; MPRINT(SUMMTABLE): *************** Get number of classification levels ****************; MPRINT(SUMMTABLE): *********************************************************************; MPRINT(SUMMTABLE): ods listing close; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): proc freq data=_tempd_; MPRINT(SUMMTABLE): table ___class / nocol norow nopercent; MPRINT(SUMMTABLE): ods output OneWayFreqs=__groups; MPRINT(SUMMTABLE): run; NOTE: The data set WORK.__GROUPS has 2 observations and 5 variables. NOTE: There were 102 observations read from the data set WORK._TEMPD_. NOTE: PROCEDURE FREQ used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MPRINT(SUMMTABLE): ods listing; The SAS System MPRINT(SUMMTABLE): data _null_; MPRINT(SUMMTABLE): set __groups nobs=_lev_ end=_eof; MPRINT(SUMMTABLE): call symput('LEVELS', left(put(_lev_,2.))); MPRINT(SUMMTABLE): if _eof then do; MPRINT(SUMMTABLE): ctype=vtype(___class); MPRINT(SUMMTABLE): call symput ('CLASSTYP',trim(left(ctype))); MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): run; NOTE: There were 2 observations read from the data set WORK.__GROUPS. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): data _null_; MPRINT(SUMMTABLE): set __groups; MPRINT(SUMMTABLE): retain _tmlab1-_tmlab2 _tmn1-_tmn2 _tmv1-_tmv2 ; MPRINT(SUMMTABLE): length _tmlab1-_tmlab2 $24; MPRINT(SUMMTABLE): if _N_=1 then do; MPRINT(SUMMTABLE): _tmv1=trim(put(___class, 10.4)); MPRINT(SUMMTABLE): _tmlab1 = trim(left(F____class)); MPRINT(SUMMTABLE): _tmn1 = trim(put(Frequency, 9.0)); MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): *** Assign levels and freqs to MACRO variables ***; MPRINT(SUMMTABLE): call symput("TVAL1", trim(left(_tmv1))); MPRINT(SUMMTABLE): call symput("TLAB1", trim(left(_tmlab1))); MPRINT(SUMMTABLE): call symput("TNUM1", trim(left(_tmn1))); MPRINT(SUMMTABLE): if _N_=2 then do; MPRINT(SUMMTABLE): _tmv2=trim(put(___class, 10.4)); MPRINT(SUMMTABLE): _tmlab2 = trim(left(F____class)); MPRINT(SUMMTABLE): _tmn2 = trim(put(Frequency, 9.0)); MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): *** Assign levels and freqs to MACRO variables ***; MPRINT(SUMMTABLE): call symput("TVAL2", trim(left(_tmv2))); MPRINT(SUMMTABLE): call symput("TLAB2", trim(left(_tmlab2))); MPRINT(SUMMTABLE): call symput("TNUM2", trim(left(_tmn2))); MPRINT(SUMMTABLE): run; NOTE: There were 2 observations read from the data set WORK.__GROUPS. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): proc datasets nolist; MPRINT(SUMMTABLE): delete __groups; MPRINT(SUMMTABLE): run; NOTE: Deleting WORK.__GROUPS (memtype=DATA). MPRINT(SUMMTABLE): quit; NOTE: PROCEDURE DATASETS used (Total process time): real time 0.00 seconds cpu time 0.00 seconds The CLASS variable (strep_a_only) has 2 levels. ****** DISPLAY SUMMARY ****** The SAS System CON1: 0 VARIABLES CON2: 0 VARIABLES CON3: 11 VARIABLES CAT1: 0 VARIABLES CAT2: 0 VARIABLES ORD1: 0 VARIABLES ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ MPRINT(SUMMTABLE): ************************************************************************************; MPRINT(SUMMTABLE): ********************** CATEGORICAL SUMMARY (R.L. version) **************************; MPRINT(SUMMTABLE): ************************************************************************************; MPRINT(SUMMTABLE): ***end of IF (&ICAT>0); MPRINT(SUMMTABLE): *********************************************************************; MPRINT(SUMMTABLE): **************** CONTINUOUS ANALYSIS (R.L. version) *****************; MPRINT(SUMMTABLE): *********************************************************************; MPRINT(SUMMTABLE): ods listing close; MPRINT(SUMMTABLE): ***** Get summary stats *****; MPRINT(SUMMTABLE): proc means data=_tempd_ n mean std median min max q1 q3 ; MPRINT(SUMMTABLE): class ___class; MPRINT(SUMMTABLE): var C3 C3BC C3C_BASELINE C4 C4CNEO TCC C4C_C4_RATIO MASP1 MASP2 MASP3 ALBUMIN_G_PR_L; MPRINT(SUMMTABLE): ods output Summary=_means_; MPRINT(SUMMTABLE): run; NOTE: The data set WORK._MEANS_ has 2 observations and 112 variables. NOTE: There were 102 observations read from the data set WORK._TEMPD_. NOTE: PROCEDURE MEANS used (Total process time): real time 0.02 seconds cpu time 0.02 seconds MPRINT(SUMMTABLE): proc means data=_tempd_ n mean std median min max q1 q3 ; MPRINT(SUMMTABLE): var C3 C3BC C3C_BASELINE C4 C4CNEO TCC C4C_C4_RATIO MASP1 MASP2 MASP3 ALBUMIN_G_PR_L; MPRINT(SUMMTABLE): ods output Summary=_meansall_; MPRINT(SUMMTABLE): run; NOTE: The data set WORK._MEANSALL_ has 1 observations and 110 variables. NOTE: There were 102 observations read from the data set WORK._TEMPD_. NOTE: PROCEDURE MEANS used (Total process time): real time 0.02 seconds cpu time 0.03 seconds MPRINT(SUMMTABLE): ***** Get p-values *****; MPRINT(SUMMTABLE): ***** ANOVA *****; MPRINT(SUMMTABLE): *** end to IF &ICON1>0; MPRINT(SUMMTABLE): ***** Kruskal-Wallis *****; MPRINT(SUMMTABLE): proc npar1way data=_tempd_ wilcoxon ; MPRINT(SUMMTABLE): class ___class; MPRINT(SUMMTABLE): var C3; MPRINT(SUMMTABLE): ods output KruskalWallisTest=_kwt__; MPRINT(SUMMTABLE): run; NOTE: The data set WORK._KWT__ has 3 observations and 5 variables. NOTE: PROCEDURE NPAR1WAY used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): data _kwt__; MPRINT(SUMMTABLE): set _kwt__; MPRINT(SUMMTABLE): attrib __var2 length=$32; MPRINT(SUMMTABLE): keep _i __var2 _pval; The SAS System MPRINT(SUMMTABLE): if Label1='Pr > Chi-Square'; MPRINT(SUMMTABLE): _pval=nValue1; MPRINT(SUMMTABLE): __var2="C3"; MPRINT(SUMMTABLE): _var2=upcase(__var2); MPRINT(SUMMTABLE): _i=0 + 1; MPRINT(SUMMTABLE): run; NOTE: There were 3 observations read from the data set WORK._KWT__. NOTE: The data set WORK._KWT__ has 1 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MPRINT(SUMMTABLE): proc append base=_kwt_ data=_kwt__; MPRINT(SUMMTABLE): run; NOTE: Appending WORK._KWT__ to WORK._KWT_. NOTE: BASE data set does not exist. DATA file is being copied to BASE file. NOTE: There were 1 observations read from the data set WORK._KWT__. NOTE: The data set WORK._KWT_ has 1 observations and 3 variables. NOTE: PROCEDURE APPEND used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): quit; MPRINT(SUMMTABLE): proc datasets nolist; MPRINT(SUMMTABLE): delete _kwt__; MPRINT(SUMMTABLE): run; NOTE: Deleting WORK._KWT__ (memtype=DATA). MPRINT(SUMMTABLE): quit; NOTE: PROCEDURE DATASETS used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): *** end to IF SYSFUNC; MPRINT(SUMMTABLE): proc npar1way data=_tempd_ wilcoxon ; MPRINT(SUMMTABLE): class ___class; MPRINT(SUMMTABLE): var C3BC; MPRINT(SUMMTABLE): ods output KruskalWallisTest=_kwt__; MPRINT(SUMMTABLE): run; NOTE: The data set WORK._KWT__ has 3 observations and 5 variables. NOTE: PROCEDURE NPAR1WAY used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MPRINT(SUMMTABLE): data _kwt__; MPRINT(SUMMTABLE): set _kwt__; MPRINT(SUMMTABLE): attrib __var2 length=$32; MPRINT(SUMMTABLE): keep _i __var2 _pval; MPRINT(SUMMTABLE): if Label1='Pr > Chi-Square'; MPRINT(SUMMTABLE): _pval=nValue1; MPRINT(SUMMTABLE): __var2="C3BC"; The SAS System MPRINT(SUMMTABLE): _var2=upcase(__var2); MPRINT(SUMMTABLE): _i=0 + 2; MPRINT(SUMMTABLE): run; NOTE: There were 3 observations read from the data set WORK._KWT__. NOTE: The data set WORK._KWT__ has 1 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MPRINT(SUMMTABLE): proc append base=_kwt_ data=_kwt__; MPRINT(SUMMTABLE): run; NOTE: Appending WORK._KWT__ to WORK._KWT_. NOTE: There were 1 observations read from the data set WORK._KWT__. NOTE: 1 observations added. NOTE: The data set WORK._KWT_ has 2 observations and 3 variables. NOTE: PROCEDURE APPEND used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): quit; MPRINT(SUMMTABLE): proc datasets nolist; MPRINT(SUMMTABLE): delete _kwt__; MPRINT(SUMMTABLE): run; NOTE: Deleting WORK._KWT__ (memtype=DATA). MPRINT(SUMMTABLE): quit; NOTE: PROCEDURE DATASETS used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): *** end to IF SYSFUNC; MPRINT(SUMMTABLE): proc npar1way data=_tempd_ wilcoxon ; MPRINT(SUMMTABLE): class ___class; MPRINT(SUMMTABLE): var C3C_BASELINE; MPRINT(SUMMTABLE): ods output KruskalWallisTest=_kwt__; MPRINT(SUMMTABLE): run; NOTE: The data set WORK._KWT__ has 3 observations and 5 variables. NOTE: PROCEDURE NPAR1WAY used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MPRINT(SUMMTABLE): data _kwt__; MPRINT(SUMMTABLE): set _kwt__; MPRINT(SUMMTABLE): attrib __var2 length=$32; MPRINT(SUMMTABLE): keep _i __var2 _pval; MPRINT(SUMMTABLE): if Label1='Pr > Chi-Square'; MPRINT(SUMMTABLE): _pval=nValue1; MPRINT(SUMMTABLE): __var2="C3C_BASELINE"; MPRINT(SUMMTABLE): _var2=upcase(__var2); MPRINT(SUMMTABLE): _i=0 + 3; MPRINT(SUMMTABLE): run; The SAS System NOTE: There were 3 observations read from the data set WORK._KWT__. NOTE: The data set WORK._KWT__ has 1 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): proc append base=_kwt_ data=_kwt__; MPRINT(SUMMTABLE): run; NOTE: Appending WORK._KWT__ to WORK._KWT_. NOTE: There were 1 observations read from the data set WORK._KWT__. NOTE: 1 observations added. NOTE: The data set WORK._KWT_ has 3 observations and 3 variables. NOTE: PROCEDURE APPEND used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): quit; MPRINT(SUMMTABLE): proc datasets nolist; MPRINT(SUMMTABLE): delete _kwt__; MPRINT(SUMMTABLE): run; NOTE: Deleting WORK._KWT__ (memtype=DATA). MPRINT(SUMMTABLE): quit; NOTE: PROCEDURE DATASETS used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): *** end to IF SYSFUNC; MPRINT(SUMMTABLE): proc npar1way data=_tempd_ wilcoxon ; MPRINT(SUMMTABLE): class ___class; MPRINT(SUMMTABLE): var C4; MPRINT(SUMMTABLE): ods output KruskalWallisTest=_kwt__; MPRINT(SUMMTABLE): run; NOTE: The data set WORK._KWT__ has 3 observations and 5 variables. NOTE: PROCEDURE NPAR1WAY used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MPRINT(SUMMTABLE): data _kwt__; MPRINT(SUMMTABLE): set _kwt__; MPRINT(SUMMTABLE): attrib __var2 length=$32; MPRINT(SUMMTABLE): keep _i __var2 _pval; MPRINT(SUMMTABLE): if Label1='Pr > Chi-Square'; MPRINT(SUMMTABLE): _pval=nValue1; MPRINT(SUMMTABLE): __var2="C4"; MPRINT(SUMMTABLE): _var2=upcase(__var2); MPRINT(SUMMTABLE): _i=0 + 4; MPRINT(SUMMTABLE): run; NOTE: There were 3 observations read from the data set WORK._KWT__. NOTE: The data set WORK._KWT__ has 1 observations and 3 variables. The SAS System NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): proc append base=_kwt_ data=_kwt__; MPRINT(SUMMTABLE): run; NOTE: Appending WORK._KWT__ to WORK._KWT_. NOTE: There were 1 observations read from the data set WORK._KWT__. NOTE: 1 observations added. NOTE: The data set WORK._KWT_ has 4 observations and 3 variables. NOTE: PROCEDURE APPEND used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MPRINT(SUMMTABLE): quit; MPRINT(SUMMTABLE): proc datasets nolist; MPRINT(SUMMTABLE): delete _kwt__; MPRINT(SUMMTABLE): run; NOTE: Deleting WORK._KWT__ (memtype=DATA). MPRINT(SUMMTABLE): quit; NOTE: PROCEDURE DATASETS used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): *** end to IF SYSFUNC; MPRINT(SUMMTABLE): proc npar1way data=_tempd_ wilcoxon ; MPRINT(SUMMTABLE): class ___class; MPRINT(SUMMTABLE): var C4CNEO; MPRINT(SUMMTABLE): ods output KruskalWallisTest=_kwt__; MPRINT(SUMMTABLE): run; NOTE: The data set WORK._KWT__ has 3 observations and 5 variables. NOTE: PROCEDURE NPAR1WAY used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MPRINT(SUMMTABLE): data _kwt__; MPRINT(SUMMTABLE): set _kwt__; MPRINT(SUMMTABLE): attrib __var2 length=$32; MPRINT(SUMMTABLE): keep _i __var2 _pval; MPRINT(SUMMTABLE): if Label1='Pr > Chi-Square'; MPRINT(SUMMTABLE): _pval=nValue1; MPRINT(SUMMTABLE): __var2="C4CNEO"; MPRINT(SUMMTABLE): _var2=upcase(__var2); MPRINT(SUMMTABLE): _i=0 + 5; MPRINT(SUMMTABLE): run; NOTE: There were 3 observations read from the data set WORK._KWT__. NOTE: The data set WORK._KWT__ has 1 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds The SAS System MPRINT(SUMMTABLE): proc append base=_kwt_ data=_kwt__; MPRINT(SUMMTABLE): run; NOTE: Appending WORK._KWT__ to WORK._KWT_. NOTE: There were 1 observations read from the data set WORK._KWT__. NOTE: 1 observations added. NOTE: The data set WORK._KWT_ has 5 observations and 3 variables. NOTE: PROCEDURE APPEND used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): quit; MPRINT(SUMMTABLE): proc datasets nolist; MPRINT(SUMMTABLE): delete _kwt__; MPRINT(SUMMTABLE): run; NOTE: Deleting WORK._KWT__ (memtype=DATA). MPRINT(SUMMTABLE): quit; NOTE: PROCEDURE DATASETS used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): *** end to IF SYSFUNC; MPRINT(SUMMTABLE): proc npar1way data=_tempd_ wilcoxon ; MPRINT(SUMMTABLE): class ___class; MPRINT(SUMMTABLE): var TCC; MPRINT(SUMMTABLE): ods output KruskalWallisTest=_kwt__; MPRINT(SUMMTABLE): run; NOTE: The data set WORK._KWT__ has 3 observations and 5 variables. NOTE: PROCEDURE NPAR1WAY used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MPRINT(SUMMTABLE): data _kwt__; MPRINT(SUMMTABLE): set _kwt__; MPRINT(SUMMTABLE): attrib __var2 length=$32; MPRINT(SUMMTABLE): keep _i __var2 _pval; MPRINT(SUMMTABLE): if Label1='Pr > Chi-Square'; MPRINT(SUMMTABLE): _pval=nValue1; MPRINT(SUMMTABLE): __var2="TCC"; MPRINT(SUMMTABLE): _var2=upcase(__var2); MPRINT(SUMMTABLE): _i=0 + 6; MPRINT(SUMMTABLE): run; NOTE: There were 3 observations read from the data set WORK._KWT__. NOTE: The data set WORK._KWT__ has 1 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): proc append base=_kwt_ data=_kwt__; The SAS System MPRINT(SUMMTABLE): run; NOTE: Appending WORK._KWT__ to WORK._KWT_. NOTE: There were 1 observations read from the data set WORK._KWT__. NOTE: 1 observations added. NOTE: The data set WORK._KWT_ has 6 observations and 3 variables. NOTE: PROCEDURE APPEND used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): quit; MPRINT(SUMMTABLE): proc datasets nolist; MPRINT(SUMMTABLE): delete _kwt__; MPRINT(SUMMTABLE): run; NOTE: Deleting WORK._KWT__ (memtype=DATA). MPRINT(SUMMTABLE): quit; NOTE: PROCEDURE DATASETS used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): *** end to IF SYSFUNC; MPRINT(SUMMTABLE): proc npar1way data=_tempd_ wilcoxon ; MPRINT(SUMMTABLE): class ___class; MPRINT(SUMMTABLE): var C4C_C4_RATIO; MPRINT(SUMMTABLE): ods output KruskalWallisTest=_kwt__; MPRINT(SUMMTABLE): run; NOTE: The data set WORK._KWT__ has 3 observations and 5 variables. NOTE: PROCEDURE NPAR1WAY used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MPRINT(SUMMTABLE): data _kwt__; MPRINT(SUMMTABLE): set _kwt__; MPRINT(SUMMTABLE): attrib __var2 length=$32; MPRINT(SUMMTABLE): keep _i __var2 _pval; MPRINT(SUMMTABLE): if Label1='Pr > Chi-Square'; MPRINT(SUMMTABLE): _pval=nValue1; MPRINT(SUMMTABLE): __var2="C4C_C4_RATIO"; MPRINT(SUMMTABLE): _var2=upcase(__var2); MPRINT(SUMMTABLE): _i=0 + 7; MPRINT(SUMMTABLE): run; NOTE: There were 3 observations read from the data set WORK._KWT__. NOTE: The data set WORK._KWT__ has 1 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): proc append base=_kwt_ data=_kwt__; MPRINT(SUMMTABLE): run; NOTE: Appending WORK._KWT__ to WORK._KWT_. The SAS System NOTE: There were 1 observations read from the data set WORK._KWT__. NOTE: 1 observations added. NOTE: The data set WORK._KWT_ has 7 observations and 3 variables. NOTE: PROCEDURE APPEND used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MPRINT(SUMMTABLE): quit; MPRINT(SUMMTABLE): proc datasets nolist; MPRINT(SUMMTABLE): delete _kwt__; MPRINT(SUMMTABLE): run; NOTE: Deleting WORK._KWT__ (memtype=DATA). MPRINT(SUMMTABLE): quit; NOTE: PROCEDURE DATASETS used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): *** end to IF SYSFUNC; MPRINT(SUMMTABLE): proc npar1way data=_tempd_ wilcoxon ; MPRINT(SUMMTABLE): class ___class; MPRINT(SUMMTABLE): var MASP1; MPRINT(SUMMTABLE): ods output KruskalWallisTest=_kwt__; MPRINT(SUMMTABLE): run; NOTE: The data set WORK._KWT__ has 3 observations and 5 variables. NOTE: PROCEDURE NPAR1WAY used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MPRINT(SUMMTABLE): data _kwt__; MPRINT(SUMMTABLE): set _kwt__; MPRINT(SUMMTABLE): attrib __var2 length=$32; MPRINT(SUMMTABLE): keep _i __var2 _pval; MPRINT(SUMMTABLE): if Label1='Pr > Chi-Square'; MPRINT(SUMMTABLE): _pval=nValue1; MPRINT(SUMMTABLE): __var2="MASP1"; MPRINT(SUMMTABLE): _var2=upcase(__var2); MPRINT(SUMMTABLE): _i=0 + 8; MPRINT(SUMMTABLE): run; NOTE: There were 3 observations read from the data set WORK._KWT__. NOTE: The data set WORK._KWT__ has 1 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): proc append base=_kwt_ data=_kwt__; MPRINT(SUMMTABLE): run; NOTE: Appending WORK._KWT__ to WORK._KWT_. NOTE: There were 1 observations read from the data set WORK._KWT__. NOTE: 1 observations added. NOTE: The data set WORK._KWT_ has 8 observations and 3 variables. The SAS System NOTE: PROCEDURE APPEND used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): quit; MPRINT(SUMMTABLE): proc datasets nolist; MPRINT(SUMMTABLE): delete _kwt__; MPRINT(SUMMTABLE): run; NOTE: Deleting WORK._KWT__ (memtype=DATA). MPRINT(SUMMTABLE): quit; NOTE: PROCEDURE DATASETS used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): *** end to IF SYSFUNC; MPRINT(SUMMTABLE): proc npar1way data=_tempd_ wilcoxon ; MPRINT(SUMMTABLE): class ___class; MPRINT(SUMMTABLE): var MASP2; MPRINT(SUMMTABLE): ods output KruskalWallisTest=_kwt__; MPRINT(SUMMTABLE): run; NOTE: The data set WORK._KWT__ has 3 observations and 5 variables. NOTE: PROCEDURE NPAR1WAY used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MPRINT(SUMMTABLE): data _kwt__; MPRINT(SUMMTABLE): set _kwt__; MPRINT(SUMMTABLE): attrib __var2 length=$32; MPRINT(SUMMTABLE): keep _i __var2 _pval; MPRINT(SUMMTABLE): if Label1='Pr > Chi-Square'; MPRINT(SUMMTABLE): _pval=nValue1; MPRINT(SUMMTABLE): __var2="MASP2"; MPRINT(SUMMTABLE): _var2=upcase(__var2); MPRINT(SUMMTABLE): _i=0 + 9; MPRINT(SUMMTABLE): run; NOTE: There were 3 observations read from the data set WORK._KWT__. NOTE: The data set WORK._KWT__ has 1 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): proc append base=_kwt_ data=_kwt__; MPRINT(SUMMTABLE): run; NOTE: Appending WORK._KWT__ to WORK._KWT_. NOTE: There were 1 observations read from the data set WORK._KWT__. NOTE: 1 observations added. NOTE: The data set WORK._KWT_ has 9 observations and 3 variables. NOTE: PROCEDURE APPEND used (Total process time): real time 0.00 seconds cpu time 0.00 seconds The SAS System MPRINT(SUMMTABLE): quit; MPRINT(SUMMTABLE): proc datasets nolist; MPRINT(SUMMTABLE): delete _kwt__; MPRINT(SUMMTABLE): run; NOTE: Deleting WORK._KWT__ (memtype=DATA). MPRINT(SUMMTABLE): quit; NOTE: PROCEDURE DATASETS used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): *** end to IF SYSFUNC; MPRINT(SUMMTABLE): proc npar1way data=_tempd_ wilcoxon ; MPRINT(SUMMTABLE): class ___class; MPRINT(SUMMTABLE): var MASP3; MPRINT(SUMMTABLE): ods output KruskalWallisTest=_kwt__; MPRINT(SUMMTABLE): run; NOTE: The data set WORK._KWT__ has 3 observations and 5 variables. NOTE: PROCEDURE NPAR1WAY used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MPRINT(SUMMTABLE): data _kwt__; MPRINT(SUMMTABLE): set _kwt__; MPRINT(SUMMTABLE): attrib __var2 length=$32; MPRINT(SUMMTABLE): keep _i __var2 _pval; MPRINT(SUMMTABLE): if Label1='Pr > Chi-Square'; MPRINT(SUMMTABLE): _pval=nValue1; MPRINT(SUMMTABLE): __var2="MASP3"; MPRINT(SUMMTABLE): _var2=upcase(__var2); MPRINT(SUMMTABLE): _i=0 + 10; MPRINT(SUMMTABLE): run; NOTE: There were 3 observations read from the data set WORK._KWT__. NOTE: The data set WORK._KWT__ has 1 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): proc append base=_kwt_ data=_kwt__; MPRINT(SUMMTABLE): run; NOTE: Appending WORK._KWT__ to WORK._KWT_. NOTE: There were 1 observations read from the data set WORK._KWT__. NOTE: 1 observations added. NOTE: The data set WORK._KWT_ has 10 observations and 3 variables. NOTE: PROCEDURE APPEND used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MPRINT(SUMMTABLE): quit; The SAS System MPRINT(SUMMTABLE): proc datasets nolist; MPRINT(SUMMTABLE): delete _kwt__; MPRINT(SUMMTABLE): run; NOTE: Deleting WORK._KWT__ (memtype=DATA). MPRINT(SUMMTABLE): quit; NOTE: PROCEDURE DATASETS used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): *** end to IF SYSFUNC; MPRINT(SUMMTABLE): proc npar1way data=_tempd_ wilcoxon ; MPRINT(SUMMTABLE): class ___class; MPRINT(SUMMTABLE): var ALBUMIN_G_PR_L; MPRINT(SUMMTABLE): ods output KruskalWallisTest=_kwt__; MPRINT(SUMMTABLE): run; NOTE: The data set WORK._KWT__ has 3 observations and 5 variables. NOTE: PROCEDURE NPAR1WAY used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MPRINT(SUMMTABLE): data _kwt__; MPRINT(SUMMTABLE): set _kwt__; MPRINT(SUMMTABLE): attrib __var2 length=$32; MPRINT(SUMMTABLE): keep _i __var2 _pval; MPRINT(SUMMTABLE): if Label1='Pr > Chi-Square'; MPRINT(SUMMTABLE): _pval=nValue1; MPRINT(SUMMTABLE): __var2="ALBUMIN_G_PR_L"; MPRINT(SUMMTABLE): _var2=upcase(__var2); MPRINT(SUMMTABLE): _i=0 + 11; MPRINT(SUMMTABLE): run; NOTE: There were 3 observations read from the data set WORK._KWT__. NOTE: The data set WORK._KWT__ has 1 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): proc append base=_kwt_ data=_kwt__; MPRINT(SUMMTABLE): run; NOTE: Appending WORK._KWT__ to WORK._KWT_. NOTE: There were 1 observations read from the data set WORK._KWT__. NOTE: 1 observations added. NOTE: The data set WORK._KWT_ has 11 observations and 3 variables. NOTE: PROCEDURE APPEND used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): quit; MPRINT(SUMMTABLE): proc datasets nolist; MPRINT(SUMMTABLE): delete _kwt__; MPRINT(SUMMTABLE): run; The SAS System NOTE: Deleting WORK._KWT__ (memtype=DATA). MPRINT(SUMMTABLE): quit; NOTE: PROCEDURE DATASETS used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): *** end to IF SYSFUNC; MPRINT(SUMMTABLE): ***end to DO KWTL; MPRINT(SUMMTABLE): proc sort data=_kwt_; MPRINT(SUMMTABLE): by _i; MPRINT(SUMMTABLE): run; NOTE: There were 11 observations read from the data set WORK._KWT_. NOTE: The data set WORK._KWT_ has 11 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): *** end to IF ICON23; MPRINT(SUMMTABLE): *** end to IF LEVELS NE 1; MPRINT(SUMMTABLE): ods listing; MPRINT(SUMMTABLE): ***** Var names and labels *****; MPRINT(SUMMTABLE): data _labs; MPRINT(SUMMTABLE): attrib __var1 length=$32 _lab length=$40; MPRINT(SUMMTABLE): set _tempd_(obs=1); MPRINT(SUMMTABLE): __var1="C3"; MPRINT(SUMMTABLE): _lab=vlabel(C3); MPRINT(SUMMTABLE): _i=1; MPRINT(SUMMTABLE): output; MPRINT(SUMMTABLE): __var1="C3BC"; MPRINT(SUMMTABLE): _lab=vlabel(C3BC); MPRINT(SUMMTABLE): _i=2; MPRINT(SUMMTABLE): output; MPRINT(SUMMTABLE): __var1="C3C_BASELINE"; MPRINT(SUMMTABLE): _lab=vlabel(C3C_BASELINE); MPRINT(SUMMTABLE): _i=3; MPRINT(SUMMTABLE): output; MPRINT(SUMMTABLE): __var1="C4"; MPRINT(SUMMTABLE): _lab=vlabel(C4); MPRINT(SUMMTABLE): _i=4; MPRINT(SUMMTABLE): output; MPRINT(SUMMTABLE): __var1="C4CNEO"; MPRINT(SUMMTABLE): _lab=vlabel(C4CNEO); MPRINT(SUMMTABLE): _i=5; MPRINT(SUMMTABLE): output; MPRINT(SUMMTABLE): __var1="TCC"; MPRINT(SUMMTABLE): _lab=vlabel(TCC); MPRINT(SUMMTABLE): _i=6; MPRINT(SUMMTABLE): output; MPRINT(SUMMTABLE): __var1="C4C_C4_RATIO"; MPRINT(SUMMTABLE): _lab=vlabel(C4C_C4_RATIO); MPRINT(SUMMTABLE): _i=7; MPRINT(SUMMTABLE): output; MPRINT(SUMMTABLE): __var1="MASP1"; The SAS System MPRINT(SUMMTABLE): _lab=vlabel(MASP1); MPRINT(SUMMTABLE): _i=8; MPRINT(SUMMTABLE): output; MPRINT(SUMMTABLE): __var1="MASP2"; MPRINT(SUMMTABLE): _lab=vlabel(MASP2); MPRINT(SUMMTABLE): _i=9; MPRINT(SUMMTABLE): output; MPRINT(SUMMTABLE): __var1="MASP3"; MPRINT(SUMMTABLE): _lab=vlabel(MASP3); MPRINT(SUMMTABLE): _i=10; MPRINT(SUMMTABLE): output; MPRINT(SUMMTABLE): __var1="ALBUMIN_G_PR_L"; MPRINT(SUMMTABLE): _lab=vlabel(ALBUMIN_G_PR_L); MPRINT(SUMMTABLE): _i=11; MPRINT(SUMMTABLE): output; MPRINT(SUMMTABLE): _var1=upcase(__var1); MPRINT(SUMMTABLE): keep __var1 _lab _i; MPRINT(SUMMTABLE): run; NOTE: There were 1 observations read from the data set WORK._TEMPD_. NOTE: The data set WORK._LABS has 11 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MPRINT(SUMMTABLE): ***** Transpose output from proc means to get needed stats *****; MPRINT(SUMMTABLE): proc transpose data=_means_ out=_tmeans_; MPRINT(SUMMTABLE): run; NOTE: There were 2 observations read from the data set WORK._MEANS_. NOTE: The data set WORK._TMEANS_ has 90 observations and 4 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): proc transpose data=_meansall_ out=_tmeansall_; MPRINT(SUMMTABLE): run; NOTE: There were 1 observations read from the data set WORK._MEANSALL_. NOTE: The data set WORK._TMEANSALL_ has 88 observations and 3 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MPRINT(SUMMTABLE): data _tmeans_; MPRINT(SUMMTABLE): set _tmeans_; MPRINT(SUMMTABLE): _o=_n_; NOTE: There were 90 observations read from the data set WORK._TMEANS_. NOTE: The data set WORK._TMEANS_ has 90 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MPRINT(SUMMTABLE): proc sort data=_tmeans_; The SAS System MPRINT(SUMMTABLE): by _name_ _label_; NOTE: There were 90 observations read from the data set WORK._TMEANS_. NOTE: The data set WORK._TMEANS_ has 90 observations and 5 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): proc sort data=_tmeansall_; MPRINT(SUMMTABLE): by _name_ _label_; MPRINT(SUMMTABLE): run; NOTE: There were 88 observations read from the data set WORK._TMEANSALL_. NOTE: The data set WORK._TMEANSALL_ has 88 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): data _tmeans1_; MPRINT(SUMMTABLE): merge _tmeansall_(rename=(COL1=COL0)) _tmeans_; MPRINT(SUMMTABLE): by _name_ _label_; MPRINT(SUMMTABLE): run; NOTE: There were 88 observations read from the data set WORK._TMEANSALL_. NOTE: There were 90 observations read from the data set WORK._TMEANS_. NOTE: The data set WORK._TMEANS1_ has 90 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): proc sort data=_tmeans1_ out=_tmeans_(drop=_o); MPRINT(SUMMTABLE): by _o; MPRINT(SUMMTABLE): run; NOTE: There were 90 observations read from the data set WORK._TMEANS1_. NOTE: The data set WORK._TMEANS_ has 90 observations and 5 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): ***** Get requested stats *****; MPRINT(SUMMTABLE): data _tmeans_; MPRINT(SUMMTABLE): set _tmeans_; MPRINT(SUMMTABLE): if _LABEL_ in('N', 'Mean', 'Std Dev', 'Median', 'Minimum', 'Maximum', 'Lower Quartile', 'Upper Quartile'); MPRINT(SUMMTABLE): retain _i 0 __n1-__n2 __n _m _s _t _m1 _s1 _t1 _m2 _s2 _t2 ; MPRINT(SUMMTABLE): array ns(2 ) __n1-__n2 ; MPRINT(SUMMTABLE): ***Ns; MPRINT(SUMMTABLE): array m(2 ) _m1-_m2 ; MPRINT(SUMMTABLE): *** Mean or median ***; MPRINT(SUMMTABLE): array s(2 ) _s1-_s2 ; MPRINT(SUMMTABLE): *** S.D. or min or Q1 ***; MPRINT(SUMMTABLE): array t(2 ) _t1-_t2 ; MPRINT(SUMMTABLE): *** Max or Q3 ***; MPRINT(SUMMTABLE): array c(2 ) col1-col2 ; MPRINT(SUMMTABLE): if _LABEL_='N' then do; The SAS System MPRINT(SUMMTABLE): *** Get N ***; MPRINT(SUMMTABLE): _i=_i+1; MPRINT(SUMMTABLE): *** Placement among continuous variables ***; MPRINT(SUMMTABLE): do i=1 to 2 ; MPRINT(SUMMTABLE): ns(i)=c(i); MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): __n=sum(of col1-col2 ); MPRINT(SUMMTABLE): do i=1 to 2 ; MPRINT(SUMMTABLE): m(i)=.; MPRINT(SUMMTABLE): s(i)=.; MPRINT(SUMMTABLE): t(i)=.; MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): *** end to if _LABEL_; MPRINT(SUMMTABLE): if _i<=0 then do; MPRINT(SUMMTABLE): if _LABEL_='Mean' then do; MPRINT(SUMMTABLE): *** Get Mean ***; MPRINT(SUMMTABLE): _m=col0; MPRINT(SUMMTABLE): do i=1 to 2 ; MPRINT(SUMMTABLE): m(i)=c(i); MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): if _LABEL_='Std Dev' then do; MPRINT(SUMMTABLE): *** Get S.D. ***; MPRINT(SUMMTABLE): _s=col0; MPRINT(SUMMTABLE): do i=1 to 2 ; MPRINT(SUMMTABLE): s(i)=c(i); MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): output; MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): *** end to _i<=&ICON1; MPRINT(SUMMTABLE): else do; MPRINT(SUMMTABLE): if _LABEL_='Median' then do; MPRINT(SUMMTABLE): *** Get Median ***; MPRINT(SUMMTABLE): _m=col0; MPRINT(SUMMTABLE): do i=1 to 2 ; MPRINT(SUMMTABLE): m(i)=c(i); MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): if _i<=(0 + 0) then do; MPRINT(SUMMTABLE): if _LABEL_='Minimum' then do; MPRINT(SUMMTABLE): *** Get Minimum ***; MPRINT(SUMMTABLE): _s=col0; MPRINT(SUMMTABLE): do i=1 to 2 ; MPRINT(SUMMTABLE): s(i)=c(i); MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): if _LABEL_='Maximum' then do; MPRINT(SUMMTABLE): *** Get Maximum ***; MPRINT(SUMMTABLE): _t=col0; MPRINT(SUMMTABLE): do i=1 to 2 ; MPRINT(SUMMTABLE): t(i)=c(i); MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): output; MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): *** end to if _i<=(&ICON1 + &ICON2); The SAS System MPRINT(SUMMTABLE): else do; MPRINT(SUMMTABLE): if _LABEL_='Lower Quartile' then do; MPRINT(SUMMTABLE): *** Get Q1 ***; MPRINT(SUMMTABLE): _s=col0; MPRINT(SUMMTABLE): do i=1 to 2 ; MPRINT(SUMMTABLE): s(i)=c(i); MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): if _LABEL_='Upper Quartile' then do; MPRINT(SUMMTABLE): *** Get Q3 ***; MPRINT(SUMMTABLE): _t=col0; MPRINT(SUMMTABLE): do i=1 to 2 ; MPRINT(SUMMTABLE): t(i)=c(i); MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): output; MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): *** end to else do; MPRINT(SUMMTABLE): keep _name_ __n1-__n2 __n _m _s _t _m1-_m2 _s1-_s2 _t1-_t2 _i; MPRINT(SUMMTABLE): run; NOTE: There were 90 observations read from the data set WORK._TMEANS_. NOTE: The data set WORK._TMEANS_ has 11 observations and 14 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MPRINT(SUMMTABLE): proc sort data=_labs; MPRINT(SUMMTABLE): by _i; NOTE: There were 11 observations read from the data set WORK._LABS. NOTE: The data set WORK._LABS has 11 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): proc sort data=_tmeans_; MPRINT(SUMMTABLE): by _i; MPRINT(SUMMTABLE): run; NOTE: There were 11 observations read from the data set WORK._TMEANS_. NOTE: The data set WORK._TMEANS_ has 11 observations and 14 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): ***** Final prep and assign var type *****; MPRINT(SUMMTABLE): data _summ2_; MPRINT(SUMMTABLE): attrib __var length=$32 _type length=$8; MPRINT(SUMMTABLE): merge _labs(in=in1) _tmeans_(in=in2) _kwt_(in=in4) ; MPRINT(SUMMTABLE): by _i; MPRINT(SUMMTABLE): if not(in1=in2) then put 'WARNING! Mismatched merge in _summ2_ ' in1= in2= __var1 _name_; MPRINT(SUMMTABLE): if max(in3,in4)=1 then do; MPRINT(SUMMTABLE): if in1=0 or in2=0 then put 'WARNING! Mismatched merge in _summ2_ ' in1= in2= in3= in4= __var2; MPRINT(SUMMTABLE): __var1=compress(upcase(__var1)); The SAS System MPRINT(SUMMTABLE): __var2=compress(upcase(__var2)); MPRINT(SUMMTABLE): if in1=1 and ( __var1 ne __var2 ) then put 'WARNING! Mismatched merge in _summ2_ ' __var1= __var2= _name_= ; MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): if in1 or in2 or in3 or in4 ; MPRINT(SUMMTABLE): __var=upcase(__var1); MPRINT(SUMMTABLE): if _i<=0 then _type='CON1'; MPRINT(SUMMTABLE): else if _i<=(0 + 0) then _type='CON2'; MPRINT(SUMMTABLE): else _type='CON3'; MPRINT(SUMMTABLE): if _type='CON1' and in3=0 then put 'No ANOVA F-test available for ' __var; MPRINT(SUMMTABLE): if _type in('CON2' 'CON3') and in4=0 then put 'No Mann-Whitney-Wilcoxon test available for ' __var; MPRINT(SUMMTABLE): _i2=_i; MPRINT(SUMMTABLE): *** Placement among ALL variables ***; MPRINT(SUMMTABLE): keep __var _lab __n1-__n2 __n _m _s _t _m1-_m2 _s1-_s2 _t1-_t2 _type _i2 _pval ; MPRINT(SUMMTABLE): run; NOTE: Variable in3 is uninitialized. NOTE: There were 11 observations read from the data set WORK._LABS. NOTE: There were 11 observations read from the data set WORK._TMEANS_. NOTE: There were 11 observations read from the data set WORK._KWT_. NOTE: The data set WORK._SUMM2_ has 11 observations and 17 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): ***** Delete dbs that are of no further use *****; MPRINT(SUMMTABLE): proc datasets nolist; MPRINT(SUMMTABLE): delete _labs _tmeans_ _means_ _meansall_ _tmeansall_ _tmeans1_ _kwt_ ; MPRINT(SUMMTABLE): run; NOTE: Deleting WORK._LABS (memtype=DATA). NOTE: Deleting WORK._TMEANS_ (memtype=DATA). NOTE: Deleting WORK._MEANS_ (memtype=DATA). NOTE: Deleting WORK._MEANSALL_ (memtype=DATA). NOTE: Deleting WORK._TMEANSALL_ (memtype=DATA). NOTE: Deleting WORK._TMEANS1_ (memtype=DATA). NOTE: Deleting WORK._KWT_ (memtype=DATA). MPRINT(SUMMTABLE): quit; NOTE: PROCEDURE DATASETS used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): *** end to IF (&ICON>0) THEN DO; MPRINT(SUMMTABLE): *********************************************************************; MPRINT(SUMMTABLE): ***************** ORDINAL ANALYSIS (R.L. version) *******************; MPRINT(SUMMTABLE): *********************************************************************; MPRINT(SUMMTABLE): *** end of IF (&IORD>1) THEN DO; MPRINT(SUMMTABLE): *********************************************************************; MPRINT(SUMMTABLE): ***************** PREPARE RESULTS FOR PRINTING **********************; MPRINT(SUMMTABLE): *********************************************************************; MPRINT(SUMMTABLE): ***** If no ExactTest column created yet (no cat variables or not necessary), create a black one (will be called later on) *****; MPRINT(SUMMTABLE): ***** Combine all the summ files *****; MPRINT(SUMMTABLE): data _fsumm_; MPRINT(SUMMTABLE): set _summ2_ ; MPRINT(SUMMTABLE): ExactTest=" "; The SAS System MPRINT(SUMMTABLE): label __var= 'Variable Name' __n= 'N' _type= 'Summary Type' _pval= 'P-value' _lab= 'Variable' _m= "Total Statistic 1" _s= "Total Statistic 2" _t= "Total Statistic 3" __n1= "0 N" _m1= "0 Statistic 1" _s1= "0 Statistic 2" _t1= "0 Statistic 3" __n2= "1 N" _m2= "1 Statistic 1" _s2= "1 Statistic 2" _t2= "1 Statistic 3" ; MPRINT(SUMMTABLE): run; NOTE: There were 11 observations read from the data set WORK._SUMM2_. NOTE: The data set WORK._FSUMM_ has 11 observations and 18 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MPRINT(SUMMTABLE): ***** If order list provided, create _list with order for sorting *****; MPRINT(SUMMTABLE): data _list; MPRINT(SUMMTABLE): attrib __var length=$32 _list length=8; MPRINT(SUMMTABLE): keep __var _list; MPRINT(SUMMTABLE): __var=upcase("masp1"); MPRINT(SUMMTABLE): _list=1; MPRINT(SUMMTABLE): output; MPRINT(SUMMTABLE): __var=upcase("masp2"); MPRINT(SUMMTABLE): _list=2; MPRINT(SUMMTABLE): output; MPRINT(SUMMTABLE): __var=upcase("masp3"); MPRINT(SUMMTABLE): _list=3; MPRINT(SUMMTABLE): output; MPRINT(SUMMTABLE): __var=upcase("C4"); MPRINT(SUMMTABLE): _list=4; MPRINT(SUMMTABLE): output; MPRINT(SUMMTABLE): __var=upcase("C4cneo"); MPRINT(SUMMTABLE): _list=5; MPRINT(SUMMTABLE): output; MPRINT(SUMMTABLE): __var=upcase("c4c_c4_ratio"); MPRINT(SUMMTABLE): _list=6; MPRINT(SUMMTABLE): output; MPRINT(SUMMTABLE): __var=upcase("C3"); MPRINT(SUMMTABLE): _list=7; MPRINT(SUMMTABLE): output; MPRINT(SUMMTABLE): __var=upcase("C3bc"); MPRINT(SUMMTABLE): _list=8; MPRINT(SUMMTABLE): output; MPRINT(SUMMTABLE): __var=upcase("tcc"); MPRINT(SUMMTABLE): _list=9; MPRINT(SUMMTABLE): output; MPRINT(SUMMTABLE): run; NOTE: The data set WORK._LIST has 9 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): proc sort data=_list; MPRINT(SUMMTABLE): by __var; NOTE: There were 9 observations read from the data set WORK._LIST. NOTE: The data set WORK._LIST has 9 observations and 2 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds The SAS System MPRINT(SUMMTABLE): proc sort data=_fsumm_; MPRINT(SUMMTABLE): by __var; MPRINT(SUMMTABLE): run; NOTE: There were 11 observations read from the data set WORK._FSUMM_. NOTE: The data set WORK._FSUMM_ has 11 observations and 18 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): data amp; MPRINT(SUMMTABLE): merge _fsumm_(in=inf) _list(in=inl); MPRINT(SUMMTABLE): by __var; MPRINT(SUMMTABLE): if inl>inf then put 'WARNING! ' __var 'is in the LIST parameter, but was not analyzed.'; MPRINT(SUMMTABLE): if inf; MPRINT(SUMMTABLE): if inl=0 then _list=9+1; MPRINT(SUMMTABLE): run; NOTE: There were 11 observations read from the data set WORK._FSUMM_. NOTE: There were 9 observations read from the data set WORK._LIST. NOTE: The data set WORK.AMP has 11 observations and 19 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MPRINT(SUMMTABLE): proc sort data=amp; MPRINT(SUMMTABLE): by _i2; MPRINT(SUMMTABLE): run; NOTE: There were 11 observations read from the data set WORK.AMP. NOTE: The data set WORK.AMP has 11 observations and 19 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): proc datasets nolist; MPRINT(SUMMTABLE): delete _list; MPRINT(SUMMTABLE): run; NOTE: Deleting WORK._LIST (memtype=DATA). MPRINT(SUMMTABLE): ***** Delete Dbs that are of no futher use *****; NOTE: PROCEDURE DATASETS used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): proc datasets nolist; MPRINT(SUMMTABLE): delete _summ2_ _fsumm_ ; MPRINT(SUMMTABLE): run; NOTE: Deleting WORK._SUMM2_ (memtype=DATA). NOTE: Deleting WORK._FSUMM_ (memtype=DATA). MPRINT(SUMMTABLE): quit; The SAS System NOTE: PROCEDURE DATASETS used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): *********************************************************************; MPRINT(SUMMTABLE): ***************** AD-HOC COMPARISONS (R.L) **********************; MPRINT(SUMMTABLE): *********************************************************************; MPRINT(SUMMTABLE): *** end to IF &LEVELS>2 and &ADHOC=1; MPRINT(SUMMTABLE): *********************************************************************; MPRINT(SUMMTABLE): ********************* Odds Ratios (R.L) **************************; MPRINT(SUMMTABLE): *********************************************************************; MPRINT(SUMMTABLE): *** end to IF &LEVELS=2 AND &ODDSRATIOS=1; MPRINT(SUMMTABLE): *********************************************************************; MPRINT(SUMMTABLE): ***************** SORT AND PRINT IF APPLICABLE **********************; MPRINT(SUMMTABLE): *********************************************************************; MPRINT(SUMMTABLE): ***** Sorty as requested *****; MPRINT(SUMMTABLE): proc sort data=amp; MPRINT(SUMMTABLE): by _list _i2; MPRINT(SUMMTABLE): run; NOTE: There were 11 observations read from the data set WORK.AMP. NOTE: The data set WORK.AMP has 11 observations and 19 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MPRINT(SUMMTABLE): ***** Clear results window *****; MPRINT(SUMMTABLE): *dm 'odsresults' clear; MPRINT(SUMMTABLE): ***** Print &out, if requested *****; MPRINT(SUMMTABLE): *********************************************************************; MPRINT(SUMMTABLE): *****************Create RTF file for printing (R.L)******************; MPRINT(SUMMTABLE): *********************************************************************; MPRINT(SUMMTABLE): ***** +/- sign for mean +/- sd *****; MPRINT(SUMMTABLE): ***** Total N to flag variables with missing values *****; MPRINT(SUMMTABLE): proc sql noprint; MPRINT(SUMMTABLE): select n(___class) into :TOTALN from _tempd_; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): data _null_; MPRINT(SUMMTABLE): call symput('TOTALN', trim(left( 102))); MPRINT(SUMMTABLE): run; NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 45:6 NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(SUMMTABLE): ***** Create &RTFOut file *****; MPRINT(SUMMTABLE): data amp; MPRINT(SUMMTABLE): set amp; The SAS System MPRINT(SUMMTABLE): ***** Create labels *****; MPRINT(SUMMTABLE): _varlab=_lab; MPRINT(SUMMTABLE): _lab2=_lab; MPRINT(SUMMTABLE): _varlab2=_lab; MPRINT(SUMMTABLE): if _i2=floor(_i2) then do; MPRINT(SUMMTABLE): ***** _varlab will have flag for missing values *****; MPRINT(SUMMTABLE): if 102 ne __n then _varlab=trim(_lab)||"*"; MPRINT(SUMMTABLE): else _varlab=_lab; MPRINT(SUMMTABLE): if _type= 'CON1' then do; MPRINT(SUMMTABLE): if 1=1 then do; MPRINT(SUMMTABLE): _lab2=trim(_lab)||", Mean ± SD"; MPRINT(SUMMTABLE): _varlab2=trim(_varlab)||", Mean ± SD"; MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): else do; MPRINT(SUMMTABLE): _lab2=trim(_lab)||", Mean (SD)"; MPRINT(SUMMTABLE): _varlab2=trim(_varlab)||", Mean (SD)"; MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): else if _type= 'CON2' then do; MPRINT(SUMMTABLE): _lab2=trim(_lab)||", Median (Min, Max)"; MPRINT(SUMMTABLE): _varlab2=trim(_varlab)||", Median (Min, Max)"; MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): else if _type= 'CON3' then do; MPRINT(SUMMTABLE): _lab2=trim(_lab)||", Median (Q1, Q3)"; MPRINT(SUMMTABLE): _varlab2=trim(_varlab)||", Median (Q1, Q3)"; MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): else if _type in ('CAT1' 'CAT2' 'ORD1') then do; MPRINT(SUMMTABLE): _lab2=trim(_lab)||", No. (%)"; MPRINT(SUMMTABLE): _varlab2=trim(_varlab)||", No. (%)"; MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): *** end to if _i2=floor(_i2) then do; MPRINT(SUMMTABLE): ***** If requested, create column with missing *****; MPRINT(SUMMTABLE): ***** If Overall column requested, format stats *****; MPRINT(SUMMTABLE): informat Overall $30.; MPRINT(SUMMTABLE): if _type = 'CAT1' or (_type in ('CAT2' 'ORD1') and _i2 ne floor(_i2)) then Overall= compress(put(_m, __Countf.) || ' (' || put(_s, __Pctf.) || ')' ) ; MPRINT(SUMMTABLE): if _type = 'CON1' then do; MPRINT(SUMMTABLE): Overall= compress(put(_m, __Estf.) || " ±" || put(_s, __Estf.) ) ; MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): if _type = 'CON3' then Overall= compress(put(_m, __Estf.) || ' [' || put(_s, __Estf.) || ', '|| put(_t, __Estf.) || ']' ) ; MPRINT(SUMMTABLE): ***** Summary for groups *****; MPRINT(SUMMTABLE): informat A1 $30.; MPRINT(SUMMTABLE): if _type = 'CAT1' or (_type in ('CAT2' 'ORD1') and _i2 ne floor(_i2)) then A1= compress(put(_m1, __Countf.) || ' (' || put(_s1, __Pctf.) || ')' ) ; MPRINT(SUMMTABLE): if _type = 'CON1' then do; MPRINT(SUMMTABLE): A1= compress(put(_m1, __Estf.) || " ±" || put(_s1, __Estf.) ) ; MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): if _type = 'CON3' then A1= compress(put(_m1, __Estf.) || ' [' || put(_s1, __Estf.) || ', '|| put(_t1, __Estf.) || ']' ) ; MPRINT(SUMMTABLE): ***** If all missing in a group then change to ---- *****; MPRINT(SUMMTABLE): if _type not in ('CAT2' 'ORD1') and __n1=0 then A1="----"; MPRINT(SUMMTABLE): else if _type in ('CAT2' 'ORD1') and _i2 ne floor(_i2) and __n1=0 then A1="----"; MPRINT(SUMMTABLE): informat A2 $30.; MPRINT(SUMMTABLE): if _type = 'CAT1' or (_type in ('CAT2' 'ORD1') and _i2 ne floor(_i2)) then A2= compress(put(_m2, __Countf.) || ' (' || put(_s2, __Pctf.) || ')' ) ; MPRINT(SUMMTABLE): if _type = 'CON1' then do; The SAS System MPRINT(SUMMTABLE): A2= compress(put(_m2, __Estf.) || " ±" || put(_s2, __Estf.) ) ; MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): if _type = 'CON3' then A2= compress(put(_m2, __Estf.) || ' [' || put(_s2, __Estf.) || ', '|| put(_t2, __Estf.) || ']' ) ; MPRINT(SUMMTABLE): ***** If all missing in a group then change to ---- *****; MPRINT(SUMMTABLE): if _type not in ('CAT2' 'ORD1') and __n2=0 then A2="----"; MPRINT(SUMMTABLE): else if _type in ('CAT2' 'ORD1') and _i2 ne floor(_i2) and __n2=0 then A2="----"; MPRINT(SUMMTABLE): *** end to DO LLOOP=1 TO &LEVELS; MPRINT(SUMMTABLE): ***** For cat2 and ord1 variables want N to appear on 1st line only; MPRINT(SUMMTABLE): if _i2 ne floor(_i2) then __n=.; MPRINT(SUMMTABLE): ***** For cat2 and ord1 variables want p on 1st line only *****; MPRINT(SUMMTABLE): if _i2=floor(_i2) then _p=_pval; MPRINT(SUMMTABLE): else _p=.; MPRINT(SUMMTABLE): if _i2 ne floor(_i2) then ExactTest=" "; MPRINT(SUMMTABLE): ***** For cat2 and ord1 variables want n on 1st line only *****; MPRINT(SUMMTABLE): array _nloop_ __n1-__n2 __n __missing __missing1-__missing2 ; MPRINT(SUMMTABLE): if _type in ('CAT2' 'ORD1') then do over _nloop_; MPRINT(SUMMTABLE): if _i2 ne floor(_i2) then _nloop_=.; MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): ***** If PRINTPTYPE=1 then add superscripts to ps *****; MPRINT(SUMMTABLE): ***** If ad-hoc performed, flag sig. differences *****; MPRINT(SUMMTABLE): ***** If ORs requested, put reference in the first CAT2 level *****; MPRINT(SUMMTABLE): ***** Data to store for %OUTSUMMTABLE USE *****; MPRINT(SUMMTABLE): if _N_=1 then do; MPRINT(SUMMTABLE): _nlev_ = 2 ; MPRINT(SUMMTABLE): _NTotal_ = 102; MPRINT(SUMMTABLE): _label1 = "0"; MPRINT(SUMMTABLE): _N1 = 80; MPRINT(SUMMTABLE): _label2 = "1"; MPRINT(SUMMTABLE): _N2 = 22; MPRINT(SUMMTABLE): _ncol_=0; MPRINT(SUMMTABLE): _misscol_=0; MPRINT(SUMMTABLE): _subset_=""; MPRINT(SUMMTABLE): _colpct_=1; MPRINT(SUMMTABLE): _adhoc_=0; MPRINT(SUMMTABLE): end; MPRINT(SUMMTABLE): ***** empty column for use in proc report *****; MPRINT(SUMMTABLE): _empty=' '; MPRINT(SUMMTABLE): keep _lab2 __var _type __n1-__n2 __n Overall A1-A2 _p _i2 _list _pval ExactTest _lab _varlab _varlab2 _nlev_ _NTotal_ _label1-_label2 _N1-_N2 _empty _subset_ _colpct_ _ncol_ _misscol_ _adhoc_; MPRINT(SUMMTABLE): label _lab2= "Variable label 2" _varlab2= "Variable label 2.2" _lab= "Variable label 1" _varlab= "Variable label 1.2" __n= "Overall N" _i2= "Input variable order" _list= "List variable order" _nlev_= "# of groups" _NTotal_= "Sample size" _empty= "Empty column for report" _subset_= "Subset of population used" _colpct_= "ColPct option for outsummtable" _ncol_= "NCol option for outsummtable" _misscol_= "MissCol option for outsummtable" _adhoc_= "AdHoc option for outsummtable" Overall= "Overall Summary" _pval= "p-value for sorting" ExactTest= "Exact test used" _p= "p-value" A1= "0 Summary" _label1= "Group 1 label" _N1= "0 size" A2= "1 Summary" _label2= "Group 2 label" _N2= "1 size" ; MPRINT(SUMMTABLE): run; NOTE: There were 11 observations read from the data set WORK.AMP. NOTE: The data set WORK.AMP has 11 observations and 29 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MPRINT(SUMMTABLE): ***** Order columns for easier navigation *****; MPRINT(SUMMTABLE): data amp; MPRINT(SUMMTABLE): retain _lab2 __var _type __n1-__n2 __n Overall A1-A2 _p _i2 _list _pval ExactTest _lab _varlab _varlab2 _nlev_ The SAS System _NTotal_ _label1-_label2 _N1-_N2 _subset_ _colpct_ _ncol_ _misscol_ _adhoc_ _empty; MPRINT(SUMMTABLE): set amp; MPRINT(SUMMTABLE): run; NOTE: There were 11 observations read from the data set WORK.AMP. NOTE: The data set WORK.AMP has 11 observations and 29 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds Note the part with missing variables is expected.     Then when i click stop i get this:   MPRINT(SUMMTABLE): ***** Print &RTFOUT if requested *****; MPRINT(SUMMTABLE): proc print data=amp l; MPRINT(SUMMTABLE): id _lab; MPRINT(SUMMTABLE): var __n Overall A1 A2 _p ; MPRINT(SUMMTABLE): format _p Pvaluef. __n __countf.; MPRINT(SUMMTABLE): run; ERROR: An exception has been encountered. Please contact technical support and provide them with the following traceback information: The SAS task name is [PRINT (2] Segmentation Violation Traceback of the Exception: /sas/SASHome/compute/SASFoundation/9.4/sasexe/sas(+0x1666ce) [0x564cfe48e6ce] /sas/SASHome/compute/SASFoundation/9.4/sasexe/sas(+0x4e7df) [0x564cfe3767df] /sas/SASHome/compute/SASFoundation/9.4/sasexe/tkmk.so(bkt_signal_handler+0x144) [0x2abf4da2fa44] /lib64/libpthread.so.0(+0xf5e0) [0x2abf4c6dc5e0] /sas/SASHome/compute/SASFoundation/9.4/sasexe/sasods(+0x1322f4) [0x2abf932542f4] /sas/SASHome/compute/SASFoundation/9.4/sasexe/sasods(odstxt+0x1fb) [0x2abf9326a48b] /sas/SASHome/compute/SASFoundation/9.4/sasexe/sasprt7(+0xd586) [0x2abfb71fc586] /sas/SASHome/compute/SASFoundation/9.4/sasexe/sasprt7(+0x63d6) [0x2abfb71f53d6] /sas/SASHome/compute/SASFoundation/9.4/sasexe/sasods(wobmth+0x57) [0x2abf93393747] /sas/SASHome/compute/SASFoundation/9.4/sasexe/sasods(+0x93af2) [0x2abf931b5af2] /sas/SASHome/compute/SASFoundation/9.4/sasexe/sasods(+0x92dd0) [0x2abf931b4dd0] /sas/SASHome/compute/SASFoundation/9.4/sasexe/sasprint(wobmth+0x57) [0x2abfb6fd36a7] /sas/SASHome/compute/SASFoundation/9.4/sasexe/sasprint(+0x6200) [0x2abfb6fcc200] /sas/SASHome/compute/SASFoundation/9.4/sasexe/sas(vvtentr+0x18a) [0x564cfe37633a] /lib64/libpthread.so.0(+0x7e25) [0x2abf4c6d4e25] /lib64/libc.so.6(clone+0x6d) [0x2abf4d11e34d] NOTE: The SAS System stopped processing this step because of errors.   ... View more

I can run other code including other macros fine. ... View more

no errors in log for the macro itself. code where i call the macrol never finishes so can't say if there are errors ... View more

I did eventually got the code to work by using the dynamic variable. My issue now is more severe.   sas cant display any results from any of my previously working programs. since this is a different issue i created a new topic. ... View more

  the format is not corrected on my ods output either. im on SAS 9.4   ods escapechar='^'; proc format; value highlowfmt 1 = '^{unicode "2264"x} median ' 2 = '> median'; run;   ods noproctitle; ods startpage=now; ods rtf style=rtf file="H:\NSTI\lifetests.rtf" image_dpi=300 ; ods graphics / reset noborder width=8.5cm ; ods listing style=statistical ; ods select SurvivalPlot (persist); %SurvivalTemplateRestore; %let TitleText0 = "MASP-1"; %let TitleText1 = &titletext0 " for " STRATUMID; %let TitleText2 = &titletext0; %SurvivalTemplate;ods select SurvivalPlot (persist); Proc lifetest data= nf.kohorte2 plots=(survival(test nocensor)) notable; time Time_to_death_90Days*Mortality_90_days(0) ; strata group_masp1; format group_masp1 highlowfmt.; run; ... View more

the sas version is 9.4   If it stores instructions that ODS will interpret to generate a unicode character, then it should display correctly on my ODS rtf output? it doesn't   here the full code: ods escapechar='^'; proc format; value highlowfmt 1 = '^{unicode "2264"x} median ' 2 = '> median'; run; %macro SurvivalTemplateRestore; %global TitleText0 TitleText1 TitleText2 yOptions xOptions tips groups bandopts gridopts blockopts censored censorstr; %let TitleText0 = METHOD " Survival Estimate"; %let TitleText1 = &titletext0 " for " STRATUMID; %let TitleText2 = &titletext0 "s"; /* plural: Survival Estimates */ %let yOptions = label="Survival Probability" shortlabel="Survival" linearopts=(viewmin=0 viewmax=1 tickvaluelist=(0 .2 .4 .6 .8 1.0)); %let xOptions = shortlabel=XNAME offsetmin=.05 linearopts=(viewmax=MAXTIME tickvaluelist=XTICKVALS tickvaluefitpolicy=XTICKVALFITPOL); %let tips = rolename=(_tip1=ATRISK _tip2=EVENT) tip=(y x Time _tip1 _tip2); %let groups = group=STRATUM index=STRATUMNUM; %let bandopts = &groups modelname="Survival"; %let gridopts = autoalign=( bottomright) border=false BackgroundColor=GraphWalls:Color Opaque=false; %let blockopts = repeatedvalues=true valuehalign=start valuefitpolicy=truncate labelposition=left labelattrs=GRAPHVALUETEXT valueattrs=GRAPHDATATEXT(size=7pt) includemissingclass=false; %let censored = markerattrs=(symbol=plus); %let censorstr = "+ Censored"; %macro SurvivalTemplate; proc template; define statgraph Stat.Lifetest.Graphics.ProductLimitSurvival; dynamic NStrata xName plotAtRisk plotCL plotHW plotEP labelCL %if %nrbquote(&censored) ne %then plotCensored; labelHW labelEP maxTime xtickVals xtickValFitPol method StratumID classAtRisk plotBand plotTest GroupName yMin Transparency SecondTitle TestName pValue; BeginGraph; if (NSTRATA=1) if (EXISTS(STRATUMID)) entrytitle &titletext1; else entrytitle &titletext0; endif; if (PLOTATRISK) entrytitle "with Number of Subjects at Risk" / textattrs= GRAPHVALUETEXT; endif; layout overlay / xaxisopts=(&xoptions) yaxisopts=(&yoptions); %singlestratum endlayout; else entrytitle &titletext2; if (EXISTS(SECONDTITLE)) entrytitle SECONDTITLE / textattrs=GRAPHVALUETEXT; endif; layout overlay / xaxisopts=(&xoptions) yaxisopts=(&yoptions); %multiplestrata endlayout; endif; EndGraph; end; run; %mend; %macro entry_p; if (PVALUE < .0001) entry TESTNAME " p " eval (PUT(PVALUE, PVALUE6.4)); else entry TESTNAME " p=" eval (PUT(PVALUE, PVALUE6.4)); endif; %mend; %macro SingleStratum; if (PLOTHW=1 AND PLOTEP=0) bandplot LimitUpper=HW_UCL LimitLower=HW_LCL x=TIME / modelname="Survival" fillattrs=GRAPHCONFIDENCE name="HW" legendlabel=LABELHW; endif; if (PLOTHW=0 AND PLOTEP=1) bandplot LimitUpper=EP_UCL LimitLower=EP_LCL x=TIME / modelname="Survival" fillattrs=GRAPHCONFIDENCE name="EP" legendlabel=LABELEP; endif; if (PLOTHW=1 AND PLOTEP=1) bandplot LimitUpper=HW_UCL LimitLower=HW_LCL x=TIME / modelname="Survival" fillattrs=GRAPHDATA1 datatransparency=.55 name="HW" legendlabel=LABELHW; bandplot LimitUpper=EP_UCL LimitLower=EP_LCL x=TIME / modelname="Survival" fillattrs=GRAPHDATA2 datatransparency=.55 name="EP" legendlabel=LABELEP; endif; if (PLOTCL=1) if (PLOTHW=1 OR PLOTEP=1) bandplot LimitUpper=SDF_UCL LimitLower=SDF_LCL x=TIME / modelname="Survival" display=(outline) outlineattrs=GRAPHPREDICTIONLIMITS name="CL" legendlabel=LABELCL; else bandplot LimitUpper=SDF_UCL LimitLower=SDF_LCL x=TIME / modelname="Survival" fillattrs=GRAPHCONFIDENCE name="CL" legendlabel=LABELCL; endif; endif; stepplot y=SURVIVAL x=TIME / name="Survival" &tips legendlabel="Survival"; if (PLOTCENSORED=1) scatterplot y=CENSORED x=TIME / &censored name="Censored" legendlabel="Censored"; endif; if (PLOTCL=1 OR PLOTHW=1 OR PLOTEP=1) discretelegend "Censored" "CL" "HW" "EP" / location=outside halign=center; else if (PLOTCENSORED=1) discretelegend "Censored" / location=inside autoalign=(topright bottomleft); endif; endif; if (PLOTATRISK=1) innermargin / align=bottom; blockplot x=TATRISK block=ATRISK / display=(values) &blockopts; endinnermargin; endif; %mend; %macro MultipleStrata; if (PLOTHW) bandplot LimitUpper=HW_UCL LimitLower=HW_LCL x=TIME / &bandopts datatransparency=Transparency; endif; if (PLOTEP) bandplot LimitUpper=EP_UCL LimitLower=EP_LCL x=TIME / &bandopts datatransparency=Transparency; endif; if (PLOTCL) if (PLOTBAND) bandplot LimitUpper=SDF_UCL LimitLower=SDF_LCL x=TIME / &bandopts display=(outline); else bandplot LimitUpper=SDF_UCL LimitLower=SDF_LCL x=TIME / &bandopts datatransparency=Transparency; endif; endif; stepplot y=SURVIVAL x=TIME / &groups name="Survival" &tips; if (PLOTCENSORED) scatterplot y=CENSORED x=TIME / &groups &censored; endif; if (PLOTATRISK) innermargin / align=bottom; blockplot x=TATRISK block=ATRISK / class=CLASSATRISK display=(label values) &blockopts; endinnermargin; endif; DiscreteLegend "Survival" / across=1 location=inside autoalign=(TopRight BottomLeft Top Bottom); if (PLOTCENSORED) if (PLOTTEST) layout gridded / rows=2 &gridopts; entry &censorstr; %entry_p endlayout; else layout gridded / rows=1 &gridopts; entry &censorstr; endlayout; endif; else if (PLOTTEST) layout gridded / rows=1 &gridopts; %entry_p endlayout; endif; endif; %mend; %SurvivalTemplate %mend; ods noproctitle; ods startpage=now; ods rtf style=rtf file="H:\NSTI\lifetests.rtf" image_dpi=300 ; ods graphics / reset noborder width=8.5cm ; ods listing style=statistical ; ods select SurvivalPlot (persist); %SurvivalTemplateRestore; %let TitleText0 = "MASP-1"; %let TitleText1 = &titletext0 " for " STRATUMID; %let TitleText2 = &titletext0; %SurvivalTemplate; ods select SurvivalPlot (persist); Proc lifetest data= nf.kohorte2 plots=(survival(test nocensor)) notable; time Time_to_death_90Days*Mortality_90_days(0) ; strata group_masp1; format group_masp1 highlowfmt.; run; %SurvivalTemplateRestore;   and the output:   ... View more

Im on SAS enterprise guide 7.15 HF7 (7.100.5.6177) (64-bit) Changing the escapechar like the above doesn't work ... View more

on the same computer, the code works in base SAS 9.4, but it doesn't work in sas enterprise guide. this is really strange to me ... View more

i think its an encoding issue.   ... View more

  It outputs "(*ESC*){unicode "2264"x} median" as the formatted value-   code:   proc format; value highlowfmt 1 = '(*ESC*){unicode "2264"x} median ' 2 = '> median'; run; data A; format x highlowfmt.; input x @@; datalines; 1 2 2 1 1 1 ; proc print; run;   log: 1 The SAS System 10:02 Tuesday, July 30, 2019 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Program (7)'; 4 %LET _CLIENTPROCESSFLOWNAME='Process Flow'; 5 %LET _CLIENTPROJECTPATH='H:\Dokumenter\NekrFasc\Nekrotiserende Fascitis Kohorte.egp'; 6 %LET _CLIENTPROJECTPATHHOST='PC005760'; 7 %LET _CLIENTPROJECTNAME='Nekrotiserende Fascitis Kohorte.egp'; 8 %LET _SASPROGRAMFILE=''; 9 %LET _SASPROGRAMFILEHOST=''; 10 11 ODS _ALL_ CLOSE; 12 OPTIONS DEV=PNG; 13 FILENAME EGSR TEMP; 14 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR 15 STYLE=Journal1a 16 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/Journal1a.css") 17 NOGTITLE 18 NOGFOOTNOTE 19 GPATH=&sasworklocation 20 ENCODING=UTF8 21 options(rolap="on") 22 ; NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 23 24 proc format; 25 value highlowfmt 26 1 = '(*ESC*){unicode "2264"x} median ' 27 2 = '> median'; NOTE: Format HIGHLOWFMT is already on the library WORK.FORMATS. NOTE: Format HIGHLOWFMT has been output. 28 run; NOTE: PROCEDURE FORMAT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 29 30 data A; 31 format x highlowfmt.; 32 input x @@; 33 datalines; NOTE: SAS went to a new line when INPUT statement reached past the end of a line. NOTE: The data set WORK.A has 6 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 35 ; 36 37 proc print; run; NOTE: There were 6 observations read from the data set WORK.A. NOTE: PROCEDURE PRINT used (Total process time): real time 0.03 seconds cpu time 0.00 seconds 2 The SAS System 10:02 Tuesday, July 30, 2019   38 39 %LET _CLIENTTASKLABEL=; 40 %LET _CLIENTPROCESSFLOWNAME=; 41 %LET _CLIENTPROJECTPATH=; 42 %LET _CLIENTPROJECTPATHHOST=; 43 %LET _CLIENTPROJECTNAME=; 44 %LET _SASPROGRAMFILE=; 45 %LET _SASPROGRAMFILEHOST=; 46 47 ;*';*";*/;quit;run; 48 ODS _ALL_ CLOSE; 49 50 51 QUIT; RUN; 52   output:   x (*ESC*){unicode "2264"x} median > median > median (*ESC*){unicode "2264"x} median (*ESC*){unicode "2264"x} median (*ESC*){unicode "2264"x} median ... View more