topic Re: ods tagset.excelxp error in excel file in New SAS User

ods tagset.excelxp error in excel file

jeetendersinghc — Thu, 24 Jan 2019 18:53:41 GMT

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.

Re: ods tagset.excelxp error in excel file

Reeza — Thu, 24 Jan 2019 18:57:52 GMT

Please post your code using the code editor (see 6/7th icons in the editor) and also include the full log with the errors.

Re: ods tagset.excelxp error in excel file

SuryaKiran — Thu, 24 Jan 2019 19:06:43 GMT

Hello,

Welcome to SAS Community!

Are you missing the close statement for the destination at the end?

ods tagsets.excelxp close;

Re: ods tagset.excelxp error in excel file

jeetendersinghc — Thu, 24 Jan 2019 19:15:57 GMT

Thanks Suryakiran.

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