topic Re: Macro resolution in Enterprise Guide in SAS Programming

Macro resolution in Enterprise Guide

NithinRamu — Wed, 20 Oct 2021 16:21:32 GMT

I want to dynamically import a filename depending on the month and year. For example, for October 2021 the filename I want to import is exco_fte_202110. I have the following code, which works in SAS Studio. However, in Enterprise Guide, I get the note: "NOTE: The quoted string currently being processed has become more than 262 bytes long. You might have unbalanced quotation marks."

%let sysmonth= %sysfunc(putn("&sysdate"d, MONTH2.)); %let sysyear= %sysfunc(putn("&sysdate"d, YEAR4.)); %put OracLib.exco_fte_&sysyear.&sysmonth.;

Something minor is missing - what is it?

Re: Macro resolution in Enterprise Guide

Reeza — Wed, 20 Oct 2021 16:25:42 GMT

Can you post the full log? That error sometimes relates to the autogenerated code than your code.

Something like this would probably be just as easy:

%put OracLib.exco_fte_%sysfunc(today(), yymmn6.);

Re: Macro resolution in Enterprise Guide

Reeza — Wed, 20 Oct 2021 16:31:17 GMT

SYSDATE is an automatic macro variable but it's when the session started.
If you're on a server, this may not return what you expect, so do you want to use the TODAY() function instead?
https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/mcrolref/n08zfkx3lmiagpn11fctkfvfx1sg.htm

Re: Macro resolution in Enterprise Guide

ballardw — Wed, 20 Oct 2021 18:04:15 GMT

Check the quotes around your file name and any options in the step you actually export the data. Look for mismatched quotes.

Or copy your log, open a text box on the forum with the </> icon and paste the log showing the code and error message(s).