topic Re: Export SAS data with user defined format and retain the format in Stata in SAS Procedures

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

chouj — Thu, 04 May 2023 17:29:26 GMT

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;

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

Quentin — Thu, 04 May 2023 17:34:40 GMT

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?

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

chouj — Thu, 04 May 2023 17:49:52 GMT

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

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

Quentin — Thu, 04 May 2023 17:54:43 GMT

Hi,

This related thread might help:

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

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