Solved: Re: No output and no error in the code

nassimsa · Posted 07-18-2019 06:32 AM

Hi

I am new student using SAS, i used the same code few months ag o and always received the results and since few days no output is generated even when i use the example from SAS and no errors are showed, all code used never generates output. I really need to have the results as soon as possible to send it to my professor , please help me if you have any idea on how to solve it.

Thank you in advance.

Begining of the code :

/** Import an XLSX file. **/

PROC IMPORT DATAFILE="/home/nassimsa0/sasuser.v94/ENA.xlsx"
              OUT=WORK.ENA
              DBMS=XLSX
              REPLACE;
RUN;

/** Print the results. **/

PROC PRINT DATA=WORK.ENA; RUN;
data WORK.ENA;
set WORK.ENA;
   array values {6} c g f h e s;
   array costshares {6} sc sg sf sh se ss;
   cost = sum(c,g,f,h,e,s);
   do i = 1 to 6;
      costshares{i} = values{i}/cost;
   end;
run;

data WORK.ENA;
set WORK.ENA;
run;
proc sgplot data = WORK.ENA;
   series x = year y = sc / markers markerattrs =(symbol=circle);
   series x = year y = sg / markers markerattrs =(symbol=square);
   series x = year y = sf / markers markerattrs =(symbol=star);
   series x = year y = sh / markers markerattrs =(symbol=diamond);
   series x = year y = se / markers markerattrs =(symbol=hash);
   series x = year y = ss / markers markerattrs =(symbol=dot);
   title 'Factor Cost Shares';
   yaxis label = 'Cost Share';

PeterClemmensen · Posted 07-18-2019 07:21 AM

This log is from running more code than you initially posted. So I have not read it thoroughly.

However, you have a PROC IML step at the bottom. PROC IML must be terminated by a QUIT; statement and not RUN;.

The DATA to DATA Step Macro
Blog: SASnrd

View solution in original post

PeterClemmensen · Posted 07-18-2019 06:33 AM

Can you post the log please?

The DATA to DATA Step Macro
Blog: SASnrd

nassimsa · Posted 07-18-2019 07:00 AM

Thank you very much for your quick reply.

Please find below the LOG , its very long;

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

72

73 /** Import an XLSX file. **/

74

75 PROC IMPORT DATAFILE="/home/nassimsa0/ER.xlsx"

76 OUT=WORK.ER

77 DBMS=XLSX

78 REPLACE;

79 RUN;

NOTE: The import data set has 16 observations and 14 variables.

NOTE: WORK.ER data set was successfully created.

NOTE: PROCEDURE IMPORT used (Total process time):

real time 0.00 seconds

user cpu time 0.00 seconds

system cpu time 0.00 seconds

memory 2774.28k

OS Memory 39336.00k

Timestamp 18/07/2019 10:49:26 AM

Step Count 66 Switch Count 2

Page Faults 0

Page Reclaims 660

Page Swaps 0

Voluntary Context Switches 15

Involuntary Context Switches 0

Block Input Operations 24

Block Output Operations 264

80

81 /** Print the results. **/

82

83 PROC PRINT DATA=WORK.ER; RUN;

NOTE: There were 16 observations read from the data set WORK.ER.

NOTE: PROCEDURE PRINT used (Total process time):

real time 0.07 seconds

user cpu time 0.08 seconds

system cpu time 0.00 seconds

memory 2658.46k

OS Memory 37544.00k

Timestamp 18/07/2019 10:49:26 AM

Step Count 67 Switch Count 0

Page Faults 0

Page Reclaims 89

Page Swaps 0

Voluntary Context Switches 0

Involuntary Context Switches 0

Block Input Operations 0

Block Output Operations 24

84 data WORK.ER;

85 set WORK.ER;

86 array values {6} c g f h e s;

87 array costshares {6} sc sg sf sh se ss;

88 cost = sum(c,g,f,h,e,s);

89 do i = 1 to 6;

90 costshares{i} = values{i}/cost;

91 end;

92 run;

NOTE: There were 16 observations read from the data set WORK.ER.

NOTE: The data set WORK.ER has 16 observations and 22 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 995.12k

OS Memory 38060.00k

Timestamp 18/07/2019 10:49:26 AM

Step Count 68 Switch Count 2

Page Faults 0

Page Reclaims 148

Page Swaps 0

Voluntary Context Switches 14

Involuntary Context Switches 0

Block Input Operations 0

Block Output Operations 264

93

94 data WORK.ER;

95 set WORK.ER;

96 label a_c = "SC Intercept"

97 a_g = "SG Intercept"

