topic Re: Transfer CSV from Windows to Linux/Unix Grid in SAS Programming

Transfer CSV from Windows to Linux/Unix Grid

ProcWes — Fri, 29 Jul 2022 16:12:00 GMT

I have SAS on Linux (unix?) grid under Citrix server. My CSV file is on a local or windows install. Is there anyway to read this file programmatically? I can do a copy files task and then import, but the copy files task isn't programmable. I can use proc import if it's Excel because i can specify server_name, but I cannot do this if dbms=csv. Are there any alternatives that I've missed?

Thanks

Re: Transfer CSV from Windows to Linux/Unix Grid

ChrisHemedinger — Fri, 29 Jul 2022 19:37:51 GMT

There is probably not a way for your remote/Citrix session to read the CSV from your local disk. As you say, Copy Files can help you with this in a SAS Enterprise Guide flow, but it doesn't help when running a plain batch SAS file.

Two alternatives:

- Rethink the policy of keeping the CSV files local and instead store them somewhere network-accessible for your SAS session. In our workplace we're lucky enough to have network shares that we can access from Windows (using UNC notation) and Unix (using traditional Unix-style paths).

- Use a process like FTP or other file-transfer process to move the file from your local PC to a place where the Unix SAS can get to it.

Re: Transfer CSV from Windows to Linux/Unix Grid

Kurt_Bremser — Sat, 30 Jul 2022 07:31:47 GMT

Use a network resource that is also mounted on the Linux server(s). Or store the file on a computer which has a SSH server, so you can use FILENAME SFTP from the SAS side.

Re: Transfer CSV from Windows to Linux/Unix Grid

andreas_lds — Mon, 01 Aug 2022 05:46:12 GMT

Contact those who set up the environment, they should have defined a way to get data into the system. But don't think that reading the data from you local drive will work.