topic ERROR: One or more variables are missing or freq or weight is zero on every observation. in SAS Programming

ERROR: One or more variables are missing or freq or weight is zero on every observation.

conleyi — Fri, 05 Mar 2021 22:42:57 GMT

I am getting an error on my code and I cannot figure out what is wrong with it. The error is keeping the code under Item 5 is not showing up in my results either. Any help would would be amazing.

/* Item 1 */
PROC IMPORT 
DATAFILE='/home/u45048482/sasuser.v94/LM2/FantasyBaseball2.csv'
DBMS=csv REPLACE OUT=FANTASY;
GETNAMES=YES;
RUN;

 /* Item 2 */
PROC FORMAT;
VALUE Personinitial 1 = "DJ"
              2 = "AR"
              3  = "BK"
              4  = "JW"
              5 = "TS"
              6 = "RL"
              7  = "DR"
              8  = "MF";


DATA FANTASY;
SET FANTASY;
SqrtTime = SQRT(TIME);   
label Time = 'Time to make Selection (in seconds)'
	 Person = 'Person making selection';
	 SqrtTime = 'Square root of time (in seconds) to make selection';
format person Personinitial.;


 /* Item 3 */
PROC SGPLOT data=FANTASY;
vbox time / group=person;
title "Comparison Boxplot: Times per Person";
title2 'Ian Conley';
RUN;

PROC MEANS data=fantasy n min max mean std median skewness kurtosis;
TITLE "Summary Statistics: Times per Person";
TITLE2 "Ian Conley";
var time;
Class person;
RUN;

/* Item 4 */
ods graphics on;
PROC GLM data=fantasy plots=diagnostics;
class person;
model time = person;
means person / BON cldiff lines; 
title 'ANOVA Model: Times = Person';
title2'Ian Conley';
RUN; 

/* Item 5 */
PROC MEANS data=fantasy n min max mean std median skewness kurtosis maxdec=3;
TITLE "Summary Statistics: SqrtTime per Person";
TITLE2 "Ian Conley";
var sqrtTime;
Class person;
RUN;


ods graphics on;
PROC GLM data=fantasy plots=diagnostics;
class person;
model SqrtTime = person;
means person / BON cldiff lines; 
title 'ANOVA Model: SqrtTime = Person';
title2'Ian Conley';
RUN; QUIT;

Re: ERROR: One or more variables are missing or freq or weight is zero on every observation.

conleyi — Fri, 05 Mar 2021 22:45:31 GMT

This is the Log file for the code as well

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

NOTE: ODS statements in the SAS Studio environment may disable some output features.

74 /* Ian Conley STA 02 */

75 /* Homework 2 */

77 /* Item 1 */

78 PROC IMPORT

79 DATAFILE='/home/u45048482/sasuser.v94/LM2/FantasyBaseball2.csv'

80 DBMS=csv REPLACE OUT=FANTASY;

81 GETNAMES=YES;

82 RUN;

NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to

WORK.PARMS.PARMS.SLIST.

83 /**********************************************************************

84 * PRODUCT: SAS

85 * VERSION: 9.4

86 * CREATOR: External File Interface

87 * DATE: 05MAR21

88 * DESC: Generated SAS Datastep Code

89 * TEMPLATE SOURCE: (None Specified.)

90 ***********************************************************************/

91 data WORK.FANTASY ;

92 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */

93 infile '/home/u45048482/sasuser.v94/LM2/FantasyBaseball2.csv' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;

94 informat Round best32. ;

95 informat Time best32. ;

96 informat Person best32. ;

97 format Round best12. ;

98 format Time best12. ;

99 format Person best12. ;

100 input

101 Round

102 Time

103 Person

104 ;

105 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */

106 run;

NOTE: The infile '/home/u45048482/sasuser.v94/LM2/FantasyBaseball2.csv' is:

Filename=/home/u45048482/sasuser.v94/LM2/FantasyBaseball2.csv,

Owner Name=u45048482,Group Name=oda,

Access Permission=-rw-r--r--,

Last Modified=03Mar2021:10:42:15,

File Size (bytes)=1706

NOTE: 192 records were read from the infile '/home/u45048482/sasuser.v94/LM2/FantasyBaseball2.csv'.

The minimum record length was 5.

The maximum record length was 8.

NOTE: The data set WORK.FANTASY has 192 observations and 3 variables.

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 9250.79k

OS Memory 44064.00k

Timestamp 03/05/2021 10:23:45 PM

Step Count 63 Switch Count 2

Page Faults 0

Page Reclaims 462

Page Swaps 0

Voluntary Context Switches 10

Involuntary Context Switches 0

Block Input Operations 0

Block Output Operations 264

192 rows created in WORK.FANTASY from /home/u45048482/sasuser.v94/LM2/FantasyBaseball2.csv.

NOTE: WORK.FANTASY data set was successfully created.

NOTE: The data set WORK.FANTASY has 192 observations and 3 variables.

NOTE: PROCEDURE IMPORT used (Total process time):

real time 0.05 seconds

user cpu time 0.04 seconds

system cpu time 0.02 seconds

memory 9250.79k

OS Memory 44324.00k

Timestamp 03/05/2021 10:23:45 PM

Step Count 63 Switch Count 10

Page Faults 0

Page Reclaims 4081

Page Swaps 0

Voluntary Context Switches 77

Involuntary Context Switches 0

Block Input Operations 0

Block Output Operations 320

107

108 /* Item 2 */

109 PROC FORMAT;

110 VALUE Personinitial 1 = "DJ"

111 2 = "AR"

112 3 = "BK"

113 4 = "JW"

114 5 = "TS"

115 6 = "RL"

116 7 = "DR"

117 8 = "MF";

NOTE: Format PERSONINITIAL is already on the library WORK.FORMATS.

NOTE: Format PERSONINITIAL has been output.

118

119

NOTE: PROCEDURE FORMAT used (Total process time):

real time 0.00 seconds

user cpu time 0.00 seconds

system cpu time 0.00 seconds

memory 256.25k

OS Memory 38568.00k

Timestamp 03/05/2021 10:23:45 PM

Step Count 64 Switch Count 0

Page Faults 0

Page Reclaims 25

Page Swaps 0

Voluntary Context Switches 0

Involuntary Context Switches 0

Block Input Operations 0

Block Output Operations 32

120 DATA FANTASY;

121 SET FANTASY;

122 SqrtTime = SQRT(TIME);

123 label Time = 'Time to make Selection (in seconds)'

124 Person = 'Person making selection';

125 SqrtTime = 'Square root of time (in seconds) to make selection';

126 format person Personinitial.;

127

128

129 /* Item 3 */

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).

125:14