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?

Posted in reply to KarthikSrivasthav
Frequent Contributor
Posts: 117

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

Posted in reply to KarthikSrivasthav

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,177

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

Posted in reply to KarthikSrivasthav

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
  • 1081 views
  • 3 likes
  • 4 in conversation