I am sorry, I have corrected the VAR code. But still having an issue with proc means noprint NOTE: ODS statements in the SAS Studio environment may disable some output features.
73
74 *************** THIS PROGRAM ANALYZES FORT PICKETT DATA ***********;
75
76 OPTIONS LS=100 PS=100 NOCENTER NODATE NONUMBER;
77
78 /** Import an XLSX file. **/
79
80 PROC IMPORT DATAFILE="/folders/myfolders/2019/All fish data 1.XLSX"
81 OUT=WORK.FP
82 DBMS=XLSX
83 REPLACE;
84 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 2826 observations and 11 variables.
NOTE: WORK.FP data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.36 seconds
cpu time 0.34 seconds
85
86 *ods rtf file = "/folders/myfolders/2019/KERR 2017 creel result.rtf" BODYTITLE;
87
88 run;
89
90
91 *********** BRING IN DAILY COUNT DATA ***************;
92
93 DATA DAILY; SET FP;
94
NOTE: There were 2826 observations read from the data set WORK.FP.
NOTE: The data set WORK.DAILY has 2826 observations and 11 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
95 PROC SORT; BY LAKE YEAR SPECIES CAT; RUN;
NOTE: There were 2826 observations read from the data set WORK.DAILY.
NOTE: The data set WORK.DAILY has 2826 observations and 11 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
96 PROC MEANS NOPRINT; BY LAKE YEAR SPECIES CAT; VAR CLASS; Run;
ERROR: Neither the PRINT option nor a valid output statement has been given.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
97 OUTPUT OUT=NEW N=N;
98
99 DATA B; SET NEW;
ERROR: File WORK.NEW.DATA does not exist.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.B may be incomplete. When this step was stopped there were 0
observations and 0 variables.
WARNING: Data set WORK.B was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds
100 PROC PRINT; VAR LAKE YEAR SPECIES CAT N;
ERROR: Variable N not found.
101 TITLE 'NUMBER OF FISH COLLECTED FROM PICKETT BY LAKE AND SPECIES'; 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.01 seconds
102
103
104 *ods rtf close;
105 run;
106
107
108
109 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
121
... View more