Sorry if this is the wrong place, this is my first post. Basically I need to make >100 tables using the Output Delivery System. My proc tabulate statement itself works fine on its own, but the ods is not. %let question=value; ods html body = '&question.xls' style=minimal; here is the proc tabulate that is working fine ods html close; Now, the excel file is successfully being created, but it is literally called &question.xls, when I would want it to be called value.xls so it doesn't continually overwrite itself. If there's a way to throw an array in here and just make one excel file with all >100 tables, that would also be good. I've been using SAS for about a month so sorry if these are totally n00b questions and thank you for reading and for any help you can give me.
... View more