Proc Export as .txt from SAS EG to Local Machine

[gflowers]

Hello,

I'm trying to export data as .txt (comma delimited) to a local machine using SAS EG.

A couple questions:

1) Is this even possible? While looking through the documentation, it seems that you can only specify the DBMS as Accesscs or Excelcs (link)  in order to export to a local machine. However, when I perform an export as .txt through the "Export file as step in project" it works fine.

2) Would you have to specify a Server_Name and Port_Number similar to an Excelcs export?

PROC EXPORT 
DATA=WORK.DISTRIBUTIONS
OUTFILE="<file path>"
DBMS=<?> REPLACE;
SERVER_NAME = "&serv_name";
PORT_NUMBER = 9621;
RUN;

Any help is appreciated. Thanks.

[andreas_lds]

Exporting to your local machine is hardly possible when working in a client-server-environment, because the server has no write-access to your local drives.

To create a csv-file use dbms=csv.

Also note, that csv-files should never be opened with excel, as that application tends to "optimize" what it reads.

[gflowers]

Exporting is possible using PC Files Server and I can export Access and Excel files. Was just wondering if you could do that with .txt (or .csv). If no, then I can mark your reply as the solution.

[andreas_lds]

---

@gflowers wrote:

Exporting is possible using PC Files Server and I can export Access and Excel files. Was just wondering if you could do that with .txt (or .csv). If no, then I can mark your reply as the solution.

---

Please share some information about the environment you are working in.

[gflowers]

SAS 9.4 for Windows 32-bit (build 9404.0.22712.15245)

[Tom]

---

@gflowers wrote:

Exporting is possible using PC Files Server and I can export Access and Excel files. Was just wondering if you could do that with .txt (or .csv). If no, then I can mark your reply as the solution.

---

So you don't want to write to your local machine but to the machine that is running the PC Files Server?  I don't know the answer to that.

If you want to look at moving a file to your PC using Enterprise Guide you can look into the COPY FILES task.  I know you can use it to upload files to the SAS server, not sure if you can use it move files in the other direction.

[gflowers]

My local machine that runs SAS EG also runs PC Files Server. It allows me to export files to the local machine, rather than restricting me to just the eDAP server. Based on the confusion it sounds like there is some solution outside of the typical SAS capabilities that my company's IT team has implemented...

[SASKiwi]

What OS does your SAS servers run on? If its Windows Server then setting up network folder shares  for this type of scenario is very easy. It is a bit harder for Unix but is something your IT support people should be able to implement. 

[Kurt_Bremser]

The PC Files Server should be named "MS File Server", as it is designed specifically for Excel and Access, not for anything else.

To automatically export to a local text file with EG, use PROC EXPORT (or a DATA step) and the Copy Files task in EG.