How to call macro in excel sheet name proc import

[ilearnsas]

Hi, I am trying to call a sas macro within the excel sheet name using proc import. I tried below. But &yr is not resolving. Please help. Thanks! 

%let yr=%sysfunc(intnx(day,%sysfunc(today()),0,B),year.);
%put &yr;

proc import datafile=innfile out=data
dbms=xls replace;
sheet="1PMMS&yr.";
getnames=no;
datarow=8;
run;

[PaigeMiller · Accepted solution]

Please re-run the code with the following as the first line

options mprint symbolgen mlogic;

Show us the SAS log for this step, both the code and any ERROR messages. Please click on the {i} icon and paste the log into this window that appears ... do not skip this step.

[ilearnsas]

I re ran the same with options statement and it worked just fine. Not sure what the issue was. Thank you! Appreciate it.