SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

SAS Connection in Excel refresh data with non sas users

Reply
Occasional Contributor
Posts: 10

SAS Connection in Excel refresh data with non sas users

I have created a sas dataset that I update daily.   The excel document has been placed within Sharepoint. A pivot table in excel uses the sas dataset as a datasource via SAS Local Data Provider 9.4.  End users for the document do not have SAS and receive an error: "The Initialization of the dta source failed. Check the database server or contact your database administrator. Make sure the external database is available, and then try the operation again. If you see this message again, create a new data source to connect to the database."  I would like my users to be able to refresh the data even though they do not have SAS. Other coworkers having SAS installed on their machines ARE able to refresh the datasource. Any suggestions to enable non SAS havers to update the dataset through excel?

 

Thank you.

 

Grand Advisor
Posts: 16,367

Re: SAS Connection in Excel refresh data with non sas users

I'll let someone else comment on whether it's possible or not with the SAS tools.

 

When we have to deliver this, we set the datasource as a text file and update that via SAS. The rest of the process is identical. This is a workaround though. 

Occasional Contributor
Posts: 10

Re: SAS Connection in Excel refresh data with non sas users

How do you create the pivot table using the txt file as the data source? I am only getting errors saying it is not a valid data source type.
Post a Question
Discussion Stats
  • 2 replies
  • 80 views
  • 0 likes
  • 2 in conversation