topic Macro year could not be recognized? in SAS Programming

Macro year could not be recognized?

ybz12003 — Fri, 28 Jan 2022 15:05:54 GMT

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;

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.

Re: Macro year could not be recognized?

novinosrin — Fri, 28 Jan 2022 15:08:36 GMT

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

sheet= "&year"

  sheet=&year.;

Re: Macro year could not be recognized?

japelin — Fri, 28 Jan 2022 15:10:24 GMT

The sheet name should be quoted as follows

sheet="&year.";