- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
Paige Miller
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
Paige Miller
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
I re ran the same with options statement and it worked just fine. Not sure what the issue was. Thank you! Appreciate it.