Macro year could not be recognized?

[ybz12003]

Hello,

I have a macro code that shows an error message in the log window.  Please let me know how to fix it.

PROC EXPORT DATA=underlyspecify&year.
      outfile="Underly_Con_&bdate..xlsx"
      dbms=xlsx replace;
      sheet=&year.; 
run; 

Spoiler

Spoiler

 sheet=&year;
NOTE: Line generated by the macro variable "YEAR".
1 1819
    ----
22
200
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string.

ERROR 200-322: The symbol is not recognized and will be ignored.

[novinosrin · Accepted solution]

Hi @ybz12003  Perhaps enclose the &year in sheet within quotes?

sheet= "&year"

  sheet=&year.; 

[japelin]

The sheet name should be quoted as follows

sheet="&year.";