01-02-2014 03:54 AM
summarize the data first and
Using autofilter='yes' option u can put filters to the variables using SAS Tagsets.ExcelXP.
01-02-2014 05:37 PM
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?