Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: Observation variable transformation


From   Philip Ryan <[email protected]>
To   [email protected]
Subject   Re: st: Observation variable transformation
Date   Sun, 11 Sep 2005 09:23:54 +0930

Given X has contiguous increasing integer values from 1 to _N, the -egen-
function -seq()- will also accomplish this.

egen X1 = seq(), block(10)

see -help egen-

[I do not think you mean "successive observations of 10 *variables*. I think
you mean "successive observations (on a single variable) in blocks in 10".
Correct me if I'm wrong, but confusion over variable/observation terminology
can ambush both the poser of and the responder to a question.]

Phil



Quoting Svend Juul <[email protected]>:

> Kelly wrote:
>
> I have created an observation variable X (e.g. gen X=_n) for a large data
> set. How can I create a new variable that is unique for successive
> observations of 10 variables (i.e. i want this variable to be equal to 1 in
> obs 1-10, 2 in 11-20, and so forth)?
> ----
>
> Try this:
>     clear
>     set obs 50
>     gen X=_n
>     gen X1 = int((X+9.5)/10)
>     list
>
> I added 9.5, not 9, to prevent rounding errors.
>
> Hope this helps.
>
> Svend
>
>
>
> ________________________________________________________
>
> Svend Juul
> Institut for Folkesundhed, Afdeling for Epidemiologi
> (Institute of Public Health, Department of Epidemiology)
> Vennelyst Boulevard 6
> DK-8000 Aarhus C,  Denmark
> Phone, work:  +45 8942 6090
> Phone, home:  +45 8693 7796
> Fax:          +45 8613 1580
> E-mail:       [email protected]
> _________________________________________________________
>
> *
> *   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/
>


-- 
Philip Ryan
Associate Professor
Department of Public Health

Associate Dean (IT)
Faculty of Health Sciences

Head, Data Management and Analysis Centre
Department of Public Health and Department of General Practice

University of Adelaide
5005 South Australia
AUSTRALIA
CRICOS Provider Number 00123M
-----------------------------------------------------------
This email message is intended only for the addressee(s)
and contains information that may be confidential and/or
copyright.  If you are not the intended recipient please
notify the sender by reply email and immediately delete
this email. Use, disclosure or reproduction of this email
by anyone other than the intended recipient(s) is strictly
prohibited. No representation is made that this email or
any attachments are free of viruses. Virus scanning is
recommended and is the responsibility of the recipient.
*
*   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/



© Copyright 1996–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index