Errors in SAS

jamuriuk — Thu, 22 Jun 2017 17:53:32 GMT

Hello team,

I am not so conversant with SAS but I have been running SAS codes with proc iml but apparently getting these kinds of errors

31         /* Especify the number of equations you are estimating*/
32
33         e=9;
34
35
36
37         /* Especify the equation you drop in the SUR*/
38
39         d=9;
40
41
42
43         /* Especify the number of socio demographic variables included in the model */
44
45         r=4;
46
47
48
49         /* Especify the degree of polynomial used in the model*/
50
51         s=5;
52
53
54
55         /*///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
2                                                          The SAS System                              11:36 Thursday, June 22, 2017

55       ! */
56
57
58
59         /*/////Importing into matrices Arithmetic mean values for budget shares,price indices and socio demographic
59       ! charact/////*/
60
61
62
63         /*Read the mean values of budget shares*/
64
65         USE w_means;
66
67         READ ALL INTO W;
68
69         W2= W[4,3:e+2];
70
71         *print w2;
72
73
74
75         /*Read the mean values of price variables*/
76
77         USE p_means;
78
79         READ ALL INTO P;
80
81         P2= P[4,3:e+2];
82
83         *print p2;
84
85
86
87         /*Read the mean values of demographic variables*/
88
89         USE sd_means;
90
91         READ ALL INTO SD;
92
93         SD2= 1||SD[4,3:r+2];
94
95         *print sd2;
96
97
98
99
100
101        /*/////////////////////////Importing into a matrix the parameter estimates for Beta from the EASI model, where the
101      ! missing
102
103        parameters are recovered trough the adding up restriction/////////////////////////////////////////////////////////*/
104
105
106
107        USE beans_excel3;
108
109        READ ALL VAR {
110
3                                                          The SAS System                              11:36 Thursday, June 22, 2017

111        b0101 b0102 b0103 b0104 b0105 b0106 b0107 b0108 b0109
112
113        b0201 b0202 b0203 b0204 b0205 b0206 b0207 b0208 b0209
114
115        b0301 b0302 b0303 b0304 b0305 b0306 b0307 b0308 b0309
116
117        b0401 b0402 b0403 b0404 b0405 b0406 b0407 b0408 b0409
118
119        b0501 b0502 b0503 b0504 b0505 b0506 b0507 b0508 b0509
120
121        b0601 b0602 b0603 b0604 b0605 b0606 b0607 b0608 b0609
122
123        b0701 b0702 b0703 b0704 b0705 b0706 b0707 b0708 b0709
124
125        b0801 b0802 b0803 b0804 b0805 b0806 b0807 b0808 b0809
126
127        b0901 b0902 b0903 b0904 b0905 b0906 b0907 b0908 b0909
128
129
130        } INTO B;
ERROR: B0101 is not in the scope of variables for the data set.

statement : READ at line 109 column 1
131
132
133
134        B1= J(e-1,e,0);
135
136        Do i=1 to e-1;
137
138        j=i-1;
139
140        M= B[1,1+e*j:e*(j+1)];
141
142        B1 [i,]= M;
143
144        end;
ERROR: (execution) Matrix has not been set to a value.

