Tim,
Have you considered appending the data set to itself 3 additional
times (to create 4 records for each row), sorting on the oldvar,
creating a multiplier based on _n, and then generating the newvar? I
hope I interpreted your question correctly.
use data;
append using data;
append using data;
append using data;
bysort oldvar: gen count=_n;
gen newvar=oldvar*count;
Best,
Bryce
On Sep 10, 2009, at 10:18 AM, 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/
Bryce Mason, Ph.D.
Director of Institutional Research
Loyola Marymount University
1 LMU Drive | Los Angeles, CA 90045
b: 4823 University Hall
w: (310) 258-8838
f: (310) 338-1841
e: [email protected]
*
* 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/