Statalist


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

RE: AW: st: AW: Flexible end of numlist


From   Michael Stuetzer <michael.stuetzer@qut.edu.au>
To   "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu>
Subject   RE: AW: st: AW: Flexible end of numlist
Date   Wed, 19 Aug 2009 18:17:31 +1000

That also works quite well. Nice and more elegant.

-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Martin Weiss
Sent: Friday, 14 August 2009 5:46 PM
To: statalist@hsphsun2.harvard.edu
Subject: AW: AW: st: AW: Flexible end of numlist


<> 


You declared yourself satisfied, and I am happy for you. Just to prevent
misunderstandings: I take it from your code that the first line create a var
" no_vars1", containing a count, and the second line puts into a new column
" no_vars2" the maximum of " no_vars1". There is no -by- option or anything
that would induce variability in the var " no_vars2". In the third line you
request a -levelsof-, which according to my understanding now contains the
unique value of " no_vars2", i.e. the maximum of " no_vars1". So the bottom
line for line 5, where you divide the -local- containing the max of "
no_vars1" by half, is probably 
that you do arrive where you wanted to go, but with more complications than
necessary. You could simply 

***
quietly: egen no_vars1=/* 
 */ anycount(pat_se*), /* 
 */  values(1/12 1980/2015)
su no_vars1, mean
drop no_vars*
forvalues i=1/`=r(max)/2'{

***

and be just as happy. The change would make your code more intelligble. You
should check carefully whether it gives you the same result as the earlier
one...

HTH
Martin

-----Ursprüngliche Nachricht-----
Von: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Michael
Stuetzer
Gesendet: Freitag, 14. August 2009 03:23
An: statalist@hsphsun2.harvard.edu
Betreff: RE: AW: st: AW: Flexible end of numlist

Dear Eric, dear Martin, dear all

Thanks for your comments and help. Now it is running perfectly. For
everybody having such a problem to create from a series of variables a date
variable using a flexible end of a forvalues list - please find below the
complete code.

Again the problem was that one haves a varlist pat_se1, patse_se2, ...,
where months are in the odd pat_se variables and years are in the even
pat_se variables. Now you need to program a loop and want to use the
forvalues i=1/... command. However you want to have the end of list not to
be fixed, but more flexible. To be more precise, the end of the list should
be half the number of the variables involved in that loop. 


quietly: egen no_vars1=anycount(pat_se*), values(1/12 1980/2015)
quietly: egen no_vars2=max(no_vars1)
levelsof no_vars2, local(r)
drop no_vars*
forvalues i=1/`=`r'/2'{
local j=`i'*2
local k=`j'-1
local t=round(`i'/2)
gen PATENTS_SH`i' = ym(pat_se`j', pat_se`k')
format PATENTS_SH`i' %tmn_CY
if mod(`i',2)==0 {
lab var PATENTS_SH`i' " Patenting, end `t'. spell, real time "
}
else lab var PATENTS_SH`i' " Patenting, start `t'. spell, real time "
}

In the end you receive a specific number of variables PATENTS_SH* which
contains the dates of the beginning and the end of the respective business
starting activity labelled "Patenting".

Michael

-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Eric A. Booth
Sent: Friday, 14 August 2009 1:08 AM
To: statalist@hsphsun2.harvard.edu
Subject: Re: AW: st: AW: Flexible end of numlist

Obviously it doesn't.  I didn't read that part of Michael's post  
carefully, and so my suggestion was simply aimed at making the end of  
his numlist flexible ... apologies to Michael for any confusion it  
might have caused.


Best,
Eric


__
Eric A. Booth
Public Policy Research Institute
Texas A&M University
ebooth@ppri.tamu.edu
Office: +979.845.6754
Fax: +979.845.0249


On Aug 13, 2009, at 9:47 AM, Martin Weiss wrote:

>
> <>
>
> Well, I wanted to leave open the possibility that he might tweak my  
> code to
> accomodate his stated wish that "the end of the numlist should be  
> half the
> number of the variables involved in that loop." How does your proposal
> address this issue?
>
>
>
>
> HTH
> Martin
>
>
> -----Ursprüngliche Nachricht-----
> Von: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Eric A.  
> Booth
> Gesendet: Donnerstag, 13. August 2009 16:45
> An: statalist@hsphsun2.harvard.edu
> Betreff: Re: st: AW: Flexible end of numlist
>
> MIchael may not want to pass the -forvalues- loop a value from another
> -local-, in which case using "  `=_N'  "  could do the trick:
>
> *****
>
> forvalues i=2/`=_N'  {
> 	di in red `i'
> }
> *****
>
>
> Best,
>
> Eric
>
> __
> Eric A. Booth
> Public Policy Research Institute
> Texas A&M University
> ebooth@ppri.tamu.edu
> Office: +979.845.6754
> Fax: +979.845.0249
>
>
> On Aug 13, 2009, at 2:31 AM, Martin Weiss wrote:
>
>>
>> <>
>>
>> The help advises against this use of the -foreach- loop structure.
>> See -h
>> foreach-:" If you wish to loop over many equally spaced values, do  
>> not
>> code...", instead use -forvalues-. Apart from that, you can have  
>> Stata
>> evaluate an -expression- as the endpoint of a -numlist-, in this
>> particular
>> case half the -local- "r":
>>
>>
>> *************
>> local r 10
>>
>> forv i=1/`=`r'/2'{
>> 	di in red `i'
>> }
>> *************
>>
>>
>>
>> HTH
>> Martin
>>
>> -----Ursprüngliche Nachricht-----
>> Von: owner-statalist@hsphsun2.harvard.edu
>> [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Michael
>> Stuetzer
>> Gesendet: Donnerstag, 13. August 2009 02:40
>> An: statalist@hsphsun2.harvard.edu
>> Betreff: st: Flexible end of numlist
>>
>> Dear stata listers,
>>
>> I need to program a loop and want to use the "foreach i of numlist
>> 1/10"
>> begin. However I want to have the end of numlist not to be fixed,
>> but more
>> flexible. To be more precise, the end of the numlist should be half
>> the
>> number of the variables involved in that loop. Does anyone have an
>> idea how
>> to do that?
>>
>> The variables which are involved in that loop  are for instance
>> pat_se1
>> pat_se2 pat_se3 pat_se4 and contain the month (pat_se[odd]) and the
>> years
>> (pat_se[even]) of a specific business starting activity.  I have
>> here a
>> first draft of that loop
>>
>>
>> foreach i of numlist 1/2 {
>> local j=`i'*2
>> local k=`j'-1
>> local t=round(`i'/2)
>> gen PATENTS_SH`i' = ym(pat_se`j', pat_se`k')
>> format PATENTS_SH`i' %tmn_CY
>> if mod(`i',2)==0 {
>> lab var PATENTS_SH`i' "Patenting, end `t'. spell, real time"
>> }
>> else lab var PATENTS_SH`i' "Patenting, start `t'. spell, real time"
>> }
>>
>> Thanks for your help
>> Michael
>>
>>
>> *
>> *   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/
>
>
> *
> *   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/


*
*   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/


*
*   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/



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