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;
... View more