I want to sum the column 'stat1' by the column 'Group' if it has a certain value, such as Group == 'AAA'
...
Announcement
Collapse
No announcement yet.
323 results in 0.0126 seconds.
syntax
x
You can also choose from the popular tags.

Moaiz Siddiqui started a topic Do sum of all corresponding values in one column when other column has a certain valuein GeneralDo sum of all corresponding values in one column when other column has a certain value
Last edited by Moaiz Siddiqui; Yesterday, 04:23.
 4 posts

John Adler started a topic Convergence not achieved  I've identified the culprit, now what do I do?in GeneralConvergence not achieved  I've identified the culprit, now what do I do?
Hello all,
I run a fixed effects logistic regression of self rated health and local employment change over three waves, as follows (clustering...
 8 posts

Unobserved Componenet Model and State Space Model
Dear All
I am try trying to construct an index, using Unobserved Component Model (UCM) and State Space Model (SSM) in Stata, but I am really...Last edited by Abiola Olatunji; 30 Oct 2019, 05:06.
 1 post

Meta Command for prevalences
I'm trying to run a metaanalysis using the metan command for a rate of the progression outcome variable (events/100,000 people/year). I'd need help with...
 1 post

dropping a variable base of the condition of another variable
Hi ,
I want to drop the variable if the variable there is no value in the column variable or the result is 0 when sum of all values of the variable....
 2 posts

Help with Looping
Good day, Statalist,
Please, I am carrying out an analysis for 5 waves of a survey data. Hence I would want to replicate the commands for...
 3 posts

Ale Asad started a topic Finding common values from a variable corresponding to two different values in another variablein GeneralFinding common values from a variable corresponding to two different values in another variable
Hello,
I'm interested in finding common values from a variable corresponding to two different values in another variable. For example, given...Last edited by Ale Asad; 11 Oct 2019, 09:44.
 5 posts

Coefplot: keep / drop coefficients from one model, not the whole plot
Dear Statalist,
I've recently started using coefplot command and like it's versatility, but I cannot work out how to use the keep command...
 3 posts

Levi Crews started a topic Storing and accessing output of multiple estimation commands within programin GeneralStoring and accessing output of multiple estimation commands within program
I've defined a program that generates random data and calls two estimation commands: reg and ppml. I want to store the regression coefficients from each...
 4 posts

John Adler started a topic In a fixed effects logit regression does Stata only drop observations that have no variation in the outcome variable? Or also the controls?in GeneralIn a fixed effects logit regression does Stata only drop observations that have no variation in the outcome variable? Or also the controls?
I have a 3 wave panel of children's height and weight and parents employment or unemployment (binary) during a recession.
As you will see...
 7 posts

Samir SweidaMetwally started a topic How to set svyset when multilevel modeling a binary outcome to take account of complex survey design?in GeneralHow to set svyset when multilevel modeling a binary outcome to take account of complex survey design?
Dear all,
I am reposting my previous unanswered query with more information in the hope I might get a response this time.
My...Last edited by Samir SweidaMetwally; 27 Sep 2019, 12:08. Reason: Multilevel Modelling; complex survey design; svyset
 1 post

Generate a new variable based on conditions and if statements
Hi All,
Hopefully someone could kindly help me with this problem.
I want to create a new variable called "VALID" and...
 8 posts

John Adler started a topic Using a cross sectional analysis to support the results of a panel analysisin GeneralUsing a cross sectional analysis to support the results of a panel analysis
Hi all,
I have a 3 wave panel of children's height and weight and whether either of their parents experienced a change from employment to...
 8 posts

Creating local macro names using a loop
Hi, this is my first post in the forum, I hope I will do this correctly. I am using Stata 15.1
I have som regression results and graphs that...
 3 posts

Interactive do File à la C++/Python
I have 2 datasets: A.dta, and B.dta. I want the same set of codes to run on A & B depending on the dataset that I choose.
In C++, for...
 7 posts