BookmarkSubscribeRSS Feed
nammansachdeva
Calcite | Level 5

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? 
3 REPLIES 3
Reeza
Super User

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? 

 

Reeza
Super User
You also need to remove the server line.
nammansachdeva
Calcite | Level 5

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

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 2261 views
  • 0 likes
  • 2 in conversation