07-20-2016 12:37 AM
I have sas table called: EXPOSURE, I want to write a program in sas to export it to excel hidden sheet called 'premium' and want to create a pivot as shown below.
It should also show the list of value in filter drop down.
|YQTR||Sum of EARNED_EXPOSURE||Sum of WRITTEN_EXPOSURE||Sum of WRITTEN_PREMIUM||Sum of EARNED_PREMIUM|
07-20-2016 01:48 AM
This isn't a trivial task.
If you search on here you'll find some solutions for this situation, but the main issues are
1) export to specific location
2) create/update pivot table
A common work around is to create a template that is updated, source data replaced and there's an embedded Excel macro that refreshes the pivot table. Given that your using EG, you can't use DDE. Can you use an Excel macro? How are you envisioning this process working on your side?
07-20-2016 05:28 PM