Hi, I am trying to create an excel document from data I have. I am using Base SAS 9.3 The code I am using for that is: ods _all_ close; ods tagsets.ExcelXP file='TEST2.xls' style=Printer path= '$HOME/' options(sheet_name="="DDJanYY"); proc tabulate data = TableTEST; ..... .....[SPECIFICATIONS OF THE TABLE] ..... run; ods tagsets.ExcelXP close; However, when trying to create the excel document I have this error. 411 ods _all_ close; Error opening file. File =/usr/users/uxxxxxxxx/TEST2.xls. System Error Code = 49. 412 413 ods tagsets.ExcelXP file='TEST2.xls' Path='/usr/users/uxxxxxxxx/' style=Printer 413! options(sheet_name="DDJanYY"); NOTE: Writing TAGSETS.EXCELXP Body file: TEST2.xls ERROR: Invalid open mode. ERROR: No body file. TAGSETS.EXCELXP output will not be created. Where /usr/users/uxxxxxxxx/ is my HOME environment [%let home = %sysget(HOME); %put &home.; /usr/users/uxxxxxxxx] It looks to me as if I did not have writing permissions for my HOME environment but I don't know why. I have tried to create the excel in a specified path I change instead of $HOME/, For example 'C:My documents\whatever\' but the error I get is something like this 411 ods _all_ close; Error opening file. File =/usr/users/uxxxxxxxx/TEST2.xls. System Error Code = 49. 412 413 ods tagsets.ExcelXP file='TEST2.xls' Path='/usr/users/uxxxxxxxx/C:My documents\whatever\' style=Printer 413! options(sheet_name="DDJanYY"); NOTE: Writing TAGSETS.EXCELXP Body file: TEST2.xls ERROR: Invalid open mode. ERROR: No body file. TAGSETS.EXCELXP output will not be created. Does anyone know why I get this error and how to solve it? I am completely new to SAS and I apologize in advance if there are mistakes in my explanation. Many thanks, Laura
... View more