How can I link pivot table in excel with SAS data set?




I have a SAS data set with more than 1.5 million observations but SAS is not installed on my machine. Here I want to create a pivot table with this data set as source. Is there a way to create a connection between Excel and SAS data set?

Any help will be appreciated.



The easiest way would be to install SAS Add-in for Excel. Once installed, you will need to connect to the SAS server and you can then import data directly into pivot tables.

This will enable you to get any number of observations into a pivot table and then you can summarize them easily.

Normally, the Add-in comes along with SAS installation and is usually very handy to create connection between SAS & Excel.