03-01-2017 11:40 AM
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?
03-01-2017 12:16 PM
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.