# Stata 16 export to excel

In this tutorial, we will learn how to export data from R environment to different formats. To export data to the hard drive, you need the file path and an extension. First of all, the path is the location where the data will be stored. In this tutorial, you will see how to store data on: The hard drive Google Drive Dropbox Secondly, R allows the users to export the data into different types of files.

For instance, you can change the path to the download folder. Create data frame First of all, let's import the mtcars dataset and get the mean of mpg and disp grouped by gear. You can create a CSV file with the function write.

Export CSV The basic syntax is: write. Need to be the same name of the data frame in the environment. Set the destination path. You just need to run the code below and see where the csv file is stored.

Both users will use the library xlsx to create an Excel file. The slight difference comes from the installation of the library. Indeed, the library xlsx uses Java to create the file. Java needs to be installed if not present in your machine. Windows users If you are a Windows user, you can install the library directly with conda: conda install -c r r-xlsx Once the library installed, you can use the function write.

A new Excel workbook is created in the working directory library xlsx write. You can go back to Rstudio and check which version of Can aventurine get wet is installed. Step 2 You need to install rjava in R. We recommended you to install R and Rstudio with Anaconda. Anaconda manages the dependencies between libraries. In this sense, Anaconda will handle the intricacies of rJava installation.

First of all, you need to update conda and then install the library. You can copy and paste the next two lines of code in the terminal.

Once again, you can use conda to do it: conda install -c r r-xlsx Just as the windows users, you can save data with the function write. The library "haven" provides a convenient way to export data to spss sas stata First of all, import the library. If you don't have "haven", you can go here to install it.

**Import ExcelÂ® data into StataÂ®**

RData' You can check the files created above in the present working directory Interact with the Cloud Services Last but not least, R is equipped with fantastic libraries to interact with the cloud computing services.

The library is not yet available at Anaconda. You can install it with the code below in the console. Don't forget the ' '. It is worth to see it in action. Each time you restart Rstudio, you will be prompted to allow access tidyverse to Google Drive. By default, it is the local name. Click Allow. Once the authentication is complete, you can quit your browser. In the Rstudio's console, you can see the summary of the step done.

Google successfully uploaded the file located locally on the Drive. Google assigned an ID to each file in the drive.

You can see this file in Google Spreadsheet.Making Regression Tables in Stata Overview Installation Examples esttab estout eststo estadd estpost Advanced SPost Documentation esttab estout eststo estadd estpost History Publications Author Also see Introductory examples for esttab Basic syntax and usage Standard errors, p-values, and summary statistics Beta coefficients Wide table: coefficients and t-statistics side-by-side Numerical formats Labels, titles, and notes Plain table Compressed table Significance stars: change symbols and thresholds Use with Excel Use with Word Use with LaTeX Non-standard table contents Viewing the internal estout call Basic syntax and usage esttab is a wrapper for estout.

Its syntax is much simpler than that of estout and, by default, it produces publication-style tables that display nicely in Stata's results window. The basic syntax of esttab is:. The procedure is to first store a number of models and then apply esttab to these stored estimation sets to compose a regression table.

The main difference between esttab and estout is that esttab produces a fully formatted right away. The default in esttab is to display raw point estimates along with t statistics and to print the number of observations in the table footer.

To replace the t-statistics by, e. Further summary statistics options are, for example, pr2 for the pseudo R-squared and bic for Schwarz's information criterion. Moreover, there is a generic scalars option to include any other scalar statistics contained in the stored estimates. For instance, to print p-values and add the overall F-statistic and information on the degrees of freedom, type:. For example, t-statistics are printed using two decimal places and R-squared measures are printed using three decimal places.

For point estimates and, for example, standard errors an adaptive display format is used where the number of displayed decimal places depends on the scale of the statistic to be printed the default format is a3 ; see below. The format applied to a certain statistic can be changed by adding the appropriate display format specification in parentheses. For example, to increase precision for the point estimates and display p-values and the R-squared using four decimal places, type:.

Alternatively, as is illustrated in the example above, a fixed format can be requested by specifying a single integer indicating the desired number of decimal places. To produce a table for use with Excel, specify an output filename and apply the csv format or the scsv format depending on the language version of Excel.

For example:. Depending on whether the plain option is specified or not, esttab uses two different variants of the CSV format. By default, that is, if plain is omitted, the contents of the table cells are enclosed in double quotes preceded by an equal sign i. This prevents Excel from trying to interpret the contents of the cells and, therefore, preserves formatting elements such as parentheses around t-statistics.To make this simpler, let's just keep the 25 observations with id less than or equal to Now let's say we want to export the variables id gender race read write and science.

You can see the data for those variables below. Let's write these variables out to a comma separated file using the outsheet command. After outsheet we specify the names of the variables we want to write if we omit this, it will write all of the variables. We use the comma option placed after ato indicate we want a comma separated file by default it will make a tab separated file.

The variables gender and race are really numeric variables that have value labels. For example, gender is really coded 1 and 2 with 1 representing male and 2 representing female. Perhaps we want the numbers, not the labels, for gender and race. If so, we can use the nolabel option and Stata will output the numeric values, not the labels, as shown below. We can use the type command below and see that now the numeric values of race and gender are output to the file.

You can read this kind of file into any program that knows how to read a comma separated file. In Excel, you would choose file then open and then for files of type select comma separated file Excel expects those files to have a.

## Announcement

You can then click the file and open it in Excel. You can learn more about this by seeing the Stata help file for outsheet.Why Stata? Supported platforms. Stata Press books Books on Stata Books on statistics.