operation : [ at line 140 column 5
operands : B, *LIT1021, _TEM1002, _TEM1004

B      0 row       0 col     (type ?, size 0)

*LIT1021      1 row       1 col     (numeric)

         1

_TEM1002      1 row       1 col     (numeric)

         1

_TEM1004      1 row       1 col     (numeric)

         9

statement : ASSIGN at line 140 column 1
4                                                          The SAS System                              11:36 Thursday, June 22, 2017

145
146        *print B1;
147
148
149
150        B2= J(1,e,0);
151
152        Do i=1 to e;
153
154        M= -SUM(B1[,i]);
155
156        B2 [,i] = M;
157
158        END;
159
160        *print B2;
161
162
163
164        B3=B1//B2;
165
166        *print B3;
167        run;
NOTE: Module MAIN is undefined in IML; cannot be RUN.
168
169        GOPTIONS NOACCESSIBLE;
170        %LET _CLIENTTASKLABEL=;
171        %LET _CLIENTPROJECTPATH=;
172        %LET _CLIENTPROJECTNAME=;
173        %LET _SASPROGRAMFILE=;
174
175        ;*';*";*/;quit;
NOTE: Exiting IML.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IML used (Total process time):
      real time           0.03 seconds
      cpu time            0.03 seconds

175      !                run;
176        ODS _ALL_ CLOSE;
177
178
179        QUIT; RUN;
180

these are my codes for more information

proc iml;

/*///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////*/

/* Especify the number of equations you are estimating*/

e=9;

/* Especify the equation you drop in the SUR*/

d=9;

/* Especify the number of socio demographic variables included in the model */

r=4;

/* Especify the degree of polynomial used in the model*/

s=5;

/*///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////*/

/*/////Importing into matrices Arithmetic mean values for budget shares,price indices and socio demographic charact/////*/

/*Read the mean values of budget shares*/

USE w_means;

READ ALL INTO W;

W2= W[4,3:e+2];

*print w2;

/*Read the mean values of price variables*/

USE p_means;

READ ALL INTO P;

P2= P[4,3:e+2];

*print p2;

/*Read the mean values of demographic variables*/

USE sd_means;

READ ALL INTO SD;

SD2= 1||SD[4,3:r+2];

*print sd2;

/*/////////////////////////Importing into a matrix the parameter estimates for Beta from the EASI model, where the missing

parameters are recovered trough the adding up restriction/////////////////////////////////////////////////////////*/

USE beans_excel3;

READ ALL VAR {

b0101 b0102 b0103 b0104 b0105 b0106 b0107 b0108 b0109

b0201 b0202 b0203 b0204 b0205 b0206 b0207 b0208 b0209

b0301 b0302 b0303 b0304 b0305 b0306 b0307 b0308 b0309

b0401 b0402 b0403 b0404 b0405 b0406 b0407 b0408 b0409

b0501 b0502 b0503 b0504 b0505 b0506 b0507 b0508 b0509

b0601 b0602 b0603 b0604 b0605 b0606 b0607 b0608 b0609

b0701 b0702 b0703 b0704 b0705 b0706 b0707 b0708 b0709

b0801 b0802 b0803 b0804 b0805 b0806 b0807 b0808 b0809

b0901 b0902 b0903 b0904 b0905 b0906 b0907 b0908 b0909

} INTO B;

B1= J(e-1,e,0);

Do i=1 to e-1;

j=i-1;

M= B[1,1+e*j:e*(j+1)];

B1 [i,]= M;

end;

*print B1;

B2= J(1,e,0);

Do i=1 to e;

M= -SUM(B1[,i]);

B2 [,i] = M;

END;

*print B2;

B3=B1//B2;

*print B3;
run;

I will really appreciate your advise

James

Re: Errors in SAS

Reeza — Thu, 22 Jun 2017 17:59:04 GMT

Start with your errors in the order they come.

ERROR: B0101 is not in the scope of variables for the data set.

Check if you have a variable called B0101 in your data set, beans_excel3

Re: Errors in SAS

jamuriuk — Thu, 22 Jun 2017 18:05:55 GMT

Thanks, I actually don't have the B0101 unless I create it. Thanks.
How about the second error, please?
ERROR: (execution) Matrix has not been set to a value.

Re: Errors in SAS

Reeza — Thu, 22 Jun 2017 18:08:16 GMT

That depends, did you fix the first error and the second error still exists?

If so, post the new log, up to the error, we don't need all of your code.

topic Re: Errors in SAS in SAS Enterprise Guide

Errors in SAS

Re: Errors in SAS

Re: Errors in SAS

Re: Errors in SAS