topic Importing external data using "INFILE" and SAS uni edition / server? in SAS Programming

Importing external data using "INFILE" and SAS uni edition / server?

james_peacock — Sat, 03 Nov 2018 12:28:30 GMT

Hi,

I've tried using the following code to import my external data text file. But I keep getting the error below:

infile "C:\Users\james\Documents\SAS\data_and_results\DATA\JamesTestDATAFile001.txt"

ERROR: Physical file does not exist,

/opt/sasinside/SASConfig/Lev1/SASApp/C:\Users\james\Documents\SAS\data_and_results\DATA\JamesTestDATAFile001.txt.

Can anyone point me in the right direction please?

Re: Importing external data using "INFILE" and SAS uni edition / server?

VDD — Sat, 03 Nov 2018 12:38:28 GMT

Hello @james_peacock this link to a reply by @Tom may assist you with your request.

https://communities.sas.com/t5/General-SAS-Programming/ERROR-Physical-file-does-not-exist-opt-sasinside-SASConfig-Lev1/td-p/147659

Re: Importing external data using "INFILE" and SAS uni edition / server?

Kurt_Bremser — Sat, 03 Nov 2018 13:49:17 GMT

If you use the on- demand version, you have to copy the file to the server; if you use the UE VM, you have to put the file into the shared folder and use /folders/myfolders as the path. UE runs on UNIX, so it needs UNIX syntax.

Re: Importing external data using "INFILE" and SAS uni edition / server?

james_peacock — Sat, 03 Nov 2018 13:51:06 GMT

Thanks very much VDD

Re: Importing external data using "INFILE" and SAS uni edition / server?

james_peacock — Sat, 03 Nov 2018 13:51:31 GMT

Thanks very much Kurt