98 a_f = "SF Intercept"

99 a_h = "SH Intercept"

100 a_e = "SE Intercept"

101 a_s = "SS Intercept"

102 gcc = "SC C Price"

103 gcg = "SC G Price"

104 gcf = "SC F Price"

105 gch = "SC H Price"

106 gce = "SC E Price"

107 gcs = "SC S Price"

108 gcy = "SC Output"

109 ggc = "SG C Price"

110 ggg = "SG G Price"

111 ggf = "SG F Price"

112 ggh = "SG H Price"

113 gge = "SG E Price"

114 ggs = "SG S Price"

115 ggy = "SG Output"

116 gfc = "SF C Price"

117 gfg = "SF G Price"

118 gff = "SF F Price"

119 gfh = "SF H Price"

120 gfe = "SF E Price"

121 gfs = "SF S Price"

122 gfy = "SF Output"

123 ghc = "SH C Price"

124 ghg = "SH G Price"

125 ghf = "SH F Price"

126 ghh = "SH H Price"

127 ghe = "SH E Price"

128 ghs = "SH S Price"

129 ghy = "SH Output"

130 gec = "SE C Price"

131 geg = "SE G Price"

132 gef = "SE F Price"

133 geh = "SE H Price"

134 gee = "SE E Price"

135 ges = "SE S Price"

136 gey = "SE Output"

137 gsc = "SS C Price"

138 gsg = "SS G Price"

139 gsf = "SS F Price"

140 gsh = "SS H Price"

141 gse = "SS E Price"

142 gss = "SS S Price"

143 gsy = "SS Output";

144 run;

NOTE: Variable a_c is uninitialized.

NOTE: Variable a_g is uninitialized.

NOTE: Variable a_f is uninitialized.

NOTE: Variable a_h is uninitialized.

NOTE: Variable a_e is uninitialized.

NOTE: Variable a_s is uninitialized.

NOTE: Variable gcc is uninitialized.

NOTE: Variable gcg is uninitialized.

NOTE: Variable gcf is uninitialized.

NOTE: Variable gch is uninitialized.

NOTE: Variable gce is uninitialized.

NOTE: Variable gcs is uninitialized.

NOTE: Variable gcy is uninitialized.

NOTE: Variable ggc is uninitialized.

NOTE: Variable ggg is uninitialized.

NOTE: Variable ggf is uninitialized.

NOTE: Variable ggh is uninitialized.

NOTE: Variable gge is uninitialized.

NOTE: Variable ggs is uninitialized.

NOTE: Variable ggy is uninitialized.

NOTE: Variable gfc is uninitialized.

NOTE: Variable gfg is uninitialized.

NOTE: Variable gff is uninitialized.

NOTE: Variable gfh is uninitialized.

NOTE: Variable gfe is uninitialized.

NOTE: Variable gfs is uninitialized.

NOTE: Variable gfy is uninitialized.

NOTE: Variable ghc is uninitialized.

NOTE: Variable ghg is uninitialized.

NOTE: Variable ghf is uninitialized.

NOTE: Variable ghh is uninitialized.

NOTE: Variable ghe is uninitialized.

NOTE: Variable ghs is uninitialized.

NOTE: Variable ghy is uninitialized.

NOTE: Variable gec is uninitialized.

NOTE: Variable geg is uninitialized.

NOTE: Variable gef is uninitialized.

NOTE: Variable geh is uninitialized.

NOTE: Variable gee is uninitialized.

NOTE: Variable ges is uninitialized.

NOTE: Variable gey is uninitialized.

NOTE: Variable gsc is uninitialized.

NOTE: Variable gsg is uninitialized.

NOTE: Variable gsf is uninitialized.

NOTE: Variable gsh is uninitialized.

NOTE: Variable gse is uninitialized.

NOTE: Variable gss is uninitialized.

NOTE: Variable gsy is uninitialized.

NOTE: There were 16 observations read from the data set WORK.ER.

NOTE: The data set WORK.ER has 16 observations and 22 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

user cpu time 0.01 seconds

system cpu time 0.00 seconds

memory 1052.46k

OS Memory 38060.00k

Timestamp 18/07/2019 10:49:26 AM

Step Count 69 Switch Count 2

Page Faults 0

Page Reclaims 133

Page Swaps 0

Voluntary Context Switches 11

Involuntary Context Switches 0

Block Input Operations 0

Block Output Operations 264

145 proc sgplot data = WORK.ER;

146 series x = year y = sc / markers markerattrs =(symbol=circle);

147 series x = year y = sg / markers markerattrs =(symbol=square);

