Convert/Save labeled .dta file to .txt file

[Yingyi Lin]

Hi Statalist,

I am struggling with a seemly very simple question in Stata, but really cannot figure it out...

Basically, I have a dataset with labeled numeric variables (.dta), and after the data management and cleaning in Stata, I want to output and save it as .txt file (without label). Here is the code I used, the .txt file could be saved, but it contains a lot of weird strings, instead of the all the numeric values I wanted. I wonder what is going wrong with my codes.

Thanks in advance!
Yingyi

use old_data.dta, nolabel
save new_data.txt, replace

[Rich Goldstein]

see

help outfile

[Clyde Schechter]

Also see -help export delimited-.

[Yingyi Lin]

see

help outfile

Hi Rich, I tried the outfile commands as well, but still it did not work.

outfile old_data.dta, comma replace

when I was running this line of code (no matter with old_/new_data), error saying that "file XXX could not be opened"

[Yingyi Lin]

Also see -help export delimited-.

Hi Clyde, this helps! Thanks a lot!

I ended up using the code:

export delimited new_data.txt, delimiter(tab) replace

[Rich Goldstein]

re: #4, the command you used does NOT match what the help file says to do

[Yingyi Lin]

re: #4, the command you used does NOT match what the help file says to do

Thanks Rich, your notice made me re-read the document and now I got it. Here is the code I ending up using:

outfile using old_data.txt, wide replace

Works perfectly