My organization has started the move to Onedrive/MS 365, and we're trying to figure out the best way to utilize SAS with files stored in Onedrive or in Teams shared storage.
Prior to Onedrive, we did have Sharepoint as a location people could store files, and we didn't get requests to "open them in SAS" because nobody had a share mapped to a local folder (possible to do, of course, using WebDAV, but not common here). However, now that we all have our shares mapped to a local (c:\whatever\Onedrive) folder, we've had requests to be able to store non-sensitive data in these spaces but still be able to access them via SAS.
What are our options here? I have watched and read Chris Hemedinger's article on using the MS Graph API, and that seems like one possibility, but I tend to consider that "high difficulty"; while I certainly can, and will, use this, I suspect most of our users aren't technically savvy enough to implement this, even if I do as much of the work as possible for them - even if we get past the auth token step, the PROC HTTP access to files will probably be a level of difficulty past what they're comfortable with.
Our users are mostly "base SAS" users, who were converted to SAS Studio (90%) or Enterprise Guide (10%) using a 9.4TS1M7 SAS server a year or so ago. They're mostly doing data step/basic Stats procs, importing excel files either as actual data or as metadata to drive processing. Mostly just making SAS datasets, or basic reports (probably an exported dataset or a proc freq/print).
How do others solve this problem? Our ideal solution would be to have a network folder mapped to their Onedrive share and/or synced to Onedrive, but that doesn't seem to be possible. (It might be possible to do it using symlinks, but I don't think that's a good idea.) I also saw that it's possible to map a network drive using a URL, but it seems like that's pretty hack-y also and might not be possible for us, as it requires individual client tokens (we'd have to know what client token to use in the level_env_usermods.bat that would do the mapping, and I don't know how we'd do that without some sort of unsafe storage). We strongly prefer supported, and intended, solutions.
Possibilities I have come up with so far:
Solution
Difficulty
Feature
Graph API
High
Full ability to access files with no manual intervention
Copy files from c:\whatever\onedrive to \\network\share
Low
Entirely manual
SAS Office Add-In
Medium
Can do some things, but we don't use the cooler features, and probably more work to do the basic things
What else is out there? Anything better? Or is this just "how it is" for Onedrive, and people shouldn't use the shared storage for anything they want to use with SAS?
... View more
