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 !!!
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and save with the early bird rate—just $795!
Get started using SAS Studio to write, run and debug your SAS programs.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.