DATA Step, Macro, Functions and more

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

Reply
Contributor
Posts: 22

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

Hi All,

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

Thanks ...

Regards

Karthik

Occasional Contributor
Posts: 11

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

Frequent Contributor
Posts: 117

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

Hi Karthik,

summarize the data first and

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

Valued Guide
Posts: 2,175

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

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?

Ask a Question
Discussion stats
  • 3 replies
  • 1008 views
  • 3 likes
  • 4 in conversation