topic Error in PROC EXPORT CSV in New SAS User

Error in PROC EXPORT CSV

Paloma — Tue, 16 Apr 2019 15:21:37 GMT

Hello,

We are working in a remote desktop with SAS Enterprise Guide 7.1, and we are trying to export a file in csv using the following code:

PROC EXPORT DATA = WORK.TABLE

OUTFILE = "/L:/X9776/my_name/output.csv"

DBMS = CSV REPLACE;

RUN;

But we get this error :

Error: Physical file does not exist, L:/X9776/my_name/output.csv.

Can you help us please?

Thank you so much.

Re: Error in PROC EXPORT CSV

Reeza — Tue, 16 Apr 2019 15:24:24 GMT

The path looks wrong. Remember that you need to use a path on the server where EG is located, not your local machine. Once the file is created you can then download it to your machine or FTP it over.

Re: Error in PROC EXPORT CSV

Paloma — Tue, 16 Apr 2019 15:32:23 GMT

Hi Reeza! Thanks for answering so quickly.

The L: is a path on the server, not in my local machine, still we get this error.

Re: Error in PROC EXPORT CSV

Reeza — Tue, 16 Apr 2019 16:29:10 GMT

You don't usually need that first forward slash though, before the L?

Re: Error in PROC EXPORT CSV

ravig — Tue, 16 Apr 2019 17:22:48 GMT

/**Try this code , Copy the actual path from properties of the output folder*/
PROC EXPORT DATA = WORK.TABLE

OUTFILE = "L:/X9776/my_name/output.csv"

DBMS = CSV REPLACE;

RUN;

Re: Error in PROC EXPORT CSV

Paloma — Wed, 17 Apr 2019 07:27:12 GMT

We tried that before but if we do that we'll get the following error:

ERROR: Physical file does not exist, /sas/config94/sascompute/Lev1/SASApp/L:/X9776/my_name/output.csv.

We searched on the internet this error and we found a solution saying that 'L:/X9776/my_name/output.csv' is a UNIX path and that the problem is fixed with a slash before the L, but then we get the current error.

Thank you so much for helping us.

Re: Error in PROC EXPORT CSV

Paloma — Wed, 17 Apr 2019 07:27:57 GMT

We tried that before but if we do that we'll get the following error:

ERROR: Physical file does not exist, /sas/config94/sascompute/Lev1/SASApp/L:/X9776/my_name/output.csv.

We searched on the internet this error and we found a solution saying that 'L:/X9776/my_name/output.csv' is a UNIX path and that the problem is fixed with a slash before the L, but then we get the current error.

Thank you so much for helping us.

Re: Error in PROC EXPORT CSV

andreas_lds — Wed, 17 Apr 2019 10:00:03 GMT

The path you see in the error-message /sas/config94/sascompute/Lev1/SASApp/L:/X9776/my_name/output.csv indicates, that the sas-system you are working with is using Linux and not Windows, so there can't be an L-drive on the server. You need to talk to the it-staff, they can tell you which path you have to use.

Re: Error in PROC EXPORT CSV

Reeza — Wed, 17 Apr 2019 15:51:32 GMT

If you navigate to the path using the EG browser, select the folder you want to export to, right click, select properties. That will be the file path you need to use. You can navigate using the Servers/Files pane on the bottom left corner of the EG interface.

Re: Error in PROC EXPORT CSV

ravig — Thu, 18 Apr 2019 22:01:41 GMT

SERVER VS PC : May be your file is on the server and your SAS is on the PC ? or Viceversa . Please check

Re: Error in PROC EXPORT CSV

Paloma — Tue, 23 Apr 2019 10:05:15 GMT

Thanks, we will talk to the it-staff.

Re: Error in PROC EXPORT CSV

Paloma — Tue, 23 Apr 2019 10:06:38 GMT

SAS is installed on a server and I want to export the file on a virtual PC (remote desktop, not my local PC).

Re: Error in PROC EXPORT CSV

Paloma — Tue, 23 Apr 2019 10:08:24 GMT

Thank you Reeza, we looked there but there are a lot of folders, do you know which folder is linked to my virtual PC? Thanks.

Re: Error in PROC EXPORT CSV

Reeza — Tue, 23 Apr 2019 14:45:13 GMT

@Paloma, Unfortunately that's something IT or you should know.