NOT A STATA VERSION 5 12 .DTA FILE CODE

(depending upon whether your'e using Windows or Unix or Linux, etc.):ĥ) Once the code I have posted completes (without issues - see SAS log), open your version of 'full-file-path.sas' in SAS and you should see all of the proc export statements - one per SAS data set.Ħ) If you are happy with what you see then you can submit the proc export code, perhaps try the first one initially to see if there are any issues, then, if OK, the rest can be submitted in one go. Whatever you decide upon should replace the 'full-file-path.sas', e.g. This file is referred to in my code with:Ĥ) The location and name of the file containing the proc export statements is up to you, as long as it ends in '.sas'. Report back if you have any issues with the log showing the code and any errors, warnings, etc.ġ) The SAS code I have presented looks for all the SAS data sets (tables) in the 'folder_sas_data' location that is in your code.Ģ) My code then creates a SAS program containing proc export statements for each and every SAS data set it found from step (1).ģ) This generated code from (2) is written to a file. If you are using the graphical version of Stata (recommended) viewing data is. Put 'proc export data=in.' memname 'outfile='folder_stata_data/' memname +(-1) '.dta ' Supposing that your stata data file mroz.dta was in the folder /some/place. * replace 'full-file-path.sas' with a path and name of a file that will have SAS code written to it */

Note the comment to 'replace 'full-file-path.sas'', the SAS code to run will be contained in there. The following untested code makes use of SAS system's dictionary tables to get the names of the SAS data sets in library 'in' then from that it constructs the proc export statements and writes them out to a file for you to examine and then submit in SAS if you are happy with what you see. The following details come from help dtaversion in Stata 15.1: Stata version. I'm not sure I see the need for data and the set statements, because you should be able to export all of the SAS data sets directly, without first having to copy them to a temp SAS data set. No need to apologise if you don't know at least you're trying.

Not a stata version 5-12 .dta file