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.

# st: AW: levelsof problem?

 From "Martin Weiss" To 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/
```