Connection to power pivot

[Ankan2]

Can any one help me with how to connect power pivot with a SAS dataset?

[SuryaKiran]

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 

[r_behata]

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. 

[EthanSnow]

You too. If he can settle for CSV export, he would have done so without posting any questions.

[LinusH]

You can also use OLEDB (requires a SAS OLEDB provider) or ODBC (requires a SAS ODBC driver and either a local SAS session, or a SAS server running SAS/SHARE and have the SAS/SHARE*NET license).

[EthanSnow]

I like your answer, which is relevant and insightful, not pretending to know the answers and not making totally non value adding comments.