Members,
I have a dataset with multiple columns (var1, var2, var3, etc.) with missing observations. Per row, I want to find the sum of the values for var1, var2, var3, etc. that come after a missing value. For instance, if var1 is missing, I would only take the sum of var2, var3, etc. If var2 is missing, I would only take the sum of var3, var4, etc.
I would appreciate any assistance with this!
Thanks,
A
Related Posts with Finding sum per row based on conditions
Can I control for covariates with a pca analysis?I am performing a principle component analysis with the between subject variable of fall status (non…
summarizing multiple variables for each observation -- ties broken randomlyI have 16 variables, each is continuous with values ranging from 0 to 10. I want to reduce it to a s…
Painel dataHi I'm with a doubt when I do a painel data. The estimations of my B's in re and fe aren't differen…
ologit or melogit or just regress?I have a continuous variable 90-day death rate at the hospital level. In the database, there are 100…
Using estpost and esttab for mutli-level data summary statisticsHello, I want to complete summary statistics for my multilevel data - countries (level 2) households…
Subscribe to:
Post Comments (Atom)
0 Response to Finding sum per row based on conditions
Post a Comment