BookmarkSubscribeRSS Feed
Ankan2
Calcite | Level 5
Can any one help me with how to connect power pivot with a SAS dataset?
5 REPLIES 5
SuryaKiran
Meteorite | Level 14

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 

Thanks,
Suryakiran
r_behata
Barite | Level 11

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
Calcite | Level 5

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

LinusH
Tourmaline | Level 20
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).
Data never sleeps
EthanSnow
Calcite | Level 5
I like your answer, which is relevant and insightful, not pretending to know the answers and not making totally non value adding comments.