export outfile

[nsr2013]

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?

[Reeza]

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.

[Ksharp]

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 .

[nsr2013]

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.

[Reeza]

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