Statalist


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

Re: st: Help with mathematical operation


From   Bryce Mason <bmason5@lmu.edu>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Help with mathematical operation
Date   Thu, 10 Sep 2009 10:56:37 -0700

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:	bmason5@lmu.edu




*
*   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   |   What's new   |   Site index