How to read a SAS dataset which is hosted on a Unix Server

Hello, I am trying to read a SAS dataset which is hosted on a Unix server and the script below does not work.
It work fine when the dataset is located a my C drive but not a the Unix server. I would like to able to read a SAS dataset on a Unix Server directly because file transfer on my c drive will cause safety issue.

required(sas7bdat)
Class <- read.sas7bdat("//finsys/bicoe/test/class.7bdat")


I'm not sure the issue is with the function but specifying the path. If you do ls("//finsys/bicoe/test"), is the file shown? If not, you're not specifying the folder path correctly.

Hello Stephanie,

I am new to the usage of R language. Also, the difficulty I am facing, is that R is installed on my window based computer while my SAS file is hosted on a UNIX server.

I will need to find a way to permit R to communicate with my Unix server.

Maybe something like that:

install.packages("curl")
require("curl")
handle <- new_handle()
handle_setopt(handle, username = "domain\username")
handle_setopt(handle, password = "secret") # If needed
request <- curl_fetch_memory("smb://host.example.com/share/file.txt", handle = handle)
contents <- rawToChar(request$content)

But it is not clear for me how to make the ls command as you have suggested and from there read the sas file

I would suggest the following approach:

  1. Find out the IP Address or hostname of your windows machine (e.g. 192.168.0.99)
  2. Find out the full path where your SAS datasets are stored (e.g. /finsys/bicoe/test). This will become your share-name.
  3. Make sure the NFS server on the UNIX server is running
  4. Add a new line to the file /etc/exports on the UNIX server where you write
/finsys/bicoe/test 192.168.0.19(ro)

The above line will export the folder to your windows machine read-only(ro) to prevent accidental changes to the SAS data sets (if undesired, change ro to rw for read-write)

  1. Re-export all the NFS file systems including the new ones via
exportfs -aR 
  1. Mount NFS share on your windows machine following Network File System (NFS): Mount an NFS Share on Windows | IT@UMN | The people behind the technology

Note:

  • Steps 2 to 4 will need admin privileges on the UNIX server
  • Alternatives to the above approach would be to use
    * CIFS/SMB
    * fuse-sshfs (GitHub - winfsp/sshfs-win: SSHFS For Windows) - relies on ssh connection to the UNIX server

Happy to discuss more as needed.

Michael.

Hello Michael,

Steps 0, 1 and 2 are clear, but I don't understand what is required in step 3 (add a new line to the file / tec/reports on the Unix server where you write

/finsys/bicoe/test 1988.168.0.19(ro) ?

I though that we need to send instruction through Microsoft R Open

I am able to read the sas file on my drive P (windows server)

library(sas7bdat)
require(sas7bdat)
class2 <-read.sas7bdat("P:/TEST/FILE1684/class.sas7bdat")

I am not able to do the same task in Microsoft R Open via our unix sever.
Do we really need to export the data on the window server ?

I would prefer to connect via ssh protocol then do the same task as for the P Drive.
Is it possible to do that and if so how ?

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.