If I understand correctly (and x is your variable):
expand _N
bysort x : gen id=_n
bysort id (x) : gen y=x[id]
gen xy = x*y
will do it.
hth,
Jeph
Burnett, Tim wrote:
Hello,
I am at the end of my tether with Stata 10 and was hoping someone
could help me:
I have a dataset which I am trying to manipulate:
Assuming the following variable:
1
2
3
4
5
6
7
8
I am trying to create a variable which will show:
1*1
1*2
1*3
1*4
.
.
.
2*1
2*2
2*3
2*4
.
.
.
...and so on.
I really don't know where to look as I can't think what this
mathematical operation would be called. Maybe I'm just dim.
Many thanks,
Tim Burnett
**********************************************************************
If you have received this email and it was not intended for you,
please let us know, and then delete it. Please treat our
information in confidence, as you would expect us to treat yours.
All our information systems may be monitored to ensure that they are
operating correctly. Furthermore, the content of emails and other
data on these systems may be examined, in exceptional circumstances,
for the purpose of investigating or detecting any unauthorised use.
The original of this email was scanned for viruses by the Government
Secure Intranet virus scanning service supplied by Cable&Wireless in
partnership with MessageLabs. (CCTM Certificate Number 2009/09/0052.)
On leaving the GSi this email was certified virus free.
Communications via the GSi may be automatically logged, monitored
and/or recorded for legal purposes.
*
* 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/
