Friday, April 30, 2010

How to Import Data / Create Pivot Tables from SAS data into Excel 2007

In Excel 2007, select the Data Connection Wizard as your data source.

Choose the Other/Advanced option.
















In the Provider tab, select SAS IOM Data Provider 9.1 (or whatever version).


In the Connection tab and assuming a local SAS installation, you just need to fill in the «SAS Machine DNS Name» as localhost.



In the All tab locate the «SAS Workspace Init Script».



 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 


Double click to edit the property value and fill in a SAS libname statement to inform SAS where your data is located.

Press OK.

Press OK again and wait till the following screen appears.

Search for your table.

Press Next.

Save the Data Connection File (if you want) and press Finish.
The following windows appears

Select the appropriate and you're done.

2 comments:

  1. Thanks for the tip. What should I do if I can't find SAS Workspace Init Script in the All tab?

    ReplyDelete
  2. The quick answer is, if possible just put your data in SASUSER.

    ReplyDelete