I am unable to run code to call my data, I believe that is why my data does not exist. I have tried
a libname statement as well as proc import but I cannot seem to be able to create the correct pathway
Log:
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
68
69 *************Starter code************************;
70 PROC SQL;
71 CREATE TABLE WORK.query AS
72 SELECT ID , Match_ID , Sex , Ethnic , dmincagen , Smoke , Baseage , BMI_GS , BMI_SR , 'Case'n FROM
72 ! _TEMP0.case_control_analysis;
NOTE: Data file _TEMP0.CASE_CONTROL_ANALYSIS.DATA is in a format that is native to another host, or the file encoding does not
match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and
might reduce performance.
NOTE: Table WORK.QUERY created, with 568 rows and 10 columns.
73 RUN;
NOTE: PROC SQL statements are executed immediately; The RUN statement has no effect.
74 QUIT;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
user cpu time 0.01 seconds
system cpu time 0.00 seconds
memory 5891.84k
OS Memory 35752.00k
Timestamp 04/14/2022 03:34:06 PM
Step Count 425 Switch Count 2
Page Faults 0
Page Reclaims 85
Page Swaps 0
Voluntary Context Switches 19
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 264
75
76 PROC DATASETS NOLIST NODETAILS;
77 CONTENTS DATA=WORK.query OUT=WORK.details;
78 RUN;
NOTE: The data set WORK.DETAILS has 10 observations and 41 variables.
79
NOTE: PROCEDURE DATASETS used (Total process time):
real time 0.04 seconds
user cpu time 0.04 seconds
system cpu time 0.00 seconds
memory 2327.15k
OS Memory 31408.00k
Timestamp 04/14/2022 03:34:06 PM
Step Count 426 Switch Count 2
Page Faults 0
Page Reclaims 189
Page Swaps 0
Voluntary Context Switches 14
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 288
80 PROC PRINT DATA=WORK.details;
81 RUN;
NOTE: There were 10 observations read from the data set WORK.DETAILS.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.08 seconds
user cpu time 0.09 seconds
system cpu time 0.01 seconds
memory 1062.28k
OS Memory 30888.00k
Timestamp 04/14/2022 03:34:06 PM
Step Count 427 Switch Count 0
Page Faults 0
Page Reclaims 62
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 1
Block Input Operations 0
Block Output Operations 32
82
83
84 ********Question 1A. Looking for duplicate subjects***;
85 proc means data = work.details; run;
NOTE: There were 10 observations read from the data set WORK.DETAILS.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.08 seconds
user cpu time 0.08 seconds
system cpu time 0.00 seconds
memory 6135.46k
OS Memory 36020.00k
Timestamp 04/14/2022 03:34:06 PM
Step Count 428 Switch Count 1
Page Faults 0
Page Reclaims 1345
Page Swaps 0
Voluntary Context Switches 19
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 16
86
87 ********Question 1B. Histogram*****;
88 PROC UNIVARIATE data=work.query;
89 var Baseage dmincagen;
90 histogram ;
91 run;
NOTE: PROCEDURE UNIVARIATE used (Total process time):
real time 0.25 seconds
user cpu time 0.18 seconds
system cpu time 0.01 seconds
memory 13003.75k
OS Memory 40964.00k
Timestamp 04/14/2022 03:34:06 PM
Step Count 429 Switch Count 0
Page Faults 0
Page Reclaims 3239
Page Swaps 0
Voluntary Context Switches 228
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 776
92
93 ********Question 1C. Distribution of age at baseline and BMI by case status***;
94
95
96
97 Proc SGplot data = Case_Control_0;
98 by case;
ERROR: Variable CASE not found.
99 histogram bmi_gs;
ERROR: Variable BMI_GS not found.
100 density bmi_gs;
ERROR: Variable BMI_GS not found.
101 run;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SGPLOT used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 379.03k
OS Memory 39076.00k
Timestamp 04/14/2022 03:34:06 PM
Step Count 430 Switch Count 0
Page Faults 0
Page Reclaims 17
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
102
103
104
105
106 *************Question Task 2 ***************************;
107 Proc freq data= Case_Control;
ERROR: File WORK.CASE_CONTROL.DATA does not exist.
108 tables case *(ethnic sex smoke)/chisq;
ERROR: No data set open to look up variables.
ERROR: No data set open to look up variables.
ERROR: No data set open to look up variables.
ERROR: No data set open to look up variables.
109
110 run;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE FREQ used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 184.34k
OS Memory 39076.00k
Timestamp 04/14/2022 03:34:06 PM
Step Count 431 Switch Count 0
Page Faults 0
Page Reclaims 44
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
111
112 ************************* Task 2 continous variable mean age SD**** ;
113
114 proc ttest data= Case_Control;;
ERROR: File WORK.CASE_CONTROL.DATA does not exist.
115 class case;
116 var Baseage;
117
118 run;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE TTEST used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 305.46k
OS Memory 39076.00k
Timestamp 04/14/2022 03:34:06 PM
Step Count 432 Switch Count 0
Page Faults 0
Page Reclaims 14
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
119
120 ************Task 3a**********************;
121
122 Proc corr data = Case_Control;
ERROR: File WORK.CASE_CONTROL.DATA does not exist.
123 var BMI_SR BMI_GS;
124 run;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE CORR used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 292.56k
OS Memory 39076.00k
Timestamp 04/14/2022 03:34:06 PM
Step Count 433 Switch Count 0
Page Faults 0
Page Reclaims 15
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
125
126
127
128
129 Proc SGplot data = Case_Control;
ERROR: File WORK.CASE_CONTROL.DATA does not exist.
130 Reg X = BMI_SR y = BMI_GS;
ERROR: No data set open to look up variables.
ERROR: No data set open to look up variables.
131 label BMI_SR = "Self-Report BMI";
132 label BMI_GS = "Gold-Standard BMI";
133 run;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SGPLOT used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 213.59k
OS Memory 39076.00k
Timestamp 04/14/2022 03:34:06 PM
Step Count 434 Switch Count 0
Page Faults 0
Page Reclaims 17
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
134
135 ***********Task 3b************************;
136
137 proc means data = Case_Control mean std;
ERROR: File WORK.CASE_CONTROL.DATA does not exist.
138 Var BMI_SR BMI_GS;
ERROR: No data set open to look up variables.
ERROR: No data set open to look up variables.
139 run;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 318.84k
OS Memory 39076.00k
Timestamp 04/14/2022 03:34:06 PM
Step Count 435 Switch Count 0
Page Faults 0
Page Reclaims 15
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
140
141 ******Hint: Bias = mean difference, Upper limit = Bias + 1.96*Stdev of Difference, Lower Limit = Bias - 1.96*Stdev of
141 ! Difference. Use this information to complete the code below.****;
142
143 Proc SGplot data = work.query;
144 scatter X = BMI_GS Y = BMI_SR;
145 label BMI_GS = "Gold-Standard BMI Measure";
146 label Diff = "Gold-Standard - Self-Report";
WARNING: Variable DIFF not found in data set WORK.QUERY.
147 refline 0 / transparency = 0.1 lineattrs=(color=black pattern =1 thickness =3);
148 refline 7/ transparency = 0.1 Label = ('Upper Limit of Agreement') lineattrs=(color=red pattern=2 thickness =3);
149 refline 3/ transparency = 0.1 Label = ('Lower Limit of Agreement') lineattrs=(color=red pattern=2 thickness =3);
150 refline 4 / transparency = 0.1 Label = ('Bias') lineattrs=(color=red thickness =3);
151 run;
NOTE: PROCEDURE SGPLOT used (Total process time):
real time 0.08 seconds
user cpu time 0.04 seconds
system cpu time 0.01 seconds
memory 1519.93k
OS Memory 40240.00k
Timestamp 04/14/2022 03:34:06 PM
Step Count 436 Switch Count 1
Page Faults 0
Page Reclaims 312
Page Swaps 0
Voluntary Context Switches 132
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 472
NOTE: There were 568 observations read from the data set WORK.QUERY.
152
153 ***************4********;
NOTE: PROCEDURE LOGISTIC used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 79.25k
OS Memory 38820.00k
Timestamp 04/14/2022 03:34:06 PM
Step Count 437 Switch Count 0
Page Faults 0
Page Reclaims 16
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
ERROR: File WORK.CASE_CONTROL_1.DATA does not exist.
NOTE: The SAS System stopped processing this step because of errors.
154 Proc logistic data = Case_Control_1;
155 class Match_ID BMI_GS_Cat(ref='0') ethnic;
156 model Case (event = '1') = BMI_GS_Cat ethnic baseage;
157 strata Match_ID;
158 run;
159
160
161
162 *****************5***********************;
163 *Non-differential Misclassification;
NOTE: PROCEDURE LOGISTIC used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 190.81k
OS Memory 38820.00k
Timestamp 04/14/2022 03:34:06 PM
Step Count 438 Switch Count 0
Page Faults 0
Page Reclaims 16
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
ERROR: File WORK.CASE_CONTROL.DATA does not exist.
NOTE: The SAS System stopped processing this step because of errors.
164 Proc logistic data = Case_Control;
165 class Match_ID BMI_SR_Cat(ref='0') ethnic;
166 model Case (event = '1') = BMI_SR_Cat baseage ethnic;
167 strata Match_ID;
168 run;
169
170
171
172
173
174 ******************6a********************;
175 Data Case_Control_2;
176 set Case_Control_1;
ERROR: File WORK.CASE_CONTROL_1.DATA does not exist.
177 if Case = 1 then BMI_DM_cat = BMI_GS_Cat; *cases measured via gold-standard;
178 else if Case = 0 Then BMI_DM_Cat = BMI_SR_cat; *controls measured via self-report;
179 run;
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.CASE_CONTROL_2 may be incomplete. When this step was stopped there were 0 observations and 4 variables.
WARNING: Data set WORK.CASE_CONTROL_2 was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 631.15k
OS Memory 39080.00k
Timestamp 04/14/2022 03:34:06 PM
Step Count 439 Switch Count 0
Page Faults 0
Page Reclaims 60
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 8
180
181 *showing the effect of the Differential Misclassification;
NOTE: PROCEDURE LOGISTIC used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 299.87k
OS Memory 39080.00k
Timestamp 04/14/2022 03:34:06 PM
Step Count 440 Switch Count 0
Page Faults 0
Page Reclaims 50
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
ERROR: Variable MATCH_ID not found.
ERROR: Variable ETHNIC not found.
NOTE: The SAS System stopped processing this step because of errors.
182 Proc logistic data = Case_Control_2;
183 class Match_ID BMI_DM_cat(Ref='0') ethnic;
184 model Case (event = '1') = BMI_DM_cat ethnic baseage;
185 strata Match_ID;
186 run;
187
188
189 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
199
questions. When trying to run the code my variables are not found and my data does not exist. I have tried adding a libname, I have also tried using commands such as ProcImport and Datafile and I can not find the correct way to call my data.
My log and code are attached.
*************Starter code************************;
PROC SQL;
CREATE TABLE WORK.query AS
SELECT ID , Match_ID , Sex , Ethnic , dmincagen , Smoke , Baseage , BMI_GS , BMI_SR , 'Case'n FROM _TEMP0.case_control_analysis;
RUN;
QUIT;
PROC DATASETS NOLIST NODETAILS;
CONTENTS DATA=WORK.query OUT=WORK.details;
RUN;
PROC PRINT DATA=WORK.details;
RUN;
********Question 1A. Looking for duplicate subjects***;
proc means data = work.details; run;
********Question 1B. Histogram*****;
PROC UNIVARIATE data=work.query;
var Baseage dmincagen;
histogram ;
run;
********Question 1C. Distribution of age at baseline and BMI by case status***;
Proc SGplot data = Case_Control_0;
by case;
histogram bmi_gs;
density bmi_gs;
run;
*************Question Task 2 ***************************;
Proc freq data= Case_Control;
tables case *(ethnic sex smoke)/chisq;
run;
************************* Task 2 continous variable mean age SD**** ;
proc ttest data= Case_Control;;
class case;
var Baseage;
run;
************Task 3a**********************;
Proc corr data = Case_Control;
var BMI_SR BMI_GS;
run;
Proc SGplot data = Case_Control;
Reg X = BMI_SR y = BMI_GS;
label BMI_SR = "Self-Report BMI";
label BMI_GS = "Gold-Standard BMI";
run;
***********Task 3b************************;
proc means data = Case_Control mean std;
Var BMI_SR BMI_GS;
run;
******Hint: Bias = mean difference, Upper limit = Bias + 1.96*Stdev of Difference, Lower Limit = Bias - 1.96*Stdev of Difference. Use this information to complete the code below.****;
Proc SGplot data = work.query;
scatter X = BMI_GS Y = BMI_SR;
label BMI_GS = "Gold-Standard BMI Measure";
label Diff = "Gold-Standard - Self-Report";
refline 0 / transparency = 0.1 lineattrs=(color=black pattern =1 thickness =3);
refline 7/ transparency = 0.1 Label = ('Upper Limit of Agreement') lineattrs=(color=red pattern=2 thickness =3);
refline 3/ transparency = 0.1 Label = ('Lower Limit of Agreement') lineattrs=(color=red pattern=2 thickness =3);
refline 4 / transparency = 0.1 Label = ('Bias') lineattrs=(color=red thickness =3);
run;
***************4********;
Proc logistic data = Case_Control_1;
class Match_ID BMI_GS_Cat(ref='0') ethnic;
model Case (event = '1') = BMI_GS_Cat ethnic baseage;
strata Match_ID;
run;
*****************5***********************;
*Non-differential Misclassification;
Proc logistic data = Case_Control;
class Match_ID BMI_SR_Cat(ref='0') ethnic;
model Case (event = '1') = BMI_SR_Cat baseage ethnic;
strata Match_ID;
run;
******************6a********************;
Data Case_Control_2;
set Case_Control_1;
if Case = 1 then BMI_DM_cat = BMI_GS_Cat; *cases measured via gold-standard;
else if Case = 0 Then BMI_DM_Cat = BMI_SR_cat; *controls measured via self-report;
run;
*showing the effect of the Differential Misclassification;
Proc logistic data = Case_Control_2;
class Match_ID BMI_DM_cat(Ref='0') ethnic;
model Case (event = '1') = BMI_DM_cat ethnic baseage;
strata Match_ID;
run;
... View more
