topic Re: ods tagsets.excelxp & proc freq in ODS and Base Reporting

ods tagsets.excelxp & proc freq

qkaiwei — Sun, 13 Sep 2009 16:25:35 GMT

I used ods tagsets.excelxp to export the cross table of proc freq, but found all cells of the cross table were empty. Anyone once met the same thing?

Re: ods tagsets.excelxp & proc freq

sbb — Sun, 13 Sep 2009 16:27:51 GMT

SAS version? Tagset version? Any errors or warnings? What results do you get when you do not override with ODS destination - does a FREQ report get generated to SAS list? This information would be most helpful - also post your SAS code as well for feedback.

Scott Barry
SBBWorks, Inc.

Re: ods tagsets.excelxp & proc freq

David_SAS — Mon, 14 Sep 2009 14:24:12 GMT

A problem using FREQ crosstabs with the ExcelXP tagset in 9.2 has been reported to Technical Support and verified by R&D. We're working on a solution.

-- David Kelley, SAS

Re: ods tagsets.excelxp & proc freq

KimLeBouton — Tue, 08 Jun 2010 19:41:35 GMT

Has a solution been found for this?

Kim LeBouton

Re: ods tagsets.excelxp & proc freq

Cynthia_sas — Tue, 08 Jun 2010 20:35:23 GMT

Hi;
You could run a TABULATE step instead of FREQ. It won't give you quite the same look (no stacking), but you can get the same numbers.

cynthia

Re: ods tagsets.excelxp & proc freq

Eric_SAS — Wed, 09 Jun 2010 13:31:58 GMT

This problem is addressed in the latest version of the tagset v1.110.
The tagset has been submitted to our web administrator and should be available within a week.

Eric

Re: ods tagsets.excelxp & proc freq

KimLeBouton — Wed, 09 Jun 2010 15:33:41 GMT

Thanks for the replies.

We can now keep moving forward with our transition to SAS 9.2.

I had decided not to mention the PROC TABULATE option to my user as a solution. I wasn't up for the negative comments on a working program in the older version and now having to move to a new PROC.

Kim

Re: ods tagsets.excelxp & proc freq

Cynthia_sas — Wed, 09 Jun 2010 16:26:44 GMT

I completely understand! The tagset solution would be the better way to go.

cynthia

Re: ods tagsets.excelxp & proc freq

deleted_user — Fri, 18 Jun 2010 06:46:14 GMT

When and where can we expect V1.110 to appear?

Re: ods tagsets.excelxp & proc freq

shubhayang — Mon, 18 Jun 2018 21:20:58 GMT

Looks like you missed:

ods tagsets.excelxp close;
RUN;