Export SAS data with user defined format and retain the format in Stata

[chouj]

Hi Everyone,

I need to export a SAS dataset to Stata. I also have a SAS catalog which I keep all the user defined formats. The codes below are what I have tried so far without success. If anyone know how to do this, please help!

Thank you- Joanne 

libname ftest "";

PROC EXPORT DATA=df_rec
OUTFILE="H:\late_recurrence.dta"
DBMS=dta REPLACE;
fmtlib=ftest;
RUN;

[Quentin]

When you say "without success", can you explain what that means?  Did you get errors in the log?  Did the data export successfully but you were unhappy with the results?  If so, what was wrong with the results?

When you say "retain the format" in STATA, what does that mean?  SAS formats can be used like SPSS "value labels".  Assuming STATA has the same construct, is the problem that the data is being exported to STATA successfully, but the value labels are missing?

[chouj]

Hi,
I apologized for not being clear. I was able to run the proc export procedure and create a stata dataset without any issues. But all the format labels got lost in the Stata data. This is what I meant by without success.
Thank you -Joanne

[Quentin]

Hi,

This related thread might help:

https://communities.sas.com/t5/SAS-Procedures/Export-SAS-dataset-to-STATA-keeping-the-formats/td-p/6...

Are they numeric variables, and is the length of your format names <= 8 ?