ods tagset.excelxp error in excel file

[jeetendersinghc]

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.

[Reeza]

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

[SuryaKiran]

Hello,

Welcome to SAS Community!

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

ods tagsets.excelxp close;

[jeetendersinghc]

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