SAS Studio vs SAS Window Environment compatibility issue

[casmcfarland]

I have used the SAS Window environment for years, and I have a new staff who prefers SAS Studio. We are having issues when I run files and update data, her data does not update in Studio. The files are uploaded to sharepoint, and I have two different computers that I use and the issue is not sharepoint, it is something with the way studio updates the data and I don't know how to help her. As an aside, I was told that no one uses window environment anymore that studio is what everyone uses, I find that really hard to believe...

[Tom]

I doubt the issues is simply DMS vs SAS/Studio.

Instead you need to understand the physical environment.

1. Where is SAS running in both cases.   
   1. Are you running DMS with SAS on your personal computer?  Or are you using DMS running on some share server? Is the shared server running Windows or Unix?
   2. Are all of the SAS/Studio users connecting to the same application server to run SAS? Is it running on Windows on Unix?
2. What files are accessible.
   1. Where are the input and output files?  Are they on a share drive?  Does everyone have the same access to the those locations?
3. What do you mean about Sharepoint?   Sharepoint is a website.  How are you moving files from your SAS job into Sharepoint.

If you are using some type of automatic synch system like OneDrive to keep local and remote files in synch perhaps that is ot working the way you expect.

[casmcfarland]

All files are shared with everyone on the team having access. We use a desktop license version of SAS. All files are synced between the computer and the cloud server which uses a windows environment. We have confirmed that the files on the cloud server are the up-to-date files and I can use them from both my laptop and my desktop. When she tries to pull the updated files from the cloud...SAS studio will not pull the up-to-date files. We are now thinking it is a computer issue not a SAS issue. 

[SASKiwi]

Please bear in mind that SAS Studio is a web-based app that runs a SAS session on a remote SAS application server. That SAS session is run within an OS session created under the SAS user's login account - assuming you are using SAS 9 here. So the tricky thing is making the connection from the SAS App or Web server to the cloud-based server where your files reside. Any number of things could be preventing this happening including incorrect delegation of user permissions, SAS server firewall rules blocking access and so on and so forth.

Best to engage with your IT network and security specialists to sort this out.  

[ballardw]

---

@casmcfarland wrote:

I have used the SAS Window environment for years, and I have a new staff who prefers SAS Studio. We are having issues when I run files and update data, her data does not update in Studio. The files are uploaded to sharepoint, and I have two different computers that I use and the issue is not sharepoint, it is something with the way studio updates the data and I don't know how to help her. As an aside, I was told that no one uses window environment anymore that studio is what everyone uses, I find that really hard to believe...

---

Can you share examples of the code you and the other use actually run to do this? It sounds like you may not be looking at the same location in Sharepoint if you update data and the other user does not see changes.

Also, how much time passes between your update and the other persons attempt to access it? I have occasional instances where I don't get the latest version of a data set I write because I am forced to work on OneDrive and apparent network issues mean that a program that writes a data set and then reads that output set for the next step can find a previous version of a replaced data set for several minutes.