Policy Contact. Bookstore Stata Journal Stata News. Contact us Hours of operation. Advanced search. A new feature in Stata 13, putexcelallows you to easily export matrices, expressions, and stored results to an Excel file. Let me show you. A stored result is simply a scalar, macro, or matrix stored in memory after you run a Stata command. The two main types of stored results are e-class for estimation commands and r-class for general commands.

Because correlate is not an estimation command, we use return list to see its stored results. Now we can use putexcel to export these results to Excel.

The basic syntax of putexcel is. It is easy to build the above syntax in the putexcel dialog. We have a helpful video on our YouTube channel about the dialog. Let's list the matrix r C to see what it contains. To re-create the table in Excel, we need to export the matrix r C with the matrix row and column names. In your Stata Command window, type. To export the matrix row and column names, we used the names option after we specifed the matrix r C.

## Announcement

When we open the file corr.By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service. The dark mode beta is finally here. Change your preferences any time. Stack Overflow for Teams is a private, secure spot for you and your coworkers to find and share information. Is there a simple way to export the "underlying" data of a Stata graph in order to reproduce that graph in MS Excel? Imagine you create a ROC curve using roctab y yhat, graph and you want to reproduce that graph in Excel.

I assume that you do not have access to the actual raw data that was used to compile the. If you do however have the access to the data originally used then with new command available in Stata 13, You can use the function putexcel command.

A more detailed description of the putexcel command can be found here stata press releasse on exporting tables to excel. The data in the. There's no utility I know of that will parse the serset information, but it is very similar to Stata's dta file v and below.

I wrote up the basic file format information here. Learn more. Export stata graph data to Excel? Ask Question. Asked 6 years, 4 months ago. Active 6 years, 1 month ago. Viewed 6k times. Nick Cox 27k 5 5 gold badges 24 24 silver badges 43 43 bronze badges.

SPi SPi 2 2 gold badges 10 10 silver badges 24 24 bronze badges. That's awful hard for me to imagine wanting to do that, but one way to try would be to learn about sersets. Alternatively, try editing the. My gut is that doing the calculations directly would usually be easier. Thanks Nick. I thought that Stata must store the data to build the graph somewhere x,y coordinatesso there might be a way to grab these datapoints.

You were right. A serset is another take. Active Oldest Votes. If you do however have the access to the data originally used then with new command available in Stata 13, You can use the function putexcel command A more detailed description of the putexcel command can be found here stata press releasse on exporting tables to excel.

D3L D3L 1 1 gold badge 3 3 silver badges 9 9 bronze badges. BeingQuisitive BeingQuisitive 1 1 silver badge 9 9 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog.Update 07 June See Export tabulation results to Excelâ€”Update for new features that have been added since this original blog.

There is a new command in Stata 13, putexcelthat allows you to easily export matrices, expressions, and stored results to an Excel file. A stored result is simply a scalar, macro, or matrix stored in memory after you run a Stata command. The two main types of stored results are e-class for estimation commands and r-class for general commands. Because correlate is not an estimation command, use the return list command to see its stored results.

Now we can use putexcel to export these results to Excel. The basic syntax of putexcel is. It is easy to build the above syntax in the putexcel dialog. There is a helpful video on Youtube about the dialog here. To re-create the table in Excel, we need to export the matrix r C with the matrix row and column names.

The command to type in your Stata Command window is. Note that to export the matrix row and column names, we used the names option after we specifed the matrix r C. When I open the file corr. Load the auto dataset, and run a tabulation on the variable foreign. Because tabulate is not an estimation command, use the return list command to see its stored results. We need to use the matcell and matrow options of tabulate to save the results produced by the command into two Stata matrices.

Again this is a basic tabulation table. You probably noticed that we did not have the Cum. Also our Car type column contains the numeric values 0,1not the value lables Domestic, Foreign of the variable foreignand our Percent column is not formatted correctly.

To get the exact table displayed in the Results window into an Excel file takes a little programming. With a few functions and a forvalues loop, we can easily export any table produced by running the tabulate command on a numeric variable.We use cookies to offer you a better experience, personalize content, tailor advertising, provide social media features, and better understand the use of our services. We use cookies to make interactions with our website easy and meaningful, to better understand the use of our services, and to tailor advertising.

For further information, including about cookie settings, please read our Cookie Policy. By continuing to use this site, you consent to the use of cookies. We value your privacy. Asked 8th Aug, Ieva Opmane. Stata results to Excel. Is there some easy way to get Stata tabulate results and also other results from Stata to Excel? Of course I can copy and paste, but it seems to me that there should be a more straightforward way.

Could anybody suggest something? Stata Software. Statistical Analysis. Microsoft Office Excel. Most recent answer. Jonatan Figueroa Gil. University of the Pacific Peru. Popular Answers 1.

Norbert Schanne. Institute for Employment Research. You could try the 'estout' save as.

### How do I export Stata .dta files to comma-separated files? | Stata FAQ

For r-class commands as summarize or output which is neither r nor e e. The frequencies displayed with tabulate, which can be stored as matrixyou first have to transform whatever you want to e by using 'estadd'. All Answers Ekonomski institut, Zagreb.

Look at help for this command, but it should be able to save all of your results to Excel, you just have to specify what you want to save and where. Bank of Latvia. Thanks, it seems that xmlsave is a good way how to get stata data to excel. If this is something that you want in Excel as well, than you just add it to your list in xmlsave command.

If there is something special that you want, than you can first save it to your dataset, than export it in Excel. Srinivasan Venugopal. Christian Medical College Vellore. You can use "stat transfer " for convert a file from stata to excel.