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).
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: