BookmarkSubscribeRSS Feed
Mrksk
Obsidian | Level 7

Running the macro Summmacro available here: http://www.sascommunity.org/wiki/Summtable

Previously it has worked fine. now code is stuck on proc print.

 

Code that has previously worked fine now when I call the macro (from work library) im stuck on proc print.

if i stop the procedure at start another procedure it will stop on "running".

 

any idea Whats going on?

 

9 REPLIES 9
PaigeMiller
Diamond | Level 26

Are there errors in the LOG?

--
Paige Miller
Mrksk
Obsidian | Level 7
no errors in log for the macro itself.
code where i call the macrol never finishes so can't say if there are errors
Mrksk
Obsidian | Level 7
I can run other code including other macros fine.
ballardw
Super User

@Mrksk wrote:
I can run other code including other macros fine.

When attempting to debug macro behavior the minimum should be to set:

 

options mprint;

 

Run the code.

 

Copy all the generated code and messages from the log and paste into a code box opened using the forum's {I} or "running man" icon.

The code box is important to preserve formatting of any warning or error messages and maintain readability.

 

Otherwise about all we can say is that if the program ran before that you data has a problem.

Mrksk
Obsidian | Level 7

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.

 

Mrksk
Obsidian | Level 7
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.
ballardw
Super User

@Mrksk wrote:
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.

 

 

 

"Suddenly doesn't work" if the code has not changed has the most likely cause as something in the actual data, missing values or out or expected range are my first suspects.

 

Next would be an environment change. Since you say you change to a server environment then look at things related to permissions and Paths. It is almost certain that any output path you used locally won't work unchanged on a remote server. And if the path was verified to match what the server would expect then you likely need to ensure that you have write permissions for the destination. Another element to investigate is working space. You may have exceeded your work space or destination folder file size limits.

 

I am not going to fight with the forums horizontal scroll to make any guesses about the text that goes too far to the right to read easily, so some of the text that is there may be part of the issue but can't point to it. (The problem is having to go to the bottom of the window to scroll and then finding the place needed after that with such a long post. This might require attaching a text file of the log for readability.)

 

I would actually look at the step(s) following that proc print. I suspect they are more likely to cause a problem than printing a data set with that small number of observations and variables. Typically something "hanging" doesn't actually text like the proc print to the log.

HelenMM
Calcite | Level 5

I just recently had this problem - my issue was any procedure that printed output. Try typing end; in the command bar while on the output window - I was able to force my way through the print parts that way, but ultimately it was an environment setting.

 

I opened a second instance of SAS. The second instance had to use a default profile since I was already using my profile in the first instance (message NOTE: Unable to open SASUSER.PROFILE. WORK.PROFILE will be opened instead.NOTE: All profile changes will be lost at the end of the session.). Printing procedures worked as expected in the second instance of SAS - and the program ran faster in the second instance for some reason. From there I was able to compare my environment settings to see what was different between the 2 profiles -- which was a waste of time. 🙂 It was a preference that had been reset somehow. I unclicked "Create listing" within Tools->Preferences->Results and that worked for me. But try a second SAS instance and then at least you will know if a saved profile\enviro setting is the issue. 

HelenMM
Calcite | Level 5

I just recently had this problem - my issue was any procedure that printed output. Try typing end; in the command bar while on the output window - I was able to force my way through the print parts that way, but ultimately it was an preference setting.

 

I opened a second instance of SAS. The second instance had to use a default profile since I was already using my profile in the first instance (NOTE: Unable to open SASUSER.PROFILE. WORK.PROFILE will be opened instead.NOTE: All profile changes will be lost at the end of the session.). Printing procedures worked as expected in the second instance of SAS - and the program ran waayyy faster in the second instance for some reason. From there I was able to compare my environment settings to see what was different between the 2 profiles -- which was a waste of time. 🙂 It ended up being a preference that had been reset somehow. I unclicked "Create listing" within Tools->Preferences->Results and that worked for me. But try a second SAS instance and then at least you will know if a saved profile\enviro setting is the issue. Even though I went through too many environment setting, that is how I found the Preference difference.

sas-innovate-2024.png

📢

ANNOUNCEMENT

The early bird rate has been extended! Register by March 18 for just $695 - $100 off the standard rate.

 

Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events. 

 

Register now!

From SAS Users blog
Want more? Visit our blog for more articles like these.
5 Steps to Your First Analytics Project Using SAS

For SAS newbies, this video is a great way to get started. James Harroun walks through the process using SAS Studio for SAS OnDemand for Academics, but the same steps apply to any analytics project.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 9 replies
  • 1611 views
  • 0 likes
  • 4 in conversation