148 series x = year y = sf / markers markerattrs =(symbol=star);

149 series x = year y = sh / markers markerattrs =(symbol=diamond);

150 series x = year y = se / markers markerattrs =(symbol=hash);

151 series x = year y = ss / markers markerattrs =(symbol=dot);

152 title 'Factor Cost Shares';

153 yaxis label = 'Cost Share';

154 run;

NOTE: PROCEDURE SGPLOT used (Total process time):

real time 0.30 seconds

user cpu time 0.13 seconds

system cpu time 0.02 seconds

memory 18532.03k

OS Memory 53420.00k

Timestamp 18/07/2019 10:49:26 AM

Step Count 70 Switch Count 2

Page Faults 0

Page Reclaims 4724

Page Swaps 0

Voluntary Context Switches 349

Involuntary Context Switches 0

Block Input Operations 0

Block Output Operations 1232

NOTE: SYMBOL=DOT n'est pas valide. La valeur par défaut sera utilisée.

NOTE: There were 16 observations read from the data set WORK.ER.

155 proc sgplot data = WORK.ER;

156 series x = year y = c / markers markerattrs =(symbol=circle);

157 series x = year y = g / markers markerattrs =(symbol=square);

158 series x = year y = f / markers markerattrs =(symbol=star);

159 series x = year y = h / markers markerattrs =(symbol=diamond);

160 series x = year y = e / markers markerattrs =(symbol=hash);

161 series x = year y = s / markers markerattrs =(symbol=dot);

162 title 'Factor Quantities';

163 yaxis label = 'Quantity';

164 run;

NOTE: PROCEDURE SGPLOT used (Total process time):

real time 0.21 seconds

user cpu time 0.07 seconds

system cpu time 0.01 seconds

memory 3095.31k

OS Memory 54956.00k

Timestamp 18/07/2019 10:49:26 AM

Step Count 71 Switch Count 2

Page Faults 0

Page Reclaims 675

Page Swaps 0

Voluntary Context Switches 326

Involuntary Context Switches 0

Block Input Operations 0

Block Output Operations 992

NOTE: SYMBOL=DOT n'est pas valide. La valeur par défaut sera utilisée.

NOTE: There were 16 observations read from the data set WORK.ER.

165 proc sgplot data = WORK.ER;

166 series x = year y = pc / markers markerattrs =(symbol=circle);

167 series x = year y = pg / markers markerattrs =(symbol=square);

168 series x = year y = pf / markers markerattrs =(symbol=star);

169 series x = year y = ph / markers markerattrs =(symbol=diamond);

170 series x = year y = pe / markers markerattrs =(symbol=hash);

171 series x = year y = ps / markers markerattrs =(symbol=dot);

172 title 'Factor Prices';

173 yaxis label = 'Price';

174 run;

NOTE: PROCEDURE SGPLOT used (Total process time):

real time 0.21 seconds

user cpu time 0.08 seconds

system cpu time 0.01 seconds

memory 3053.93k

OS Memory 54956.00k

Timestamp 18/07/2019 10:49:27 AM

Step Count 72 Switch Count 2

Page Faults 0

Page Reclaims 637

Page Swaps 0

Voluntary Context Switches 330

Involuntary Context Switches 0

Block Input Operations 0

Block Output Operations 976

NOTE: SYMBOL=DOT n'est pas valide. La valeur par défaut sera utilisée.

NOTE: There were 16 observations read from the data set WORK.ER.

175 proc model data = WORK.ER;

176 parameters a_c gcc gcg gcf gch gce gcs gcy

177 a_g ggc ggg ggf ggh gge ggs ggy

178 a_h ghc ghg ghf ghh ghe ghs ghy

179 a_e gec geg gef geh gee ges gey

180 a_s gsc gsg gsf gsh gse gss gsy;

181 endogenous sc sg sh se ss;

182 exogenous pc pg pf ph pe ps y;

183

184 /*System of Derived Demand Equations*/

185 sc = a_c + gcc*log(pc) + gcg*log(pg) + gcf*log(pf) + gch*log(ph) + gce*log(pe)

186 + gcs*log(ps) + gcy*log(y);

187 sg = a_g + ggc*log(pc) + ggg*log(pg) + ggf*log(pf) + ggh*log(ph) + gge*log(pe)

188 + ggs*log(ps) + ggy*log(y);

189 sh = a_h + ghc*log(pc) + ghg*log(pg) + ghf*log(pf) + ghh*log(ph) + ghe*log(pe)

190 + ghs*log(ps) + ghy*log(y);

