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?
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).
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.