topic Re: Connection to power pivot in Microsoft Integration with SAS

Connection to power pivot

Ankan2 — Mon, 09 Dec 2019 20:04:10 GMT

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

Re: Connection to power pivot

SuryaKiran — Mon, 09 Dec 2019 20:18:56 GMT

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

Re: Connection to power pivot

r_behata — Mon, 09 Dec 2019 21:46:00 GMT

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.

Re: Connection to power pivot

EthanSnow — Mon, 01 Apr 2024 23:43:35 GMT

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

Re: Connection to power pivot

LinusH — Tue, 02 Apr 2024 13:12:50 GMT

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).

Re: Connection to power pivot

EthanSnow — Fri, 05 Apr 2024 05:01:15 GMT

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