Not sure how many values -var2- has, but whether a list of
them will fit in the largest macro allowed by your flavor of
Stata you may be able to use -levelsof- to get a list of
-var2- values and loop over them. But this alternative will
surely work, if less efficiently:
bys var2 var1: gen n=_N
bys var2: gen N=_N
gen sqpct = (n*100/N)^2
bys var2: egen var3 = sum(sqpct)
Note that this assumes you want missing values tabulated
as well, if not then -drop- them first.
hth,
Jeph
T.J. Volant wrote:

Hello all,

I'm needing to TAB for every observation (of several

million) and pick out only certain results from the

TAB and assign it for the relevant observation. How

would I do that?

Example:

var1 var2

1 A

2 A

3 A

3 B

tab var1 if var2=A

results:

1 33%

2 33%

3 33%

For each of observation where var2=A, I would like to

assign sum of the squares of the percentages in the

tab results table in a new variable (say var3). So,

final result would look like:

var1 var2 var3

1 A 3267 (=33^2+33^2+33^2)

2 A 3267

3 A 3267

3 B -

How can I do this? Thank you very much in advance,

Tj

____________________________________________________________________________________

Never miss an email again!

Yahoo! Toolbar alerts you the instant new Mail arrives.

http://tools.search.yahoo.com/toolbar/features/mail/

*

* For searches and help try:

* http://www.stata.com/support/faqs/res/findit.html

* http://www.stata.com/support/statalist/faq

* http://www.ats.ucla.edu/stat/stata/

*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/