- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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?
Next up: SAS Trivia Quiz hosted by SAS on Wednesday May 21.
Register now at https://www.basug.org/events.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
This related thread might help:
Are they numeric variables, and is the length of your format names <= 8 ?
Next up: SAS Trivia Quiz hosted by SAS on Wednesday May 21.
Register now at https://www.basug.org/events.