Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: AW: levelsof problem?


From   "Martin Weiss" <martin.weiss1@gmx.de>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: AW: levelsof problem?
Date   Tue, 27 Jul 2010 11:39:06 +0200

<> 

You could of course -replace- to the values you want based on the -if-
qualifier after the fact:


*************
egen eutotal=rowtotal(GE_F NL_F  UK_F)
replace eutotal=. if !eu
*************


The reason that your second approach does not work is that Stata expects a
-varlist- while you feed it 

`"GE"' `"NL"' `"PT"'_F

which it cannot process. Type -ma di- to see the contents of your -macro-s.



HTH
Martin

-----Ursprüngliche Nachricht-----
Von: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von joe j
Gesendet: Dienstag, 27. Juli 2010 10:36
An: statalist@hsphsun2.harvard.edu
Betreff: st: levelsof problem?

>From a data set roughly like the following
clear*
input str2 country	eu	GE_F NL_F  UK_F US_F
US	0	1	1	1	0
US	0	1	1	1	0
NL	1	1	0	1	1
IN	0	1	1	1	1
GE	1	0	1	1	1
GE	1	0	1	1	1
US	0	1	1	1	0
US	0	1	1	1	0
US	0	1	1	1	0
PT	1	1	1	1	1
end

I want to calculate the  row sum of all *_F variables pertaining to eu
countries (all excluding US_F):
egen eutotal=rowtotal(GE_F NL_F  UK_F)

However, I would prefer to follow some rules in selecting the variables,
like

levels country if eu==1, local(lev)
egen eutotal=rsum(`lev'_F)

This doesn't work, however. Any pointers would be appreciated.

Joe.
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/


*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index