Hi Kurt, Code: %macro Import_csv(file, sas);
proc import out= &sas
datafile= &file
dbms= csv replace;
guessingrows= 100000;
run;
%mend;
%Import_csv("&out_fld.\Financial Reporting Database (DUMMY).csv", act); Dummy dataset below - I've narrowed it down to the fact the log gets filled up where there is a number variable that starts a text string (i.e. the column of "1. XYZ"): COMPANY,BRANCH,DIVISION,DISTRIBUTION,PORTFOLIO,XCLASS,TCODE,YOA,INC_Y,REF,CCY_REP,FINANCIAL,DESCRIPTION,CURR_QE_REP,PREV_QE_REP,PREV_YE_REP,CCY_MONTH,CCY,FINANCIAL_MARKER,FINANCIAL_WRT,GROSS_MARKER,T3_CODE,GROUP_ORDER,GROUP_NAME,REPORT_ORDER,REPORT_NAME,ITEM_ORDER,ITEM_NAME,USE_PREV,USE_CURR,CCY_TYPE,JNL_ID,JNL_DESC,ACCOUNT_TYPE,ACCOUNT_CODE,ACCOUNT_NAME,SIGNAGE,GROUP,REPORT,ITEM,ACCOUNT,JOURNAL,FX_AVG_EUR,FX_AVG_GBP,FX_AVG_USD,FX_AVG_EUR_USD,FX_CLS_EUR,FX_CLS_GBP,FX_CLS_USD,FX_CLS_EUR_USD,QTD_REP,YTD_REP,QTD_EUR,YTD_EUR,QTD_GBP,YTD_GBP,QTD_USD,YTD_USD,QTD_USD_PRS,YTD_USD_PRS,RUN XYZ,XYZ,XYZ,XYZ,XYZ,XYZ,XYZ,9999,9999,XYZ,XYZ,1. XYZ,XYZ,9999,9999,9999,9999,XYZ,9999,XYZ,XYZ,XYZ,9999,XYZ,9999,XYZ,9999,XYZ,9999,9999,XYZ,XYZ,XYZ,XYZ,9999,XYZ,9999,XYZ,XYZ,XYZ,XYZ,XYZ,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,XYZ XYZ,XYZ,XYZ,XYZ,XYZ,XYZ,XYZ,9999,9999,XYZ,XYZ,1. XYZ,XYZ,9999,9999,9999,9999,XYZ,9999,XYZ,XYZ,XYZ,9999,XYZ,9999,XYZ,9999,XYZ,9999,9999,XYZ,XYZ,XYZ,XYZ,9999,XYZ,9999,XYZ,XYZ,XYZ,XYZ,XYZ,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,XYZ XYZ,XYZ,XYZ,XYZ,XYZ,XYZ,XYZ,9999,9999,XYZ,XYZ,1. XYZ,XYZ,9999,9999,9999,9999,XYZ,9999,XYZ,XYZ,XYZ,9999,XYZ,9999,XYZ,9999,XYZ,9999,9999,XYZ,XYZ,XYZ,XYZ,9999,XYZ,9999,XYZ,XYZ,XYZ,XYZ,XYZ,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,XYZ XYZ,XYZ,XYZ,XYZ,XYZ,XYZ,XYZ,9999,9999,XYZ,XYZ,1. XYZ,XYZ,9999,9999,9999,9999,XYZ,9999,XYZ,XYZ,XYZ,9999,XYZ,9999,XYZ,9999,XYZ,9999,9999,XYZ,XYZ,XYZ,XYZ,9999,XYZ,9999,XYZ,XYZ,XYZ,XYZ,XYZ,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,XYZ XYZ,XYZ,XYZ,XYZ,XYZ,XYZ,XYZ,9999,9999,XYZ,XYZ,1. XYZ,XYZ,9999,9999,9999,9999,XYZ,9999,XYZ,XYZ,XYZ,9999,XYZ,9999,XYZ,9999,XYZ,9999,9999,XYZ,XYZ,XYZ,XYZ,9999,XYZ,9999,XYZ,XYZ,XYZ,XYZ,XYZ,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,XYZ XYZ,XYZ,XYZ,XYZ,XYZ,XYZ,XYZ,9999,9999,XYZ,XYZ,1. XYZ,XYZ,9999,9999,9999,9999,XYZ,9999,XYZ,XYZ,XYZ,9999,XYZ,9999,XYZ,9999,XYZ,9999,9999,XYZ,XYZ,XYZ,XYZ,9999,XYZ,9999,XYZ,XYZ,XYZ,XYZ,XYZ,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,XYZ XYZ,XYZ,XYZ,XYZ,XYZ,XYZ,XYZ,9999,9999,XYZ,XYZ,1. XYZ,XYZ,9999,9999,9999,9999,XYZ,9999,XYZ,XYZ,XYZ,9999,XYZ,9999,XYZ,9999,XYZ,9999,9999,XYZ,XYZ,XYZ,XYZ,9999,XYZ,9999,XYZ,XYZ,XYZ,XYZ,XYZ,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,XYZ XYZ,XYZ,XYZ,XYZ,XYZ,XYZ,XYZ,9999,9999,XYZ,XYZ,1. XYZ,XYZ,9999,9999,9999,9999,XYZ,9999,XYZ,XYZ,XYZ,9999,XYZ,9999,XYZ,9999,XYZ,9999,9999,XYZ,XYZ,XYZ,XYZ,9999,XYZ,9999,XYZ,XYZ,XYZ,XYZ,XYZ,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,XYZ XYZ,XYZ,XYZ,XYZ,XYZ,XYZ,XYZ,9999,9999,XYZ,XYZ,1. XYZ,XYZ,9999,9999,9999,9999,XYZ,9999,XYZ,XYZ,XYZ,9999,XYZ,9999,XYZ,9999,XYZ,9999,9999,XYZ,XYZ,XYZ,XYZ,9999,XYZ,9999,XYZ,XYZ,XYZ,XYZ,XYZ,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,XYZ XYZ,XYZ,XYZ,XYZ,XYZ,XYZ,XYZ,9999,9999,XYZ,XYZ,1. XYZ,XYZ,9999,9999,9999,9999,XYZ,9999,XYZ,XYZ,XYZ,9999,XYZ,9999,XYZ,9999,XYZ,9999,9999,XYZ,XYZ,XYZ,XYZ,9999,XYZ,9999,XYZ,XYZ,XYZ,XYZ,XYZ,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,XYZ XYZ,XYZ,XYZ,XYZ,XYZ,XYZ,XYZ,9999,9999,XYZ,XYZ,1. XYZ,XYZ,9999,9999,9999,9999,XYZ,9999,XYZ,XYZ,XYZ,9999,XYZ,9999,XYZ,9999,XYZ,9999,9999,XYZ,XYZ,XYZ,XYZ,9999,XYZ,9999,XYZ,XYZ,XYZ,XYZ,XYZ,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,XYZ XYZ,XYZ,XYZ,XYZ,XYZ,XYZ,XYZ,9999,9999,XYZ,XYZ,1. XYZ,XYZ,9999,9999,9999,9999,XYZ,9999,XYZ,XYZ,XYZ,9999,XYZ,9999,XYZ,9999,XYZ,9999,9999,XYZ,XYZ,XYZ,XYZ,9999,XYZ,9999,XYZ,XYZ,XYZ,XYZ,XYZ,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,XYZ XYZ,XYZ,XYZ,XYZ,XYZ,XYZ,XYZ,9999,9999,XYZ,XYZ,1. XYZ,XYZ,9999,9999,9999,9999,XYZ,9999,XYZ,XYZ,XYZ,9999,XYZ,9999,XYZ,9999,XYZ,9999,9999,XYZ,XYZ,XYZ,XYZ,9999,XYZ,9999,XYZ,XYZ,XYZ,XYZ,XYZ,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,9999,XYZ
Extract from log: 42802 %Import_csv("&out_fld.\Financial Reporting Database (DUMMY).csv", act);
NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary
parameter values will be saved to WORK.PARMS.PARMS.SLIST.
dqstring=1. XYZ
fmt=
dqstring=1. XYZ
fmt=
dqstring=1. XYZ
fmt=
dqstring=1. XYZ
fmt=
dqstring=1. XYZ
fmt=
dqstring=1. XYZ
fmt=
dqstring=1. XYZ
fmt=
dqstring=1. XYZ
fmt=
dqstring=1. XYZ
fmt= As you can see there are a large number of variables, and so have avoided a data step where I would have to define each variable? Also we like the generic use of Import/Export macros that can be used across our project. As I said this had worked on 32-bit with Office 2010 so not sure if there are any changes to 64-bit and Office 16 that would cause this issue... Thanks Shaneel
... View more