Hi < I am trying to output 3 tables agegrp, race_txt and ethnic using ods tagsets using the below code. The file is generated at the given path but when i try to open the file it gives error "Problems came up with the following area in during the load" "This file cannot be opened because of error.errors are listed in "C/Users/app/...." title ''; ods tagsets.excelxp file="filepath..\list_outp.xml" style=sasweb; ods tagsets.excelxp options (sheet_name="list_2012" embedded_titles="yes" sheet_interval="none"); proc freq data=list_2012; tables agegrp race_txt ethnic; title "count of subjects"; run; I am using sas 9.4 . Pl help.
I forgot to use close statement as suggested by you. Now i am getting all the multiple sheets in excel and its open without any error.
Thaks,
Jeetender
2025 SAS Hackathon: There is still time!
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!