- #Putexcel stata 12 version how to#
- #Putexcel stata 12 version manual#
- #Putexcel stata 12 version series#
| High blood pressure High blood pressure Again, the order of the variables in the parentheses determines the nesting structure in the table. Or we can display frequencies for categories of highbp nested within categories of sex as in the example below. The example below displays frequencies for categories of sex nested within categories of highbp. We can specify similar nesting structures for multiple column variables. The order of the variables in the parentheses determines the nesting structure in the table. We can also specify multiple row or column variables, or both. We can remove the row and column totals by including the nototals option. The row and column totals are included by default. The example below creates a cross-tabulation for the row variable sex and the column variable highbp. The first set of empty parentheses is necessary in this example so that table knows that highbp is a column variable. The example below creates a table for the column variable highbp. The second set of empty parentheses in this example is not necessary because there is no column variable. table (highbp) ()īy default, the table displays the frequency for each category of highbp and the total frequency.
The example below creates a table for the row variable highbp.
The basic syntax of table is table ( RowVars ) ( ColVars ). We will ignore the survey weights for now so that we can focus on the syntax for creating tables. This dataset contains demographic, anthropometric, and biological measures for participants in the United States. Hdresult int %9.0g High density lipids (mg/dL) Tgresult int %9.0g Serum triglycerides (mg/dL) Tcresult int %9.0g Serum cholesterol (mg/dL) > bpsystol bpdiast tcresult tgresult hdresultīpsystol int %9.0g Systolic blood pressureīpdiast int %9.0g Diastolic blood pressure describe age sex race height weight bmi highbp (Second National Health and Nutrition Examination Survey) Let’s begin by typing webuse nhanes2l to open a dataset that contains data from the National Health and Nutrition Examination Survey (NHANES), and let’s describe some of the variables we’ll be using.
#Putexcel stata 12 version how to#
My goal is to show you how to create your own customized tables and import them into your documents.
#Putexcel stata 12 version series#
You may prefer a different layout for your tables, and that is the point of this series of blog posts. The table below displays the odds ratio, standard error, z score, p-value, and 95% confidence interval for each covariate in our final model. We may also wish to display the results of our final regression model. The table below displays the odds ratios and standard errors for the covariates of three logistic regression models along with the AIC and BIC for each model. We may also wish to create a table to compare the results of several regression models. The table below reports the means for a group of continuous variables for participants without hypertension, with hypertension, the difference between the means, and the p-value for a t test. Sometimes, we wish to report a formal hypothesis test for a group of variables. These statistics are displayed for each category of hypertension and the entire sample. The table below reports means and standard deviations for continuous variables and shows frequencies and percentages for categorical variables. Most reports and papers begin with a table of descriptive statistics for the sample that is often subdivided by a categorical variable. The first example is a classic “table 1”. I’ll show you how to re-create these examples in future posts. I want to show you a few examples before I show you how to create your own customizable tables.
#Putexcel stata 12 version manual#
We even added a new manual to show you how to use this powerful and flexible system. We also developed an entirely new system that allows you to collect results from any Stata command, create custom table layouts and styles, save and use those layouts and styles, and export your tables to most popular document formats. We expanded the functionality of the table command. Today, I’m going to begin a series of blog posts about customizable tables in Stata 17.