Strange ERROR

J_C — Mon, 25 May 2015 19:13:18 GMT

Hi All,

Before I explain the error message, let me point out that the program I am running can be run by many other computers without an error message, and when I run it, I get about 30 of the error messages below. This is the first time this happens and I used to run this program monthly. Is it something in my SAS setti

Thanks

Re: Strange ERROR

J_C — Mon, 25 May 2015 19:15:20 GMT

Also, this error occurs within an ODS Excel, yet the output is still generated with the appropriate number of tables.

Re: Strange ERROR

jakarman — Mon, 25 May 2015 19:35:00 GMT

Did you use proc import from excel and that one has used guessing mode?

Re: Strange ERROR

SASKiwi — Mon, 25 May 2015 19:37:27 GMT

Examine the RWORK.BY_REGION dataset. Your WHERE clause is reporting it requires numeric variables - so what is the type of the WHERE variables in the data? Compare this data with that on other computers where there are no errors.

You haven't provided your code so it is difficult to advise further.

Re: Strange ERROR

J_C — Mon, 25 May 2015 19:49:41 GMT

Nothing is imported from Excel. We import tables that are in a UNIX environment, with structured formats.

Looking back on the code, most of these errors occur in areas of code where no "where" statements are used.

ODS TAGSETS.EXCELXP

OPTIONS (

sheet_interval='none'

Sheet_Name = "Region Breakdown"

Absolute_Column_Width='19,12,10,10,10,10,10,10,10,10,10,10,10,10'

autofit_height = 'yes'

Orientation = 'Landscape'

TITLE_FOOTNOTE_WIDTH = '8'

);

TITLE1 "Sector changes in Loans and BAs exposure by Country of Residence";

title2 "&date_db2_1_qtr_ago. - &date_db2.";

title3 "Loans and BAs Authorized Amounts are determined at the facility level";

title4 "Loans and BAs Outstanding and Undrawn Commitments are determined at the availment level";

proc print data=rwork.by_region2 noobs label split='!' style(header)=[just=c];

var region_name;

var Authorized_begin FXaffect_auth total_diff_auth Authorized_end / style={tagattr='format:#,##0,,'};

var utilized_begin FXaffect_util total_diff_util utilized_end / style={tagattr='format:#,##0,,'};

var undrawn_begin FXaffect_undr total_diff_undr undrawn_end / style={tagattr='format:#,##0,,'};

label region_name='Region Name'

authorized_begin="Authorized (C$MM) as at &date_db2_1_qtr_ago."

FXaffect_auth="FX impact on Authorized Amounts (C$MM)"

total_diff_auth="Total change in Authorized Amounts(C$MM)"

authorized_end="Authorized (C$MM) as at &date_db2."

utilized_begin="Outstanding (C$MM) as at &date_db2_1_qtr_ago."

FXaffect_util="FX impact on Outstandings (C$MM)"

total_diff_util="Total change in Outstandings (C$MM)"

utilized_end="Outstanding (C$MM) as at &date_db2."

undrawn_begin="Undrawn Commitments (C$MM) as at &date_db2_1_qtr_ago."

FXaffect_undr="FX impact on Undrawn Commitments (C$MM)"

total_diff_undr="Total change!in Undrawn Commitments (C$MM)"

undrawn_end="Undrawn Commitments (C$MM) as at &date_db2.";

sum Authorized_begin FXaffect_auth total_diff_auth Authorized_end utilized_begin FXaffect_util total_diff_util utilized_end undrawn_begin FXaffect_undr total_diff_undr undrawn_end / style={tagattr='format:#,##0,,'};

run;

title1 " ";

proc report data=rwork.by_region nowd center missing split='!';

column (region_name sector Authorized_begin FXaffect_auth total_diff_auth Authorized_end utilized_begin FXaffect_util total_diff_util utilized_end undrawn_begin FXaffect_undr total_diff_undr undrawn_end);

define region_name/group "Region Name";

define sector/group "Sector";

define Authorized_begin/analysis style={tagattr='format:#,##0,,'} "Authorized (C$MM) as at &date_db2_1_qtr_ago.";

define FXaffect_auth/analysis style={tagattr='format:#,##0,,'} "FX impact on Authorized Amounts (C$MM)";

define total_diff_auth/analysis style={tagattr='format:#,##0,,'} "Total change in Authorized (C$MM)";

define Authorized_end/analysis style={tagattr='format:#,##0,,'} "Authorized (C$MM) as at &date_db2.";

define utilized_begin/analysis style={tagattr='format:#,##0,,'} "Outstanding (C$MM) as at &date_db2_1_qtr_ago.";

define FXaffect_util/analysis style={tagattr='format:#,##0,,'} "FX impact on Outstandings (C$MM)";

define total_diff_util/analysis style={tagattr='format:#,##0,,'} "Total change in Outstandings (C$MM)";

define utilized_end/analysis style={tagattr='format:#,##0,,'} "Outstanding (C$MM) as at &date_db2.";

define FXaffect_undr/analysis style={tagattr='format:#,##0,,'} "FX impact on Undrawn Commitments (C$MM)";

define undrawn_begin/analysis style={tagattr='format:#,##0,,'} "Undrawn Commitments (C$MM) as at &date_db2_1_qtr_ago.";

define total_diff_undr/analysis style={tagattr='format:#,##0,,'} "Total change in Undrawn Commitments (C$MM)";

define undrawn_end/analysis style={tagattr='format:#,##0,,'} "Undrawn Commitments (C$MM) as at &date_db2.";

rbreak after / summarize suppress ol ul skip page;

run;

Re: Strange ERROR

Cynthia_sas — Mon, 25 May 2015 20:49:59 GMT

Hi:

I believe this is the relevant note: 45213 - "ERROR: WHERE clause operator requires numeric variables" might be generated when using the TITLE_FOOTNOTE_WIDTH ExcelXP tagset option If you can't get it working then you might want to consult with Tech Support.

cynthia

topic Re: Strange ERROR in SAS Procedures

Strange ERROR

Re: Strange ERROR

Re: Strange ERROR

Re: Strange ERROR

Re: Strange ERROR

Re: Strange ERROR