topic PROC EXPORT DBMS = PCFS ERROR: Export unsuccessful. See SAS Log for details. in SAS Studio

PROC EXPORT DBMS = PCFS ERROR: Export unsuccessful. See SAS Log for details.

nammansachdeva — Thu, 02 May 2019 23:09:58 GMT

Im running into errors when trying to export my sas dataset to .dta format for Stata from SAS University Edition on a Virtual Machine.

I'm using the following code :

LIBNAME library "/folders/myfolders/";
PROC EXPORT DATA=opafy17nid
OUTFILE="/folders/myfolders/opafy17nid.dta"
DBMS=PCFS REPLACE;
SERVER="PCFilesServer" ;
RUN;

The log file shows:

Bridge server not answering

ERROR: Export unsuccessful. See SAS Log for details.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE EXPORT used (Total process time):

real time 0.11 seconds

cpu time 0.02 seconds

Could someone please help me out?

Re: PROC EXPORT DBMS = PCFS ERROR: Export unsuccessful. See SAS Log for details.

Reeza — Fri, 03 May 2019 01:36:13 GMT

Try DBMS=Stata

I think the PCFS is old.

Or right click file, select export and see what’s the generated code is doing.

Edit: Had a chance to test, here's an example that definitely works:

proc export data=sashelp.class 
            outfile='/folders/myfolders/demo.dta' 
            dbms=stata 
            replace;
run;

@nammansachdeva wrote:

Im running into errors when trying to export my sas dataset to .dta format for Stata from SAS University Edition on a Virtual Machine.

I'm using the following code :

LIBNAME library "/folders/myfolders/";
PROC EXPORT DATA=opafy17nid
OUTFILE="/folders/myfolders/opafy17nid.dta"
DBMS=PCFS REPLACE;
SERVER="PCFilesServer" ;
RUN;

The log file shows:

Bridge server not answering

ERROR: Export unsuccessful. See SAS Log for details.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE EXPORT used (Total process time):

real time 0.11 seconds

cpu time 0.02 seconds

Could someone please help me out?

Re: PROC EXPORT DBMS = PCFS ERROR: Export unsuccessful. See SAS Log for details.

Reeza — Fri, 03 May 2019 00:00:29 GMT

You also need to remove the server line.

Re: PROC EXPORT DBMS = PCFS ERROR: Export unsuccessful. See SAS Log for details.

nammansachdeva — Sat, 04 May 2019 13:36:49 GMT

Thanks a lot! I got the .dta file !!!