How to export dataset into a pivot table in specified sheet?

[KarthikSrivasthav]

Hi All,

Pleas help me to export a data set into a pivot table.

Thanks ...

Regards

Karthik

[JatinBansal]

Hi

http://www.sas.com/offices/NA/canada/downloads/UserGroups/CSUG-May2013/Eberhardt-PivotTables.pdf

[Vish33]

Hi Karthik,

summarize the data first and

Using autofilter='yes' option u can put filters to the variables using SAS Tagsets.ExcelXP.

[Peter_C]

If you have already prepared your pivot table and only need to have data written into the data range of the pivot table there ils a simple way if you have a SAS/ACCESS product that will allow you to use an excel  data range name like a sas dataset. It just needs a libname statement using SAS/ACCESS to ODBC  or  SAS/ACCESS to PC Files along with an excel range name addressing the data area of the pivot.

Would that help in this case?