Hi - I'm trying to automate something in SAS, but I'm very rusty. I want to create a macro variable that reflects the current months date that I can use to identify a dataset in a proc sql later on. I've already set up a macro variable which gives me the first of the current month in a date format - I'll call this ¤tmonth I want to use this data to identify a dataset that we'll call libname.accounts201707. So I create a variable like this: %let currfile = year(&currmonth)||month(currmonth); which should resolve to 201707, yes? But when I create the proc sql: proc sql; create table example as select field1, field2 from libname.accounts&currfile; quit; it doesn't work as it's looking for: libname.accountsyear(&currmonth)||month(currmonth) rather than libname.accounts201707 I feel like I'm so close to cracking this but it's getting the better of me...? Any help?
... View more