Export DTA file to sas7bdat file?

[Frank Kjeldsen]

Hello Stata users

I'm trying to export a Stata DTA file to sas7bdat file?

I have tried the export sasxport8 filename, replace command from the help menu. It stores my data in SAS format but not in the intended format "sas7bdat".

Is there a way Stata can do this? I don't have access or a license to Stat/transfer on my pc. So that's not an opportunity.

Kind regards Frank

Stata code:

cd "C:\Users\Frank\excel"

import excel using myexcel, firstrow clear

export sasexport8 myssas, replace

[Leonardo Guizzetti]

Stata does not have a built in way to do what you want. -export sasexport- is to export your data in SAS's "open" standard, the XPORT format, which has the file extension .xpt (or .xpt8).

Does your export *need* to be a SAS data file? A different file type like CSV may suffice. If it does, then either you need a program like StatTransfer to do this automatically, or you need access to SAS to perform the import process yourself.