topic Re: How to call macro in excel sheet name proc import in SAS Programming

How to call macro in excel sheet name proc import

ilearnsas — Thu, 24 Oct 2019 16:46:01 GMT

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;

Re: How to call macro in excel sheet name proc import

PaigeMiller — Thu, 24 Oct 2019 16:48:47 GMT

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.

Re: How to call macro in excel sheet name proc import

ilearnsas — Thu, 24 Oct 2019 16:58:06 GMT

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