topic Re: Import Data into a project from CSV files on SAS Linux server in SAS Enterprise Guide

Import Data into a project from CSV files on SAS Linux server

tomw — Fri, 06 Dec 2019 21:23:56 GMT

We have Enterprise Guide 7.15 desktop users that want to use the Import Data feature to bring in data from CSV files that are already on the SAS linux server, but when the Open dialog comes up, and they click on Servers then SASApp, the only directory they see is Home (which is pointing to their private /home/{whoever}) directory on the server.

I would like them to be able to navigate to /sasdata/{theridepartment} and be able to see the files in that directory. I've tried just typing the linux path and file name /sasdata/finance/claims.csv into the file name field, but get the error "Item '/sasdata/finance/claims.csv' does not exist"

If the file was in /home/{myusername}/claims.csv, our users could import just file, except the automated process puts the files in a shared department location.

Re: Import Data into a project from CSV files on SAS Linux server

Kurt_Bremser — Fri, 06 Dec 2019 21:40:46 GMT

@tomw wrote:

We have Enterprise Guide 7.15 desktop users that want to use the Import Data feature to bring in data from CSV files that are already on the SAS linux server, but when the Open dialog comes up, and they click on Servers then SASApp, the only directory they see is Home (which is pointing to their private /home/{whoever}) directory on the server.

I would like them to be able to navigate to /sasdata/{theridepartment} and be able to see the files in that directory. I've tried just typing the linux path and file name /sasdata/finance/claims.csv into the file name field, but get the error "Item '/sasdata/finance/claims.csv' does not exist"

If the file was in /home/{myusername}/claims.csv, our users could import just file, except the automated process puts the files in a shared department location.

Either change (or have changed) the root navigation path of SASApp, or create a symbolic link in the user's home directories that points to /sasdata.

Re: Import Data into a project from CSV files on SAS Linux server

tomw — Tue, 10 Dec 2019 14:57:18 GMT

Thank you, perfect. from your message, i was able to search and find http://support.sas.com/kb/59/828.html support document, and this is what i was looking for.