The SAS Output Delivery System and reporting techniques

export outfile

Reply
New Contributor
Posts: 2

export outfile

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?

Super User
Posts: 19,105

Re: export outfile

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.

Super User
Posts: 9,867

Re: export outfile

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 .

New Contributor
Posts: 2

Re: export outfile

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.

Super User
Posts: 19,105

Re: export outfile

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

Ask a Question
Discussion stats
  • 4 replies
  • 981 views
  • 0 likes
  • 3 in conversation