What are you trying to do, can you be more specific. Are you trying to access SAS dataset in Excel to create pivot table? Maybe SAS can do that too.
Do you have SAS Add-in for Microsoft Excel licence ?
You can check that by running proc setinit;
proc setinit;
run;
Check this out: SAS Add-in for Microsoft Office Support
Power Pivot allows you to connect to external sources apart from MicroSoft Products like Oracle, Teradata Sybase Etc.. But I do not see sas listed as one of the sources currently.
Try converting your SAS Dataset into CSV file if you are keen to leverage the advanced features offered by PowerPivot.
You too. If he can settle for CSV export, he would have done so without posting any questions.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!