BookmarkSubscribeRSS Feed
J_C
Calcite | Level 5 J_C
Calcite | Level 5

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

error.JPG

5 REPLIES 5
J_C
Calcite | Level 5 J_C
Calcite | Level 5

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

jakarman
Barite | Level 11

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

---->-- ja karman --<-----
SASKiwi
PROC Star

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.

J_C
Calcite | Level 5 J_C
Calcite | Level 5

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;

Cynthia_sas
SAS Super FREQ

Hi:

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

cynthia

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 1013 views
  • 0 likes
  • 4 in conversation