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;
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.
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.
I re ran the same with options statement and it worked just fine. Not sure what the issue was. Thank you! Appreciate it.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.
Ready to level-up your skills? Choose your own adventure.