Hi, Restarting my topic here. I have an issue where I have encountered an error. I'm not familiar with SAS but I would like to have it fix. Below is the error's snapshot and code. PROC IMPORT OUT= PledgeDataLoanLevel8
DATAFILE= "&importfolder./CTL_2_CD 300 - &hereportdate. FRBNY Waterfall.xlsx"
DBMS=XLSX
REPLACE;
GETNAMES=YES; SHEET = 'Breakout';
RUN;
data PledgeDataLoanLevel8;
set PledgeDataLoanLevel8;
if src_sys_tx in ('') then delete;
if src_sys_tx in ('Total', 'Prior Month') then delete;
if loan_nb = . then delete;
run;
proc freq data = PledgeDataLoanLevel4 ; tables final_waterfall ;run;
proc freq data = PledgeDataLoanLevel5 ; tables waterfall_frb_ny ;run;
proc freq data = PledgeDataLoanLevel6 ; tables final_waterfall ;run;
proc freq data = PledgeDataLoanLevel7 ; tables waterfall ;run;
proc freq data = PledgeDataLoanLevel8 ; tables waterfall_frb_ny ;run;
proc sql;
select
final_waterfall ,
sum (upb) as upb format = comma20.2 /** FHLB SF WAMU HE ***/
from PledgeDataLoanLevel4
group by final_waterfall
order by final_waterfall
;quit; Hope to hear from experts of the possible solutions. Cykelops
... View more
