Here is the log with the error code. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 1:12.09 cpu time 0.95 seconds 1315 Proc import 1316 DATAFILE="C:\Users\tianna.dupont\Documents\analysis\Alldataallyrs(2021.12.13)forSAS2.xlsx" 1317 OUT=Thresholds 1318 DBMS=xlsx 1319 REPLACE; 1320 GETNAMES=yes; 1321 run; 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 2278 observations and 88 variables. NOTE: WORK.THRESHOLDS data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 1.27 seconds cpu time 1.28 seconds 1322 1323 data Gen3; 1324 set Thresholds; 1325 where PPDD between 2000 and 4000; 1326 run; NOTE: There were 776 observations read from the data set WORK.THRESHOLDS. WHERE (PPDD>=2000 and PPDD<=4000); NOTE: The data set WORK.GEN3 has 776 observations and 88 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds 1327 1328 proc sql; 1329 create table two as 1330 select plot, year, max(psylla_N_young_L) as maxNymph, 1331 from Gen3 ---- 1 1332 group by plot, year; -- 79 WARNING 1-322: Assuming the symbol GE was misspelled as Gen3. ERROR 79-322: Expecting a FROM. 1333 run; NOTE: PROC SQL statements are executed immediately; The RUN statement has no effect.
... View more
