How to create a pivot type of report in an excel using ods?

[krishnaboosireddi]

Hi ,

     I want to create a pivot type of report in excel using ods?

Can any one help me with suggestions and if possible with the sample codes.

Thanks,

Reddi krishna

[ballardw]

It's easy to create an ods output that has the results of a pivot and then export to Excel. Is that what you want?

Search the forum for tagsets.excelxp and proc tabulate or proc report.

Or do want an actual Excel pivot?

[Reeza]

TRY ODS TABLEEDITOR (Google it)

http://support.sas.com/rnd/base/ods/odsmarkup/tableeditor/

Hard to provide code with the little information you've provided.

If you want code, provide samples of what you want, via images.