ODS LISTING; libname session1 "C:\Users\laura\OneDrive\Documents\econ485"; PROC IMPORT OUT= WORK.one DATAFILE="C:\Users\laura\OneDrive\Documents\econ485\project1data.csv" DBMS=csv REPLACE; RUN; proc print data=one; run; I ran this before and it was successful now when I try to do new things I'm getting this error message: ERROR: File WORK.ONE.DATA does not exist. I think this is my full log: DATAFILE= "C:\Users\laura\OneDrive\Documents\econ485\project1data.csv"; 48 DBMS=csv REPLACE; 49 RUN; 50 PROC IMPORT OUT= WORK.one; ERROR: FILE= or TABLE= is required and must be specified. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 51 DATAFILE="C:\Users\laura\OneDrive\Documents\econ485\project1data.csv"; 52 DBMS=csv REPLACE; 53 RUN; 54 PROC IMPORT OUT= WORK.one 55 DATAFILE="C:\Users\laura\OneDrive\Documents\econ485\project1data.csv" 56 DBMS=csv REPLACE; 57 RUN; ERROR: File is in use, C:\Users\laura\OneDrive\Documents\econ485\project1data.csv. ERROR: Import unsuccessful. See SAS Log for details. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.10 seconds cpu time 0.03 seconds 58 PROC IMPORT OUT= WORK.one 59 DATAFILE="C:\Users\laura\OneDrive\Documents\econ485\project1data.csv" 60 DBMS=csv REPLACE; 61 RUN; 62 /********************************************************************** 63 * PRODUCT: SAS 64 * VERSION: 9.4 65 * CREATOR: External File Interface 66 * DATE: 22FEB19 67 * DESC: Generated SAS Datastep Code 68 * TEMPLATE SOURCE: (None Specified.) 69 ***********************************************************************/ 70 data WORK.ONE ; 71 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */ 72 infile 'C:\Users\laura\OneDrive\Documents\econ485\project1data.csv' delimiter = ',' MISSOVER DSD lrecl=32767 72 ! firstobs=2 ; 73 informat observation_date yymmdd10. ; 74 informat Population best32. ; 75 informat Income best32. ; 76 informat One_year best32. ; 77 informat Ten_year best32. ; 78 informat Unemployment best32. ; 79 informat PCE best32. ; 80 informat PCE_lag best32. ; 81 informat Consumption best32. ; 82 informat Price best32. ; 83 format observation_date yymmdd10. ; 84 format Population best12. ; 85 format Income best12. ; 86 format One_year best12. ; 87 format Ten_year best12. ; 88 format Unemployment best12. ; 89 format PCE best12. ; 90 format PCE_lag best12. ; 91 format Consumption best12. ; 92 format Price best12. ; 93 input 94 observation_date 95 Population 96 Income 97 One_year 98 Ten_year 99 Unemployment 100 PCE 101 PCE_lag 102 Consumption 103 Price 104 ; 105 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */ 106 run; NOTE: The infile 'C:\Users\laura\OneDrive\Documents\econ485\project1data.csv' is: Filename=C:\Users\laura\OneDrive\Documents\econ485\project1data.csv, RECFM=V,LRECL=32767,File Size (bytes)=32584, Last Modified=14:11:00 22 ôáøåàø 2019, Create Time=14:11:00 22 ôáøåàø 2019 NOTE: 527 records were read from the infile 'C:\Users\laura\OneDrive\Documents\econ485\project1data.csv'. The minimum record length was 57. The maximum record length was 62. NOTE: The data set WORK.ONE has 527 observations and 10 variables. NOTE: DATA statement used (Total process time): real time 1.58 seconds cpu time 0.20 seconds 527 rows created in WORK.ONE from C:\Users\laura\OneDrive\Documents\econ485\project1data.csv. NOTE: WORK.ONE data set was successfully created. NOTE: The data set WORK.ONE has 527 observations and 10 variables. NOTE: PROCEDURE IMPORT used (Total process time): real time 3.86 seconds cpu time 0.42 seconds 107 proc print data=one; NOTE: Writing HTML Body file: sashtml.htm 108 run; NOTE: There were 527 observations read from the data set WORK.ONE. NOTE: PROCEDURE PRINT used (Total process time): real time 3.79 seconds cpu time 0.87 seconds 109 ODS LISTING; 110 libname session1 "C:\Users\laura\OneDrive\Documents\econ485"; NOTE: Libref SESSION1 was successfully assigned as follows: Engine: V9 Physical Name: C:\Users\laura\OneDrive\Documents\econ485 111 112 PROC IMPORT OUT= WORK.one 113 DATAFILE="C:\Users\laura\OneDrive\Documents\econ485\project1data.csv" 114 DBMS=csv REPLACE; 115 RUN; ERROR: File is in use, C:\Users\laura\OneDrive\Documents\econ485\project1data.csv. ERROR: Import unsuccessful. See SAS Log for details. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.12 seconds cpu time 0.09 seconds 116 117 proc print data=one; ERROR: File WORK.ONE.DATA does not exist. 118 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE PRINT used (Total process time): real time 0.02 seconds cpu time 0.00 seconds 119 120 proc contents DATA=WORK.one; ERROR: File WORK.ONE.DATA does not exist. 121 run; NOTE: Statements not processed because of errors noted above. NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.04 seconds cpu time 0.00 seconds NOTE: The SAS System stopped processing this step because of errors. 122 proc contents DATA=one; ERROR: File WORK.ONE.DATA does not exist. 123 run; NOTE: Statements not processed because of errors noted above. NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.09 seconds cpu time 0.01 seconds NOTE: The SAS System stopped processing this step because of errors. 124 proc contents data=WORK.one; ERROR: File WORK.ONE.DATA does not exist. 125 run; NOTE: Statements not processed because of errors noted above. NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.04 seconds cpu time 0.01 seconds NOTE: The SAS System stopped processing this step because of errors. 126 proc contents data=project1; ERROR: File WORK.PROJECT1.DATA does not exist. 127 run; NOTE: Statements not processed because of errors noted above. NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.02 seconds cpu time 0.01 seconds NOTE: The SAS System stopped processing this step because of errors. 128 PCE0 = PCE/6.029166667; ---- 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 129 RPCE = Price/PCE0; ---- 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 130 run; 131 PCE0 = PCE/6.029166667; ---- 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 132 RPCE = Price/PCE0; ---- 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 133 run; 134 135 proc contents; ERROR: File WORK.ONE.DATA does not exist. 136 run; NOTE: Statements not processed because of errors noted above. NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.01 seconds cpu time 0.00 seconds NOTE: The SAS System stopped processing this step because of errors. 137 data two; 138 set one; ERROR: File WORK.ONE.DATA does not exist. 139 140 PCE0 = pce/6.029166667; 141 RGAS_PCE0 = Price/PCE0; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.TWO may be incomplete. When this step was stopped there were 0 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 39.68 seconds cpu time 2.26 seconds 142 proc print data=work.one; ERROR: File WORK.ONE.DATA does not exist. 143 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 144 ODS LISTING; 145 libname session1 "C:\Users\laura\OneDrive\Documents\econ485"; NOTE: Libref SESSION1 was successfully assigned as follows: Engine: V9 Physical Name: C:\Users\laura\OneDrive\Documents\econ485 146 147 PROC IMPORT OUT= WORK.one 148 DATAFILE="C:\Users\laura\OneDrive\Documents\econ485\project1data.csv" 149 DBMS=csv REPLACE; 150 RUN; ERROR: File is in use, C:\Users\laura\OneDrive\Documents\econ485\project1data.csv. ERROR: Import unsuccessful. See SAS Log for details. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.09 seconds cpu time 0.09 seconds 151 152 proc print data=one; ERROR: File WORK.ONE.DATA does not exist. 153 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 154 ODS LISTING; 155 libname session1 "C:\Users\laura\OneDrive\Documents\econ485"; NOTE: Libref SESSION1 was successfully assigned as follows: Engine: V9 Physical Name: C:\Users\laura\OneDrive\Documents\econ485 156 157 PROC IMPORT OUT= WORK.one 158 DATAFILE="C:\Users\laura\OneDrive\Documents\econ485\project1data.csv" 159 DBMS=csv REPLACE; 160 RUN; ERROR: File is in use, C:\Users\laura\OneDrive\Documents\econ485\project1data.csv. ERROR: Import unsuccessful. See SAS Log for details. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.07 seconds cpu time 0.06 seconds 161 162 proc print data=one; ERROR: File WORK.ONE.DATA does not exist. 163 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 164 ODS LISTING; 165 libname session1 "C:\Users\laura\OneDrive\Documents\econ485"; NOTE: Libref SESSION1 was successfully assigned as follows: Engine: V9 Physical Name: C:\Users\laura\OneDrive\Documents\econ485 166 167 PROC IMPORT OUT= WORK.one 168 DATAFILE="C:\Users\laura\OneDrive\Documents\econ485\project1data.csv" 169 DBMS=csv REPLACE; 170 RUN; ERROR: File is in use, C:\Users\laura\OneDrive\Documents\econ485\project1data.csv. ERROR: Import unsuccessful. See SAS Log for details. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.07 seconds cpu time 0.06 seconds 171 172 proc print data=one; ERROR: File WORK.ONE.DATA does not exist. 173 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds
... View more