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:
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 answeringERROR: 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 secondscpu time 0.02 secondsCould someone please help me out?
Thanks a lot! I got the .dta file !!!
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.