Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Options
- RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Obsidian | Level 7
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 09-06-2019 10:28 AM
(2214 views)
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?
8 REPLIES 8
Diamond | Level 26
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Are there errors in the LOG?
--
Paige Miller
Paige Miller
Obsidian | Level 7
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
no errors in log for the macro itself.
code where i call the macrol never finishes so can't say if there are errors
code where i call the macrol never finishes so can't say if there are errors
Obsidian | Level 7
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
I can run other code including other macros fine.
Super User
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
@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.
Obsidian | Level 7
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
Obsidian | Level 7
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
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.
Super User
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
@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.
Calcite | Level 5
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
SAS Innovate 2025: Call for Content
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Upcoming Events
- Ask the Expert: Why SQL Dictionary Tables are a Game-Changer for Data Scientists | 03-Oct-2024
- NJSUG Presents: Microsoft Excel Proficiency with SAS®: Unlocking Data Insights and Dynamic Reporting | 03-Oct-2024
- Montreal SAS User Group (MONSUG) Meeting - Fall | 09-Oct-2024
- Ask the Expert: Wie nutze ich das volle Potenzial von SAS® Intelligent Decisioning? | 10-Oct-2024
- Modernize to SAS® Viya® with HPE GreenLake High-Performance, On-Premises, Pay-As-You-Go Solution | 10-Oct-2024
- SAS Bowl XLIV, Model Cards | 16-Oct-2024
- Ask the Expert: Fostering Trustworthy AI Using a Model Card | 17-Oct-2024
Mastering the WHERE Clause in PROC SQL
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.
Discussion stats
-
8 replies
-
09-06-2019 10:28 AM
-
2215 views
-
0 likes
-
4 in conversation
-
