09-16-2014 10:40 PM
I am attempting to perform a proc export on 4 datasets Sas is generating an syntax error based on the outfile. I am not sure what is wrong wit the syntax here.
Macro Export (Dataset,Sheetname);
proc export data=&Dataset.
%Export (Actives_Curr_Yr_Pl_5_Yrs,"Loan List");
SYMBOLGEN: Macro variable DATASET resolves to Summary_Yr_Total
NOTE 137-205: Line generated by the invoked macro "EXPORT".
3741 proc export data=&Dataset. outfile=&Outfile. dbms=EXCELCS replace; sheet=&Sheetname.; server='GA016A744'; run;
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string.