Good afternoon, I am trying to run proc means on multiple datasets I have downloaded into SAS. I was able to run proc means on the first three data sets, but not for the last one. For some reason, the log is saying it does not exist. Here is the code: libname libref 'C:\Users\bamfo\Downloads';
run;
options nodate center orientation=landscape;
run;
/*#1*/
data demo_j;
set libref.demo_j;
run;
proc means data = work.demo_j;
TITLE 'The Contents of the DEMO_J Data Set';
run;
data bpx_j;
set libref.bpx_j;
run;
proc means data = work.bpx_j;
TITLE 'The Contents of the BPX_J Data Set';
run;
proc contents data = work.bpx_j;
run;
data bmx_j_ge2yrs;
set libref.bmx_j_ge2yrs;
run;
proc means data = work.bmx_j_ge2yrs;
TITLE 'The Contents of the BMX_J_GE2YRS Data Set';
run;
proc contents data = work.bmx_j_ge2yrs;
run;
data bmx_j_It2yrs;
set libref.bmx_j_It2yrs;
run;
proc means data = work.bmx_j_It2yrs;
TITLE 'The Contents of the BMX_J_IT2YRS Data Set';
run; And here is the log: Licensed to GEORGE WASHINGTON UNIVERSITY - SFA T&R, Site 70158136. NOTE: This session is executing on the X64_10HOME platform. NOTE: Analytical products: SAS/STAT 15.1 SAS/ETS 15.1 SAS/IML 15.1 SAS/QC 15.1 NOTE: Additional host information: X64_10HOME WIN 10.0.18362 Workstation NOTE: SAS initialization used: real time 3.75 seconds cpu time 2.95 seconds 1 libname libref 'C:\Users\bamfo\Downloads'; NOTE: Libref LIBREF was successfully assigned as follows: Engine: V9 Physical Name: C:\Users\bamfo\Downloads 2 run; 3 options nodate center orientation=landscape; 4 run; 5 data hw4.demo_j; ERROR: Libref HW4 is not assigned. NOTE: The SAS System stopped processing this step because of errors. NOTE: DATA statement used (Total process time): real time 0.07 seconds cpu time 0.00 seconds 6 proc contents hw4.demo_j; ---------- 22 201 NOTE: Writing HTML Body file: sashtml.htm ERROR: There is not a default input data set (_LAST_ is _NULL_). ERROR 22-322: Syntax error, expecting one of the following: ;, CENTILES, DATA, DETAILS, DIR, DIRECTORY, FMTLEN, LIB, MEMTYPE, MT, MTYPE, NODETAILS, NODS, NOPRINT, ORDER, OUT, OUT2, SHORT, VARNUM. ERROR 201-322: The option is not recognized and will be ignored. 7 run; NOTE: Statements not processed because of errors noted above. NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.85 seconds cpu time 0.51 seconds NOTE: The SAS System stopped processing this step because of errors. NOTE: Data file LIBREF.DEMO_J.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. 8 data demo_j; 9 set libref.demo_j; NOTE: Data file LIBREF.DEMO_J.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: There were 9254 observations read from the data set LIBREF.DEMO_J. NOTE: The data set WORK.DEMO_J has 9254 observations and 46 variables. NOTE: DATA statement used (Total process time): real time 0.07 seconds cpu time 0.04 seconds 10 proc contents demo_j; ------ 22 202 ERROR 22-322: Syntax error, expecting one of the following: ;, CENTILES, DATA, DETAILS, DIR, DIRECTORY, FMTLEN, LIB, MEMTYPE, MT, MTYPE, NODETAILS, NODS, NOPRINT, ORDER, OUT, OUT2, SHORT, VARNUM. ERROR 202-322: The option or parameter is not recognized and will be ignored. 11 run; NOTE: Statements not processed because of errors noted above. NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.03 seconds cpu time 0.01 seconds NOTE: The SAS System stopped processing this step because of errors. 12 data demo_j; 13 set libref.demo_j; NOTE: Data file LIBREF.DEMO_J.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. 14 run; NOTE: There were 9254 observations read from the data set LIBREF.DEMO_J. NOTE: The data set WORK.DEMO_J has 9254 observations and 46 variables. NOTE: DATA statement used (Total process time): real time 0.05 seconds cpu time 0.04 seconds 15 proc means data = work.demo_j; 16 run; NOTE: There were 9254 observations read from the data set WORK.DEMO_J. NOTE: PROCEDURE MEANS used (Total process time): real time 0.22 seconds cpu time 0.29 seconds 17 proc means data = work.demo_j; 18 TITLE 'The Contents of the DEMO_J Data Set'; 19 run; NOTE: There were 9254 observations read from the data set WORK.DEMO_J. NOTE: PROCEDURE MEANS used (Total process time): real time 0.15 seconds cpu time 0.23 seconds 20 data bpx_j; 21 set libref.bpx_j; NOTE: Data file LIBREF.BPX_J.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. 22 run; NOTE: There were 8704 observations read from the data set LIBREF.BPX_J. NOTE: The data set WORK.BPX_J has 8704 observations and 22 variables. NOTE: DATA statement used (Total process time): real time 0.10 seconds cpu time 0.07 seconds 23 proc means data = work.bpx_j; 24 TITLE 'The Contents of the BPX_J Data Set'; 25 run; NOTE: There were 8704 observations read from the data set WORK.BPX_J. NOTE: PROCEDURE MEANS used (Total process time): real time 0.08 seconds cpu time 0.10 seconds 26 proc contents data = work.bpx_j; 27 run; NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.14 seconds cpu time 0.06 seconds 28 data bmx_j_it2yrs; 29 set libref.bmx_j_it2yrs; ERROR: File LIBREF.BMX_J_IT2YRS.DATA does not exist. 30 run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.BMX_J_IT2YRS may be incomplete. When this step was stopped there were 0 observations and 0 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 31 proc means data = work.bmx_j_it2yrs; 32 TITLE 'The Contents of the BMX_J_IT2YRS Data Set'; 33 run; NOTE: No variables in data set WORK.BMX_J_IT2YRS. NOTE: PROCEDURE MEANS used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Data file LIBREF.BMX_J_LT2YRS.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. 34 data bmx_j_it2yrs; 35 set libref.bmx_j_It2yrs; ERROR: File LIBREF.BMX_J_IT2YRS.DATA does not exist. 36 run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.BMX_J_IT2YRS may be incomplete. When this step was stopped there were 0 observations and 0 variables. WARNING: Data set WORK.BMX_J_IT2YRS was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.00 seconds 37 data bmx_j_ge2yrs; 38 set libref.bmx_j_ge2yrs; NOTE: Data file LIBREF.BMX_J_GE2YRS.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. 39 run; NOTE: There were 8153 observations read from the data set LIBREF.BMX_J_GE2YRS. NOTE: The data set WORK.BMX_J_GE2YRS has 8153 observations and 19 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.00 seconds 40 data bmx_j_ge2yrs; 41 set libref.bmx_j_ge2yrs; NOTE: Data file LIBREF.BMX_J_GE2YRS.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. 42 run; NOTE: There were 8153 observations read from the data set LIBREF.BMX_J_GE2YRS. NOTE: The data set WORK.BMX_J_GE2YRS has 8153 observations and 19 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.01 seconds 43 proc means data = work.bmx_j_ge2yrs; 44 TITLE 'The Contents of the BMX_J_GE2YRS Data Set'; 45 run; NOTE: There were 8153 observations read from the data set WORK.BMX_J_GE2YRS. NOTE: PROCEDURE MEANS used (Total process time): real time 0.04 seconds cpu time 0.04 seconds 46 proc contents data = work.bmx_j_ge2yrs; 47 run; NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.03 seconds cpu time 0.03 seconds 48 data bmx_j_It2yrs; 49 set libref.bmx_j_It2yrs; ERROR: File LIBREF.BMX_J_IT2YRS.DATA does not exist. 50 run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.BMX_J_IT2YRS may be incomplete. When this step was stopped there were 0 observations and 0 variables. WARNING: Data set WORK.BMX_J_IT2YRS was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 51 proc means data = work.bmx_j_It2yrs; 52 TITLE 'The Contents of the BMX_J_IT2YRS Data Set'; 53 run; NOTE: No variables in data set WORK.BMX_J_IT2YRS. NOTE: PROCEDURE MEANS used (Total process time): real time 0.00 seconds cpu time 0.00 seconds Thanks for your help!
... View more