The SAS Output Delivery System and reporting techniques

ods tagsets.excelxp & proc freq

Reply
Contributor
Posts: 47

ods tagsets.excelxp & proc freq

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?
Super Contributor
Super Contributor
Posts: 3,174

Re: ods tagsets.excelxp & proc freq

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.
SAS Employee
Posts: 174

Re: ods tagsets.excelxp & proc freq

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
Contributor
Posts: 52

Re: ods tagsets.excelxp & proc freq

Posted in reply to David_SAS
Has a solution been found for this?

Kim LeBouton
SAS Super FREQ
Posts: 8,868

Re: ods tagsets.excelxp & proc freq

Posted in reply to KimLeBouton
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
SAS Employee
Posts: 95

Re: ods tagsets.excelxp & proc freq

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
Contributor
Posts: 52

Re: ods tagsets.excelxp & proc freq

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
SAS Super FREQ
Posts: 8,868

Re: ods tagsets.excelxp & proc freq

Posted in reply to KimLeBouton
I completely understand! The tagset solution would be the better way to go.

cynthia
N/A
Posts: 0

Re: ods tagsets.excelxp & proc freq

When and where can we expect V1.110 to appear?
Ask a Question
Discussion stats
  • 8 replies
  • 289 views
  • 0 likes
  • 7 in conversation