Stata Collapse By Multiple Variables

Collapsing multiple observations with different variable values Posted 01-17-2017 1231 PM 1269 views In reply to Haikuo Haikuo agree that contaminate is not needed in the flat data as it is coded into the the variable names already and the contaminate would probably be dropped. The reshape command can work on more than one variable at a time.

How To Collapse Data In Stata Youtube

How to collape across two variables.

Stata collapse by multiple variables. When I collapse a dataset by multiple variables by default Stata keeps only the combinations for which there are observations and so statistics can be calculated. If you have an internet connection you can get the data set by the following command. Collapse using same variables for two purposes.

Collapse understands varlists and varlists allow wildcards. Copy variable labels before collapse. The by option for collapse can take more than one variable so all you need to do is.

Clear input pop avgwage 10 20 20 10 40 30 end egen double. If lv. Collapse mean ItemNum first Date byID.

Collapse mean avgageage avgwtwt count numkidsbirth byfamid Counts the number of boys and girls in each family by using tabulate to create dummy variables based on sex and then summing the dummy variables within each family. Collapse with multiple sets of weights. While this isnt particularly useful on its own you can run the collapse command on multiple variables and save it as a new dataset which can then be appended to the original which can be useful for creating tables and graphs with the summary statistics of those variables.

Hi Caliph Try collapse sum duration cost by id gender age for a data that look like this one --------------------------------------- id duration cost gender age --------------------------------------- 1. 1 8 50 MALE ADULT 2. 4001 33 2 ----------------------.

4001 25 1 3. I want to do a collpase per year to get the mean the the total number of observations for all my numeric variables. Jbirth tells reshape that the suffix of age 1 2 3 should be taken from the variable birth.

A systematic way to do this is with a foreach loop. Tostring labno gen LABNO bysort individual_id. Reshaping data long to wide with more than one variable.

Heres how you could make it work. That is the number of unique groups. With every other command with which I have used an if qualifier the command applies only to the subset of the data that meets the if criteria and leaves the rest of the data alone.

4001 12 2 4. We are now ready to collapse the data to monthly level. Owner-statalisthsphsun2harvardedu mailtoowner-statalisthsphsun2harvardeduOn.

In the above table person 1 made two trips and three item purchases because two dates are shown person 2 made three trips. For example replace does not alter the data for which foreign 1. Foreach v of var.

L ---------------------- id amount type ---------------------- 1. Collapse mean age educ income median medincincome bystate This last dataset will contain three variables containing meansage educ and incomeand one variable containing the median of incomemedinc. If you collapsing by 3 categorical variables the number of responses you get will be the number of categories in var1 times the number of categories in var2 times the number of categories in var3.

Variable label v. Multiple observations - collapsing a string variable. Collapse sum amount by area candid to get what you are looking for.

Something like this might help. Im trying to collapse only a subset of my data using if but it seems to be dropping collapsing much more than I expect. Sysuse auto collapse t by foreign The only tricky thing is when you want two or more statistics from each variable.

Scott Thats very clever and easy. Because Ill have to re-run this multiple times in the future I dont want to have to manually edit the column headers in excel every time. Normalize the weights to sum to n and rescale population so the weighting cancels out.

Tabulate sex generatesexdum collapse sum girlssexdum1 boyssexdum2 byfamid. Variable date apparently is in a daily format. Suppose you want to get the sum of a variable x1 and the mean of a variable x2 for males and females separately.

For each of the unique groups you will get the statistical result that you specify after the collapse command. Can you collapse by two variables in Stata. 4001 10 1 2.

By default the mean of one or several variables is created. I am interested in the average number of trips across all people but first I need to collapse it down to unique dates. By default the collapse command collapses every variable to its mean.

Statas collapse command computes aggregate statistics such as mean sum and standard deviation and saves them into a data set. The problem is that I need to give names for these variables once they are used for mean and count and so stata cannot keep the same name for both. A few of the column headers need to include slashes or other characters I cant have as variable names in stata.

Here is how to generate a variable from it with only information on month and year. How to reshape or collapse multiple observation per id as one observation per id. 1 10 40.

You were on the right track w. Creating a Grouped Variable is part of the Methodology Institute Software tutorials sponsored by a grant from the LSE Annual FundFor more i. Replace LABNO LABNO _n-1 LABNO if _n 2 Nick njcoxdurhamacuk -----Original Message----- From.

This is much liking creating statistics for groups of cases but by collapsing your data a new data set is created that contains these statistics and can be put to further use. In the example above we just reshaped the age variable. Collapsing your data means to combine several cases into single lines.

You didnt say thats what you want so I will let you explain if your question is not what you asked. So I know I need to collapse on the date but when I do. What this does for each variable in the dataset is to copy its variable label to a local macro.

Because we typed median medincincome Stata knew to ﬁnd the median for income and to store those in a variable named medinc. Sort id type. 01 Jul 2015 1930.

Local lv v. When you execute the command an existing data set is replaced with the new one containing aggregate data. Id like to write a code that puts the required variable names as labels and write it.