191 se = a_e + gec*log(pc) + geg*log(pg) + gef*log(pf) + geh*log(ph) + gee*log(pe)

192 + ges*log(ps) + gey*log(y);

193 ss = a_s + gsc*log(pc) + gsg*log(pg) + gsf*log(pf) + gsh*log(ph) + gse*log(pe)

194 + gss*log(ps) + gsy*log(y);

195

196

197 fit sc sg sh se ss / itsur;

198

199 label a_c = "SC Intercept"

200 a_g = "SG Intercept"

201 a_f = "SF Intercept"

202 a_h = "SH Intercept"

203 a_e = "SE Intercept"

204 a_s = "SS Intercept"

205 gcc = "SC C Price"

206 gcg = "SC G Price"

207 gcf = "SC F Price"

208 gch = "SC H Price"

209 gce = "SC E Price"

210 gcs = "SC S Price"

211 gcy = "SC Output"

212 ggc = "SG C Price"

213 ggg = "SG G Price"

214 ggf = "SG F Price"

215 ggh = "SG H Price"

216 gge = "SG E Price"

217 ggs = "SG S Price"

218 ggy = "SG Output"

219 gfc = "SF C Price"

220 gfg = "SF G Price"

221 gff = "SF F Price"

222 gfh = "SF H Price"

223 gfe = "SF E Price"

224 gfs = "SF S Price"

225 gfy = "SF Output"

226 ghc = "SH C Price"

227 ghg = "SH G Price"

228 ghf = "SH F Price"

229 ghh = "SH H Price"

230 ghe = "SH E Price"

231 ghs = "SH S Price"

232 ghy = "SH Output"

233 gec = "SE C Price"

234 geg = "SE G Price"

235 gef = "SE F Price"

236 geh = "SE H Price"

237 gee = "SE E Price"

238 ges = "SE S Price"

239 gey = "SE Output"

240 gsc = "SS C Price"

241 gsg = "SS G Price"

242 gsf = "SS F Price"

243 gsh = "SS H Price"

244 gse = "SS E Price"

245 gss = "SS S Price"

246 gsy = "SS Output";

247

248

249 test "Homogeneity"

250 gcc+gcg+gcf+gch+gce+gcs=0,

251 ggc+ggg+ggf+ggh+gge+ggs=0,

252 ghc+ghg+ghf+ghh+ghe+ghs=0,

253 gec+geg+gef+geh+gee+ges=0,

254 gsc+gsg+gsf+gsh+gse+gss=0, / lr;

255

256 test "Symmetry"

257 gcg=ggc,

258 gch=ghc,

259 gce=gec,

260 gcs=ges,

261 ggh=ghg,

262 gge=geg,

263 ggs=gsg,

264 ghe=geh,

265 ghs=gsh,

266 ges=gse, / lr;

267

268 test "Joint Homogeneity and Symmetry"

269 gcc+gcg+gcf+gch+gce+gcs=0,

270 ggc+ggg+ggf+ggh+gge+ggs=0,

271 ghc+ghg+ghf+ghh+ghe+ghs=0,

272 gec+geg+gef+geh+gee+ges=0,

273 gsc+gsg+gsf+gsh+gse+gss=0,

274 gcg=ggc,

275 gch=ghc,

276 gce=gec,

277 gcs=ges,

278 ggh=ghg,

279 gge=geg,

280 ggs=gsg,

281 ghe=geh,

282 ghs=gsh,

283 ges=gse, / lr;

284 run;

WARNING: The variable a_f is not defined in the program.

WARNING: The variable gfc is not defined in the program.

WARNING: The variable gfg is not defined in the program.

WARNING: The variable gff is not defined in the program.

WARNING: The variable gfh is not defined in the program.

WARNING: The variable gfe is not defined in the program.

WARNING: The variable gfs is not defined in the program.

WARNING: The variable gfy is not defined in the program.

NOTE: A l'itération ITSUR 2 CONVERGE=0.001 Criteria Met.

NOTE: The graph in the RTF(WEB) destination will be rendered as an image due to the use of a gradient contour.

NOTE: The graph in the RTF(WEB) destination will be rendered as an image due to the use of a surface plot.

NOTE: The graph in the RTF(WEB) destination will be rendered as an image due to the use of a bivariate histogram.

NOTE: The graph in the PDF(WEB) destination will be rendered as an image due to the use of a gradient contour.

NOTE: The graph in the PDF(WEB) destination will be rendered as an image due to the use of a surface plot.

NOTE: The graph in the PDF(WEB) destination will be rendered as an image due to the use of a bivariate histogram.