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 !!! 

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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