topic Re: export outfile in ODS and Base Reporting

export outfile

nsr2013 — Mon, 09 Mar 2015 16:01:22 GMT

I want to use proc export to load the outputfile csv from unix server(SAS installed) into my local machine(windows).

if i am using unix server path, its loading into unix server path correctly.

/* Write to .CSV */

proc export data=test_dates_gmt

outfile="/root/home/sas"

dbms=csv replace;

run;

How to download unix server processing file into local machine path by using proc export?

Re: export outfile

Reeza — Mon, 09 Mar 2015 16:48:59 GMT

It's not clear what you're looking to do.

nsr2013 wrote:

How to download unix server processing file into local machine path by using proc export?

Proc Export exports a SAS data set to a different format. Proc Upload/Download move files from the server to local but it can be done in other ways as well, depending on your system set up.

You need to clarify your question.

Re: export outfile

Ksharp — Tue, 10 Mar 2015 09:08:00 GMT

You can't do that by proc export. But if you are using EG , that would be easy ,

Post it at

SAS Enterprise Guide

someone will give you answer .

Re: export outfile

nsr2013 — Tue, 10 Mar 2015 14:46:42 GMT

Hi,

To be more specific, i am using below code in stp to download the final output in csv. SAS is running in Unix server, Client is in Windows. I want to download the final CSV file into local machine where SAS client is located.

I am getting below error. Any idea?

83 + PROC EXPORT DATA=TEST_REPORT LABEL

84 + OUTFILE= "c:/user"

85 + DBMS=csv REPLACE;

85 !+ DELIMITER=',';

86 + RUN;

NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to WORK.PARMS.PARMS.SLIST.

ERROR: Physical file does not exist, /opt/app/sas/config/Lev1/SASApp/C:/user.

Re: export outfile

Reeza — Tue, 10 Mar 2015 17:11:17 GMT

If your data is on the server you need to either move the data to your local machine first and then export or create the file on the server and then download the file.

How exactly you do that is dependent on your setup.

Do you have both a local and server version of SAS?

Otherwise create it on the server and use an FTP program to download the file.

You can also look into PROC DOWNLOAD