Hi -- has anyone exported to Excel using a dynamic, variable filename? I have a global variable with value assigned by a "%let" statement that I want to set to the Excel file name that I'm exporting to. I've seen DDE documentation and a macro called %exporttoXL, but I'm not sure that extent is needed or whether either approach will suit my simple need here. THanks for any tips!
Please explain more about what determines the "dynamic, variable filename"? Also, have you considered PROC EXPORT and using the macro variable approach to resolve the PC file name in a prior DATA step or PROC SQL (again, your advance SAS processing component has not been stated/identified at this point).
Hi -- I'm on v 9. Your suggestion about using a macro is something I had tried, except I was using a constant string value concatenated with a macro variable for the file name. Instead, I will try putting everything including the constant string in the macro variable rather than trying to do the concatenation. Thanks
You can concatenate a constant string with macro variables. Consider the LOG view of some %LET statements and the resulting %PUT output. You just have to remember the rules of how to concatenate and reference macro variables.