topic Error Message in SAS/IML Software and Matrix Computations https://communities.sas.com/t5/SAS-IML-Software-and-Matrix/Error-Message/m-p/84990#M495 <HTML><HEAD></HEAD><BODY><P>I am receiving the following error message:</P><P></P><P>1610&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; read all var{fuel_r_&amp;Yr} into fuel_r;</P><P>ERROR: FUEL_R_ is not in the scope of variables for the data set.</P><P></P><P> statement : READ at line 1610 column 5</P><P></P><P>for running the following command:</P><P></P><TABLE><TBODY><TR><TD></TD><TD>use UTIL_RETAIL;</TD></TR></TBODY></TABLE><P></P><TABLE><TBODY><TR><TD></TD><TD>read all var{elec_r_&amp;Yr} into elec_r;</TD></TR><TR><TD></TD><TD>read all var{fuel_r_&amp;Yr} into fuel_r;</TD></TR></TBODY></TABLE><P></P><P>any comments?</P></BODY></HTML> Wed, 03 Oct 2012 20:46:26 GMT goliPSU 2012-10-03T20:46:26Z Error Message https://communities.sas.com/t5/SAS-IML-Software-and-Matrix/Error-Message/m-p/84990#M495 <HTML><HEAD></HEAD><BODY><P>I am receiving the following error message:</P><P></P><P>1610&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; read all var{fuel_r_&amp;Yr} into fuel_r;</P><P>ERROR: FUEL_R_ is not in the scope of variables for the data set.</P><P></P><P> statement : READ at line 1610 column 5</P><P></P><P>for running the following command:</P><P></P><TABLE><TBODY><TR><TD></TD><TD>use UTIL_RETAIL;</TD></TR></TBODY></TABLE><P></P><TABLE><TBODY><TR><TD></TD><TD>read all var{elec_r_&amp;Yr} into elec_r;</TD></TR><TR><TD></TD><TD>read all var{fuel_r_&amp;Yr} into fuel_r;</TD></TR></TBODY></TABLE><P></P><P>any comments?</P></BODY></HTML> Wed, 03 Oct 2012 20:46:26 GMT https://communities.sas.com/t5/SAS-IML-Software-and-Matrix/Error-Message/m-p/84990#M495 goliPSU 2012-10-03T20:46:26Z Re: Error Message https://communities.sas.com/t5/SAS-IML-Software-and-Matrix/Error-Message/m-p/84991#M496 <HTML><HEAD></HEAD><BODY><P>Looks like &amp;Yr is not defined. Use %put &amp;Yr to find out.</P></BODY></HTML> Wed, 03 Oct 2012 23:24:36 GMT https://communities.sas.com/t5/SAS-IML-Software-and-Matrix/Error-Message/m-p/84991#M496 Rick_SAS 2012-10-03T23:24:36Z Re: Error Message https://communities.sas.com/t5/SAS-IML-Software-and-Matrix/Error-Message/m-p/84992#M497 <HTML><HEAD></HEAD><BODY><P>Actually Yr is defined earlier:</P><P></P><P>proc iml;</P><P>%let Yr = '93';</P><P>&nbsp;&nbsp;&nbsp; *%include 'sector_codes Nov 25 08.sas';</P><P>&nbsp;&nbsp;&nbsp;&nbsp; %include 'C:\Users\hze1\Desktop\SAS\FoodChain\sector_codes.sas';</P><P></P><P>&nbsp;&nbsp;&nbsp; %macro addmargins(fob,truck,rail,water,air,pipe,whole,ret,filter=(1:num_sectors));</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; selector = J(1,num_sectors,0);</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; selector[&amp;filter] = 1;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Yplus = diag(selector) * &amp;fob;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /* transportation margins */</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Yplus[truck_row,] = Yplus[truck_row,] + selector * &amp;truck;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Yplus[air_row,] = Yplus[air_row,] + selector * &amp;air;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Yplus[water_row,] = Yplus[water_row,] + selector * &amp;water;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Yplus[rail_row,] = Yplus[rail_row,] + selector * &amp;rail;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Yplus[pipe_row,] = Yplus[pipe_row,] + selector * &amp;pipe;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /* wholesale &amp; retail utility and non-utility expenditure */</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Yplus[tgas_row,] = Yplus[tgas_row,] + </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; selector * (diag(fuel_w) * &amp;whole + diag(fuel_r) * &amp;ret);</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Yplus[telec_row,] = Yplus[telec_row,] +</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; selector * (diag(elec_w) * &amp;whole + diag(elec_r) * &amp;ret);</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Yplus[whole_row,] = Yplus[whole_row,] + </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; selector * ((I(num_sectors) - diag(elec_w + fuel_w)) * &amp;whole);</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Yplus[retail_row,] = Yplus[retail_row,] + </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; selector * ((I(num_sectors) - diag(elec_r + fuel_r)) * &amp;ret);</P><P>&nbsp;&nbsp;&nbsp; %mend;</P><P></P><P>&nbsp;&nbsp;&nbsp; /* GET DATA */</P><P></P><P>&nbsp;&nbsp;&nbsp; use UTIL_RETAIL;</P><P></P><P>&nbsp;&nbsp;&nbsp; read all var{elec_r_&amp;Yr} into elec_r;</P><P>&nbsp;&nbsp;&nbsp; read all var{fuel_r_&amp;Yr} into fuel_r;</P></BODY></HTML> Thu, 04 Oct 2012 13:23:53 GMT https://communities.sas.com/t5/SAS-IML-Software-and-Matrix/Error-Message/m-p/84992#M497 goliPSU 2012-10-04T13:23:53Z Re: Error Message https://communities.sas.com/t5/SAS-IML-Software-and-Matrix/Error-Message/m-p/84993#M498 <HTML><HEAD></HEAD><BODY><P>Use</P><P>%let Yr = 93;</P><P>instead of</P><P>%let Yr = '93';</P></BODY></HTML> Thu, 04 Oct 2012 13:34:17 GMT https://communities.sas.com/t5/SAS-IML-Software-and-Matrix/Error-Message/m-p/84993#M498 Rick_SAS 2012-10-04T13:34:17Z Re: Error Message https://communities.sas.com/t5/SAS-IML-Software-and-Matrix/Error-Message/m-p/84994#M499 <HTML><HEAD></HEAD><BODY><P>Thank you.</P></BODY></HTML> Thu, 04 Oct 2012 13:43:17 GMT https://communities.sas.com/t5/SAS-IML-Software-and-Matrix/Error-Message/m-p/84994#M499 goliPSU 2012-10-04T13:43:17Z