SAS Procedures

Help using Base SAS procedures
BookmarkSubscribeRSS Feed
chouj
Calcite | Level 5

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;

 

3 REPLIES 3
Quentin
Super User

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?

The Boston Area SAS Users Group is hosting free webinars!
Next up: SAS Trivia Quiz hosted by SAS on Wednesday May 21.
Register now at https://www.basug.org/events.
chouj
Calcite | Level 5
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
Super User

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 ?

The Boston Area SAS Users Group is hosting free webinars!
Next up: SAS Trivia Quiz hosted by SAS on Wednesday May 21.
Register now at https://www.basug.org/events.

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1039 views
  • 0 likes
  • 2 in conversation