topic Re: about ods tagsets.excelxp proc tubulate in ODS and Base Reporting

about ods tagsets.excelxp proc tubulate

daisy6 — Thu, 25 Jan 2018 15:34:56 GMT

Hello SAS experts,

I use proc tabulate to create some tables and would like to output to excel file. My codes work if I do not use ODS to output to excel, however it does not work when I want it output to excel. The log window did not show any thing wrong, but I can not open xml file. I use SAS 9.3 version. Here is my code.

ODS noresults;
ODS listing close; /*Turn off the standard line printer destination*/
ods tagsets.ExcelXP path="&dir."
file="&client._All.xml"
style=statistical /*Styles to control appearance of output*/;
ods tagsets.ExcelXP options ( sheet_name= "Jurisdiction" autofit_height= 'yes' );

proc tabulate data=alldata;
class state subjects grade attempt_status;
table state, subjects=" "*(attempt_status=" " all="Total"), grade=" "*( N='Count'*f=comma8. rowpctn*f=mypct.) all;
run;

ods _all_ close;
ODS listing;

there are 54 states and 5 subjects.

Thanks for any suggestion.

Re: about ods tagsets.excelxp proc tubulate

Reeza — Thu, 25 Jan 2018 15:43:38 GMT

Does a different ODS destination work, say ODS PDF?

Also, what does this mean?

The log window did not show any thing wrong, but I can not open xml file

Do you get an error of any kind?

Re: about ods tagsets.excelxp proc tubulate

ballardw — Thu, 25 Jan 2018 16:18:29 GMT

Change the ODS NORESULTS; to ODS RESULTS;

NORESULTS tells SAS not to create any ODS output.

Re: about ods tagsets.excelxp proc tubulate

daisy6 — Thu, 25 Jan 2018 16:11:41 GMT

Thanks for the reply Reeza,

The log window did not have any error sign and it seems it is ok for the code. However, it shows something wrong when I open the XML file. I attached the capture here. I need xml file to reload the output data to SAS, so the PDF output is not my choice.

Re: about ods tagsets.excelxp proc tubulate

Reeza — Thu, 25 Jan 2018 16:13:15 GMT

The PDF is to test that you're getting any output and there isn't something else isn't wrong. I'm not suggesting you change your requirements, it's a debugging step.

@daisy6 wrote:

Thanks for the reply Reeza,

The log window did not have any error sign and it seems it is ok for the code. However, it shows something wrong when I open the XML file. I attached the capture here. I need xml file to reload the output data to SAS, so the PDF output is not my choice.

Re: about ods tagsets.excelxp proc tubulate

daisy6 — Thu, 25 Jan 2018 22:31:44 GMT

Hi SAS guys,

I upgrade my version to 9.4. I don't have that problem any more. Thanks for taking care of it.