Below is a comparison of the commands used to write data into various file formats using R, SAS, SPSS and Stata. The variables gender and workshop are categorical factors and q1 to q4, pretest and posttest are considered continuous and normally distributed.<\/p>\n\n\n\n
The practice data set is shown here<\/a>. The programs and the data they use are also available for download here<\/a>. Examples that are missing for Stata reflect the differences between the two books. We will get around to those when we write the second edition of R for Stata Users<\/em><\/a>.<\/p>\n\n\n\n Writing Comma-Delimited Text Files<\/strong><\/p>\n\n\n\n R<\/strong><\/p>\n\n\n\n SAS<\/strong><\/p>\n\n\n\n SPSS<\/strong><\/p>\n\n\n\n Stata<\/strong><\/p>\n\n\n\n Writing Tab Delimited Files<\/strong><\/p>\n\n\n\n R<\/strong><\/p>\n\n\n\n SAS<\/strong><\/p>\n\n\n\n SPSS<\/strong><\/p>\n\n\n\n Stata<\/strong><\/p>\n\n\n\n Writing Excel Files<\/strong><\/p>\n\n\n\n R<\/strong><\/p>\n\n\n\n SAS<\/strong><\/p>\n\n\n\n SPSS<\/strong><\/p>\n\n\n\n Writing SAS Files<\/strong><\/p>\n\n\n\n R<\/strong><\/p>\n\n\n\n Writing SPSS Files<\/strong><\/p>\n\n\n\n R<\/strong><\/p>\n\n\n\n Writing Stata Files<\/strong><\/p>\n\n\n\n R<\/strong><\/p>\n\n\n\n Below is a comparison of the commands used to write data into various file formats using R, SAS, SPSS and Stata. The variables gender and workshop are categorical factors and q1 to q4, pretest and posttest are considered continuous and normally distributed. The practice data set is shown here. The programs and the data they … Continue reading Data Export<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":58,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"class_list":["post-363","page","type-page","status-publish","hentry"],"aioseo_notices":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P6TIhK-5R","jetpack-related-posts":[],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/r4stats.com\/wp-json\/wp\/v2\/pages\/363","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/r4stats.com\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/r4stats.com\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/r4stats.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/r4stats.com\/wp-json\/wp\/v2\/comments?post=363"}],"version-history":[{"count":9,"href":"https:\/\/r4stats.com\/wp-json\/wp\/v2\/pages\/363\/revisions"}],"predecessor-version":[{"id":4195,"href":"https:\/\/r4stats.com\/wp-json\/wp\/v2\/pages\/363\/revisions\/4195"}],"up":[{"embeddable":true,"href":"https:\/\/r4stats.com\/wp-json\/wp\/v2\/pages\/58"}],"wp:attachment":[{"href":"https:\/\/r4stats.com\/wp-json\/wp\/v2\/media?parent=363"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}\nwrite.csv(mydata, file="mydataFromR.csv";)\n<\/pre><\/pre>\n\n\n\n
\nPROC EXPORT DATA=MYLIB.MYDATA\n OUTFILE="mydataFromSAS.csv"\n DBMS=CSV REPLACE\n PUTNAMES=YES;\n<\/pre><\/pre>\n\n\n\n
\nSAVE TRANSLATE\nOUTFILE='mydataFromSPSS.csv'\n\/TYPE=CSV\n\/MAP\n\/REPLACE\n\/FIELDNAMES\n\/CELLS=VALUES.\n<\/pre><\/pre>\n\n\n\n
\nuse mydata,clear\noutfile using mydata.csv, comma\ntype mydata.csv\n<\/pre><\/pre>\n\n\n\n
\nwrite.table(mydata,\n file = "mydataFromR.tab",\n quote = FALSE,\n sep = "t",\n na = "",\n row.names = TRUE,\n col.names = TRUE)\n\n# Space delimited:\nwrite.table(mydata, file = "mydataFromR.txt")\n\n<\/pre><\/pre>\n\n\n\n
\nPROC EXPORT DATA=MYLIB.MYDATA\n OUTFILE="mydataFromSAS.txt"\n DBMS=TAB REPLACE;\n PUTNAMES=YES;\n<\/pre><\/pre>\n\n\n\n
\nSAVE TRANSLATE\nOUTFILE='mydataFromSPSS.dat'\n\/TYPE=TAB\n\/MAP\n\/REPLACE\n\/FIELDNAMES\n\/CELLS=VALUES.\n\n<\/pre><\/pre>\n\n\n\n
\nuse mydata,clear\noutfile using mydata.tab, tab\ntype mydata.tab\n<\/pre><\/pre>\n\n\n\n
\n# Do this once:\ninstall.packages("xlsReadWrite")\nlibrary("xlsReadWrite")\nxls.getshlib()\n\n# Write the file:\nlibrary("xlsReadWrite")\nwrite.xls(mydata, file = "mydataFromR.xls")\n<\/pre><\/pre>\n\n\n\n\nPROC EXPORT\nDATA=MYDATA\nOUTFILE="mydata.xls";\nDBMS=EXCELCS LABEL\nREPLACE;\nSHEET="mydata"\n<\/pre><\/pre>\n\n\n\n
\nSAVE TRANSLATE\nOUTFILE='mydataFromSPSS.xls'\n\/TYPE=XLS\n\/VERSION=2\n\/MAP\n\/REPLACE\n\/FIELDNAMES.\n<\/pre><\/pre>\n\n\n\n
\nlibrary("foreign")\n\nwrite.foreign(mydata,\n datafile = "mydataFromR.txt",\n codefile = "mydataFromR.sas",\n package&amp;amp;nbsp; = "SAS")\n<\/pre><\/pre>\n\n\n\n\nlibrary("foreign")\n\nwrite.foreign(mydata,\n datafile = "mydataFromR.txt",\n codefile = "mydataFromR.sps",\n package&amp;amp;nbsp; = "SPSS")\n<\/pre><\/pre>\n\n\n\n\nlibrary("foreign")\n\nwrite.foreign(mydata,\n datafile="mydata2.csv",\n codefile="mydata2.do",\n package="Stata")\n<\/pre><\/pre>\n","protected":false},"excerpt":{"rendered":"