Hello!
This is the log after adding the missing ;
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
NOTE: ODS statements in the SAS Studio environment may disable some output features.
73
74 libname mc '/folders/myfolders/research';
NOTE: Libref MC was successfully assigned as follows:
Engine: V9
Physical Name: /folders/myfolders/research
75
76 proc import out= mc.complieddata datafile= "/folders/myfolders/Research/Master List 07062020 SAS.xlsx"
77 DBMS=xlsx Replace;
77 ! SHEET="Data Complied From Both Studies";
78 GETNAMES=YES;
79 RUN;
NOTE: Variable Name Change. Preg Group -> Preg_Group
NOTE: Variable Name Change. Subject number -> Subject_number
NOTE: Variable Name Change. Progestrone nmol/L -> Progestrone_nmol_L
NOTE: Variable Name Change. Screen/Incl/Excl -> Screen_Incl_Excl
NOTE: Variable Name Change. Enrollment Date -> Enrollment_Date
NOTE: Variable Name Change. GA in weeks -> GA_in_weeks
NOTE: Variable Name Change. F/U Date 16th Wk -> F_U_Date_16th_Wk
NOTE: Variable Name Change. F/U Date 40th Wk -> F_U_Date_40th_Wk
NOTE: Variable Name Change. 16 week miscarriage -> _16_week_miscarriage
NOTE: Variable Name Change. 40 week miscarriage -> _40_week_miscarriage
NOTE: Variable Name Change. Chromosomal Aberration (Y/N) -> VAR20
NOTE: Variable Name Change. Chromosomal Aberration (Descript -> Chromosomal_Aberration__Descript
NOTE: Variable Name Change. Threatened Miscarriage (Y/N) -> VAR22
NOTE: Variable Name Change. Spontaneous Miscarriage (Y/N) -> VAR23
NOTE: Variable Name Change. IUGS & YS (Y/N) -> VAR24
NOTE: Variable Name Change. Completed? -> Completed_
NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with
options MSGLEVEL=I.
NOTE: The import data set has 168 observations and 27 variables.
NOTE: MC.COMPLIEDDATA data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.21 seconds
cpu time 0.14 seconds
80
81 data import; set research.import;
82
83 if Preg_Group in ('Miscarriage' 'Normal');
84
85 if BMI >28 then BMI_cat = 'BMI >28 ';
86 else if 19 <= BMI < 23 then BMI_cat = '19<=BMI<23';
87 else BMI_cat = 'BMI Other ';
88
89 if Age <32 then Age_cat = 'Age <32 ';
90 else if Age >= 32 then Age_cat = 'Age >=32';
91
92 ln_Progestrone = log(Prog_1);
93
94 run;
NOTE: There were 168 observations read from the data set RESEARCH.IMPORT.
NOTE: The data set WORK.IMPORT has 114 observations and 30 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
95
96 title 'Cross tabulation on BMI and Age category groups';
97 proc freq data=import; tables BMI_cat*Preg_Group/fisher; where BMI_cat ^= 'BMI Other '; run;
NOTE: There were 61 observations read from the data set WORK.IMPORT.
WHERE BMI_cat not = 'BMI Other ';
NOTE: PROCEDURE FREQ used (Total process time):
real time 0.32 seconds
cpu time 0.30 seconds
98 proc freq data=import; tables Age_cat*Preg_Group/fisher; run;
NOTE: There were 114 observations read from the data set WORK.IMPORT.
NOTE: PROCEDURE FREQ used (Total process time):
real time 0.21 seconds
cpu time 0.19 seconds
99
100
101 run;
102
103 title 'Summary statistics';
104 proc means data=import ndec=2 n mean std median p25 p75 min max; var Age GA_1 BMI; run;
NOTE: There were 114 observations read from the data set WORK.IMPORT.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.16 seconds
cpu time 0.15 seconds
105
106 title '2-sample t-test ';
107 proc ttest data=import; var Prog_1 ln_Progestrone; class Preg_Group; run;
NOTE: PROCEDURE TTEST used (Total process time):
real time 3.81 seconds
cpu time 1.94 seconds
108
109 title 'Wilcoxon test rank sum test';
110 title 'Summary statistics';
111 proc means data=import ndec=2 n mean std median p25 p75 min max; var Age GA_1 BMI; run;
NOTE: There were 114 observations read from the data set WORK.IMPORT.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.15 seconds
cpu time 0.14 seconds
112
113 title;
114 proc npar1way data=import anova wilcoxon dscf plots(only)=anovaboxplot;
115 var BMI Age Prog_1 ; class Preg_Group; run;
NOTE: DSCF multiple comparison analysis is available only when there are more than two CLASS levels.
NOTE: PROCEDURE NPAR1WAY used (Total process time):
real time 1.46 seconds
cpu time 0.86 seconds
116
117
118
119 ods rtf file= "/folders/myfolders/Research/Master List 07062020 SAS.xlsx"
120
121 %macro logitc(resp=,event=,class=,ref=,where=);
122 proc logistic data=import plots(only)=roc(id=prob);
123 &where;
124 class &class(ref="&ref")/ param=ref;
125 model &resp(event="&event") = &class /link=logit outroc=roc cl /*firth*/ rsquare;
126 /*exact "&class" &class / estimate=parm;*/
127 /*output out=outstats p=pred ;*/
128 run;
129 %mend;
130
131 %logitc(resp=Preg_Group,event=Miscarriage,class=BMI_cat,ref=19<=BMI<23,where=BMI_cat ^= 'BMI Other '); /*0.*/
NOTE: Line generated by the invoked macro "LOGITC".
131 proc logistic data=import plots(only)=roc(id=prob); &where; class &class(ref="&ref")/ param=ref; model
____ ____
22 22
202 76
131 ! &resp(event="&event") = &class /link=logit outroc=roc cl rsquare; run;
NOTE: Line generated by the macro variable "WHERE".
131 BMI_cat ^= 'BMI Other '
_______
180
ERROR 22-322: Syntax error, expecting one of the following: ;, ANCHOR, AUTHOR, BASE, BODY, BOOKMARK, BOX_SIZING, CHARSET, CLOSE,
COLUMNS, CONTENTS, CSSSTYLE, DATAPANEL, DOM, DPI, ENCODING, FILE, FONTSCALE, GFOOTNOTE, GTITLE, HOST, IMAGE_DPI,
KEEPN, LSTPIPE, NEWFILE, NOCONTENTS, NOGFOOTNOTE, NOGTITLE, NOKEEPN, NOLSTPIPE, NOOUTLINE, NOTRKEEP, OPERATOR,
OUTLINE, PACKAGE, PATH, RECORD_SEPARATOR, SAS, SASDATE, SGE, STARTPAGE, STYLE, TEXT, TITLE, TRANTAB, TRKEEP.
ERROR 202-322: The option or parameter is not recognized and will be ignored.
ERROR 76-322: Syntax error, statement will be ignored.
ERROR 180-322: Statement is not valid or it is used out of proper order.
NOTE: Line generated by the invoked macro "LOGITC".
131 proc logistic data=import plots(only)=roc(id=prob); &where; class &class(ref="&ref")/ param=ref; model
_____
180
131 ! &resp(event="&event") = &class /link=logit outroc=roc cl rsquare; run;
ERROR 180-322: Statement is not valid or it is used out of proper order.
NOTE: Line generated by the invoked macro "LOGITC".
131 proc logistic data=import plots(only)=roc(id=prob); &where; class &class(ref="&ref")/ param=ref; model
_____
180
131 ! &resp(event="&event") = &class /link=logit outroc=roc cl rsquare; run;
ERROR 180-322: Statement is not valid or it is used out of proper order.
132 %logitc(resp=Preg_Group,event=Miscarriage,class=Age_cat,ref=Age <32); /*0.*/
NOTE: PROC LOGISTIC is modeling the probability that Preg_Group='Miscarriage'.
NOTE: Convergence criterion (GCONV=1E-8) satisfied.
NOTE: There were 114 observations read from the data set WORK.IMPORT.
NOTE: The data set WORK.ROC has 2 observations and 7 variables.
NOTE: PROCEDURE LOGISTIC used (Total process time):
real time 0.79 seconds
cpu time 0.50 seconds
133
134 %macro logitx(resp=,event=,x=,where=);
135 proc logistic data=import plots(only)=roc(id=prob);
136 &where;
137 model &resp(event="&event") = &x /link=logit outroc=roc cl /*firth*/ rsquare rocci;
138 run;
139 %mend;
140
141 %logitx(resp=Preg_Group,event=Miscarriage,x=BMI); /*0.*/
NOTE: PROC LOGISTIC is modeling the probability that Preg_Group='Miscarriage'.
NOTE: Convergence criterion (GCONV=1E-8) satisfied.
NOTE: There were 114 observations read from the data set WORK.IMPORT.
NOTE: The data set WORK.ROC has 98 observations and 8 variables.
NOTE: PROCEDURE LOGISTIC used (Total process time):
real time 0.69 seconds
cpu time 0.39 seconds
142 %logitx(resp=Preg_Group,event=Miscarriage,x=Age); /*0.*/
NOTE: PROC LOGISTIC is modeling the probability that Preg_Group='Miscarriage'.
NOTE: Convergence criterion (GCONV=1E-8) satisfied.
NOTE: There were 114 observations read from the data set WORK.IMPORT.
NOTE: The data set WORK.ROC has 18 observations and 8 variables.
NOTE: PROCEDURE LOGISTIC used (Total process time):
real time 0.63 seconds
cpu time 0.39 seconds
143
144 title 'Mult Logistic Reg ';
NOTE: PROCEDURE LOGISTIC used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The SAS System stopped processing this step because of errors.
145 proc logistic data=import plots(only)=roc(id=prob); where BMI_cat ^= 'BMI Other ';
146 class Age_cat(ref='Age <32')/param=ref;
147 model Preg_Group(event="Miscarriage") = BMI Age_cat Prog_1;
148 /link=logit outroc=roc rsquare rocci cl/*nofit*/;
_
180
ERROR 180-322: Statement is not valid or it is used out of proper order.
149 /*roc 'SIS ' SIS ;*/
150 /*roc 'Sex PoinSD2 Temp' Gender Poincare_plot_SD2__ms_ Temperature_Reading__1_ ;*/
151 /*roccontrast 'Compare'/estimate=allpairs;*/
152 run;
153
154
155
156
157 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
169
