Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


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

st: How to Calculate A Variable of Maximum Values up to each of the 114 periods in my sample?


From   Yuval Arbel <yuval.arbel@gmail.com>
To   statalist <statalist@hsphsun2.harvard.edu>
Subject   st: How to Calculate A Variable of Maximum Values up to each of the 114 periods in my sample?
Date   Fri, 14 Dec 2012 18:53:50 +0200

Dear Statalisters,

I am trying to generate a variable, which will give me the maximum
value of another variable (reduct_per) up to each of the 114 periods
in my sample.

Note that the function -max- works only with -egen-, namely it creates
a constant maximum, and not a running maximum..

I therefore wrote the following set of commands:

by appt: egen y=max(reduct_per)
by appt: gen max=reduct_per if time_index==0
by appt: replace max=reduct_per if reduct_per==y
by appt: replace max=reduct_per[_n-1] if reduct_per<=reduct_per[_n-1]
& max==. & time_index==1
by appt: replace max=reduct_per if max==. & time_index==1

by appt: replace max=max[_n-1] if reduct_per<=max[_n-1] & max==. &
time_index==2
by appt: replace max=reduct_per if max==. & time_index==2

by appt: replace max=max[_n-1] if reduct_per<=max[_n-1] & max==. &
time_index==3
by appt: replace max=reduct_per if max==. & time_index==3

by appt: replace max=max[_n-1] if reduct_per<=max[_n-1] & max==. &
time_index==4
by appt: replace max=reduct_per if max==. & time_index==4

by appt: replace max=max[_n-1] if reduct_per<=max[_n-1] & max==. &
time_index==5
by appt: replace max=reduct_per if max==. & time_index==5

by appt: replace max=max[_n-1] if reduct_per<=max[_n-1] & max==. &
time_index==6
by appt: replace max=reduct_per if max==. & time_index==6

and so on. My question is whether there is a more elegant way to
generate this variable. More specifically I would like to know
whether I need to write a loop, and if so how would I write it so that
I don't have to repeat the last two commands for 114 periods

-- 
Dr. Yuval Arbel
School of Business
Carmel Academic Center
4 Shaar Palmer Street,
Haifa 33031, Israel
e-mail1: yuval.arbel@carmel.ac.il
e-mail2: yuval.arbel@gmail.com
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index