First I would like to ask that any help be provided in a simple to understand manner. I am not a coder, I use EG point and click interface 😉 I have a report and I'm using a list task to group by "category" and I would then like to export to excel, where each category has it's own excel tab. I found a solution on the interwebs to modify my list task by inserting custom code as follows: ods tagsets.excelxp file='multisheet.xls' options( sheet_interval='bygroup'); The above works, but I cannot access the file, because SAS puts it in the following directory: /sas5/opt/SAS_9.3/config/Lev1/SASApp I tried to change the path to one I had access to and is my usual SAS export location: \\safedata\SHARED.DATA\Vendor Relations\Business Analysis\SAS\Output\multisheet.xls But when I do that, it still appends the /sas5/opt/SAS_9.3/config/Lev1/SASApp directory first and I can't get to my file. I can see a file icon, which does have my data. I can then double click it, open it in excel and manually save my file, but this prevents me from automating my queries, which I'm being told is not an option. Through googling and working with my IT, I believe this is some sort of communication issue due to SAS being on a UNIX server. But they do not know how to fix. Please help! Appreciate your time in advance.
... View more
