BookmarkSubscribeRSS Feed
Q1983
Lapis Lazuli | Level 10

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.

             outfile=&Outfile.

            dbms=EXCELCS replace;

                sheet=&Sheetname.;

            server='XX22544';

run;

%Mend;

%Export (Summary_Yr_Total,"Yr_Total");

%Export (Summary_Yr_Risk_Port,"Yr_Risk_Port");

%Export (Summary_Inv_DQ,"Inv_DQ");

%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;

                                                         -

                                                         22

ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string. 

1 REPLY 1
Tom
Super User Tom
Super User

You are referencing the macro variable OUTFILE but it is not defined anywhere in the code you posted.

CFC_SAS_Communities_400x225.jpg

Call for content now open!

It's your turn to help shape SAS Innovate 2027. Share your expertise and inspire the SAS community.

Submit your proposal →

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1762 views
  • 0 likes
  • 2 in conversation