@soontobeexpert wrote:
Doing my best to learn ODS here..
This is not ODS.
I also attempted to use the filename fileout approach referenced here
https://communities.sas.com/t5/SAS-Enterprise-Guide/Exporting-text-field-to-txt-file-without-quote-qualifiers/td-p/138377
but wasnt able to figure out how to make it work with multiple columns of macro variables. For example, one of my column headings is =%substr("current_year.",4,2)'Q1'; Without rewriting the logic of the program, I couldnt figure out how to make these type of headings work with the approached referenced above
This would the correct approach, one PUT statement for your headers which can have whatever format you want.
And one PUT statement for your data. I would consider revisting this approach, posting what you've tried and what didn't work. Use a representative sample including your macro variables.
... View more