07-28-2016 10:01 PM
Can someone help please help me find a solution to the below problem?
SAS reads data from sharepoint. But if the connection to SharePoint is broken SAS stops its process. Could somebody please help me to find a method/SAS function to know that the connection to Sharepoint is broken. If my question is not clear please do let me know so I can elaborate it further more.
07-29-2016 04:47 AM
Why would your "connection" to Sharepoint be broken? How is it connected? You can setup a drive mapping in your OS directly to Sharepoint (your IT can provide information), and you just reference that network drive. If you mean you might not have access to the internet or something at that time, then a simple check of fileexist('path_to_sharepoint\file.txt')=0, will result in 0 if that area does not exist (note replace the path, and the file with something you know is there).
Do remember however that Sharepoint isn't a "working" environment for SAS, you shouldn't use it as a data warehouse or such like.
07-30-2016 10:04 PM
Thank you for the reply. Due to certain restrictions in the company I have to use SP as a small dataware house. I know that SP is not a good one to rely on too. I do have a mapping file that connects to the SP. Sometimes SP is down(no connection) and at that time the datasets can not be read from SP.
If I can type in a function that lets SAS know, that there is no connection to SP, then I can alter the program in such a way to go around such situations.Please do ask me for more details if that can help you suggest some solutions.
07-31-2016 05:40 AM
I agree with @LinusH, Sharepoint is a Document Management Platform. It has no features associated with data capture/collection/storage and using it as such will cause you many problem - as you are noting with this "connection" you talk about. This mapping file you have must be something unique to your company, so nobody outside will be able to help you with that setup, nor is it a SAS problem. I would advise you speak to your IT people and ask them to setup a network area to store data and programs on.
07-31-2016 10:35 AM
Yes, the mapping file is created by the IT person, all it has are the Listing and Viewing IDs for the libraries that are used by sas in SP.
But in a jist this is how the process works...
1. SP has one library(lib-1) and inside that has 5 lists(list1-list5).
2. The Mapping file will have the List IDS for the Lists1-5.And the site path/address to reach the SP.
3. SAS reads the mapping file and goes to each of the Lists and gets the data from that list.
If the connectivity to SP breaks/no connection then while doing step 3, SAS stops because there is no connection to SP. My problem is to find out a way to make sas know that the connection to SP is broken and so dont stop, do something else.
07-31-2016 10:49 AM
As I mention above, you have some very odd setup, created specifically for your company, it is up to your IT group to supply the required information, be that as a feedback from this "connection" file, or some other method. Again, this isn't a SAS problem, but a problem with your setup.
07-31-2016 04:36 AM
07-31-2016 10:17 AM
I apologize for the confusion. What I really ment is that SP is a publishing place from where SAS reads the data. I am not so good with DW, so I thought of it as a small scale DW. I think you have good experience with SAS and SP, can you please suggest me an idea to tackle my problem.?
07-31-2016 10:55 AM