Hello,
I have a pre-question for this event:
This code works great in SAS EG but when placed on the server, it kicks back this error message (in red):
%include '/sas/shared/628562/pass.sas';
libname DVM oracle user=&user_a password=&pass_a path=DVMTFPRD schema=APP_ALL;
data _null_;
date1=today();
call symput ('paydate',put(intnx('day',date1,-2,'end'),date11.));
call symput ('busdate',put(intnx('day',date1,-1,'end'),date11.));
run;
%put &busdate;
%put &paydate;
proc sql;
connect to oracle as oracle (user=&user_a password=&pass_a path=DVMTFPRD);
create table aggregate1 as select distinct * from Connection To oracle
(select
a.Business_dt,
a.Next_Pmt_Dt,
a.sale_dt,
a.service_entity_num,
a.service_entity_nm,
a.contract_num,
a.member_num,
a.fac_cd,
a.suppression_cd,
a.Loan_and_Credit_Life_Bal_Amt
from vh_coll_contract_hist a inner join
dm_d_calendar b
on a.report_category_nm = b.report_category_nm
and a.business_dt = b.business_dt
where b.region_loaded_cd in ('NA','ALL')
and a.report_category_nm in ('DAILY', 'SEMI-MONTHLY')
and a.Next_Pmt_Dt between '15-jan-2017' and %bquote('&paydate.') /** We started the project on Jan 15 **/
and trunc(a.business_dt) = %bquote('&busdate.')/** business date is yesterday **/
and a.service_entity_nm in ('FAIRFIELD','TRENDWEST')
and a.delete_crmast_ind = 'N'
and a.suppression_cd in ('7','%','A','C','H','M','N','O','S')
and a.fac_cd = 'Q'
and a.loan_and_credit_life_bal_amt >0
and a.Contract_Status_Cd = '0'
);
Disconnect from oracle;
quit;
data aggregate2;
set aggregate1;
dayslate = intck('day',datepart(next_pmt_dt),datepart(business_dt));
run;
proc sort data=aggregate2;by dayslate;run;
proc export data=aggregate2 outfile='/sas/shared/mfritz/SAS/Data/pool_code_Q/Pool_Code_Q.xlsx'
dbms=xlsx replace ;
sheet = "&busdate.";
run;
/*
filename mymail email ("adminemail@abc.com")
subject="Pool Code Q Project Daily file"
attach=("/sas/shared/mfritz/SAS/Data/pool_code_Q/Pool_Code_Q.xlsx" content_type="application/xlsx");
data _null_;
file mymail;
put 'All,';
put "Here is the daily file as of &busdate. for the Pool Code Q project. Please let me know if you have any questions on the data.";
put;
put 'Thank you,';
put 'Max';
run;
*/
filename mymail email ("firstname.lastname@abc.com" "firstname2.lastname2@abc.com" "firstname3.lastname3@abc.com"
"firstname4.lastname4@abc.com" "firstname5.lastname5@abc.com" "firstname6.lastname6@abc.com" )
subject="Pool Code Q Project Daily file"
attach=("/sas/shared/mfritz/SAS/Data/pool_code_Q/Pool_Code_Q.xlsx" content_type="application/xlsx");
data _null_;
file mymail;
put 'All,';
put "Here is the daily file as of &busdate. for the Pool Code Q project. Please let me know if you have any questions on the data.";
put;
put 'Thank you,';
put 'Max';
run;
62 proc export data=aggregate2 outfile='/sas/shared/mfritz/SAS/Data/pool_code_Q/Pool_Code_Q.xlsx'
63 dbms=xlsx replace ;
64 sheet = "&busdate.";
65 run;
Error creating temporary file for XLSX file -> /sas/shared/mfritz/SAS/Data/pool_code_Q//Pool_Code_Q.$$1 . It is either not an
Excel spreadsheet or it is damaged. Error code=8000101D
Requested Output File is Invalid
ERROR: Export unsuccessful. See SAS Log for details.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE EXPORT used (Total process time):
real time 0.21 seconds
cpu time 0.01 seconds
Any thoughts?
Thanks,
Sharda
... View more
