Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: FORVAL loop incomplete
From
Nick Cox <[email protected]>
To
"[email protected]" <[email protected]>
Subject
Re: st: FORVAL loop incomplete
Date
Wed, 20 Nov 2013 00:14:40 +0000
In your case the variable is -id-, not -group-. Sorry not to look at
your names more closely. Note that the test case included code that
worked.
Nick
[email protected]
On 20 November 2013 00:11, Francis, Richard N <[email protected]> wrote:
> Nick,
>
> Thanks for your help!
>
> Adding your suggestion results in 'variable GROUP not found'
>
> Here's the code I used:
>
>
> destring gvkey, replace
>
> egen id = group(gvkey), label
>
> gen date1 = yq(year, fqtr)
>
> tsset id date1, quarterly
>
> su id, meanonly
>
> *create file to contain new appended variable
>
> *save new
>
> g Z14 = .
> g Z24 = .
> g Z34 = .
> g Z4t = .
> g Z3t = .
> g Z2t = .
> g Z1t = .
>
> local limit=r(max)
>
> forval i = 1/`limit' {
> *display "Iteration of `i' of `limit"
> di "`: label (group) `i''"
> srootfix fcf if id == `i'
> return list
> ereturn list
> local p=`i'
> replace Z14 = r(Z14) in `p'
> replace Z24 = r(Z24) in `p'
> replace Z34 = r(Z34) in `p'
> replace Z4t = r(Z4t) in `p'
> replace Z3t = r(Z3t) in `p'
> replace Z2t = r(Z2t) in `p'
> replace Z1t = r(Z1t) in `p'
> *append using new
>
>
> }
>
> Maybe I added the new piece incorrectly?
>
> Thank you!
>
> Rick Francis
>
> -----Original Message-----
> From: [email protected] [mailto:[email protected]] On Behalf Of Nick Cox
> Sent: Tuesday, November 19, 2013 4:17 PM
> To: [email protected]
> Subject: Re: st: FORVAL loop incomplete
>
> As I understand it you want to supplement or replace
>
> forval i = 1/`limit' {
> display "Iteration of `i' of `limit"
>
> The information of interest is in the value label, so this line can follow or replace the line just quoted above.
>
> di "`: label (group) `i''"
>
> The syntax from inside outwards is
>
> `i' group number
>
> `: label (group) `i'' its value label
>
> "`: label (group) `i''" string delimiters for tidiness, at least
>
> The syntax is explained at -help macro- and its link -help extended_fcn-.
>
> Here is an accessible test case:
>
> . sysuse auto, clear
> (1978 Automobile Data)
>
> . egen group = group(foreign rep78), label
> (5 missing values generated)
>
> . su group, meanonly
>
> . forval i = 1/`r(max)' {
> 2. di "`: label (group) `i''"
> 3. }
> Domestic 1
> Domestic 2
> Domestic 3
> Domestic 4
> Domestic 5
> Foreign 3
> Foreign 4
> Foreign 5
>
> Nick
> [email protected]
>
>
> On 19 November 2013 23:02, Francis, Richard N <[email protected]> wrote:
>> Both Nick and Sergiy have provided extremely useful ideas.
>>
>> Have one other neophyte question ...
>>
>> Say the data has 3 unique IDs, and each ID has 60 unique values.
>>
>> The code below (between the two horizontal lines) generates summary results for each of the IDs.
>>
>> How would I add the contents of the ID variable to the summary results?
>>
>> Thank you so much!
>>
>> Rick
>>
>> ________________________________________
>>
>> destring gvkey, replace
>>
>> egen id = group(gvkey), label
>>
>> gen date1 = yq(year, fqtr)
>>
>> tsset id date1, quarterly
>>
>> su id, meanonly
>>
>>
>> g Z14 = .
>> g Z24 = .
>> g Z34 = .
>> g Z4t = .
>> g Z3t = .
>> g Z2t = .
>> g Z1t = .
>>
>> local limit=r(max)
>>
>> forval i = 1/`limit' {
>> display "Iteration of `i' of `limit"
>>
>> srootfix fcf if id == `i'
>>
>> local p=`i'
>>
>> replace Z14 = r(Z14) in `p'
>> replace Z24 = r(Z24) in `p'
>> replace Z34 = r(Z34) in `p'
>> replace Z4t = r(Z4t) in `p'
>> replace Z3t = r(Z3t) in `p'
>> replace Z2t = r(Z2t) in `p'
>> replace Z1t = r(Z1t) in `p'
>>
>> }
>> _______________________________________
>>
>> -----Original Message-----
>> From: [email protected]
>> [mailto:[email protected]] On Behalf Of Sergiy
>> Radyakin
>> Sent: Saturday, November 09, 2013 11:40 AM
>> To: [email protected]
>> Subject: Re: st: FORVAL loop incomplete
>>
>> Nick, sorry I missed your message and I trusted sroot was cleared/tested. That explains a lot, but still I would isolate the problem within sroot, and keep my program clear from any crunches to handle sroot's problem. A quick fix could be something like this:
>>
>> http://radyakin.org/statalist/2013110901/srootfix.ado
>>
>> Now Rick can call srootfix instead of sroot in the loop I provided. If sroot ever gets fixed, Rick would replace that call from srootfix to sroot directly. If Rick routinely uses sroot, srootfix might become reusable in multiple projects.
>> It may take like 10 more minutes to produce an automatic srootfix that would detect the version of sroot and decide whether to call it directly or use preserve, but I doubt anyone needs this level of automation.
>>
>> Best, Sergiy Radyakin
>>
>>
>>
>> On Sat, Nov 9, 2013 at 9:57 AM, Nick Cox <[email protected]> wrote:
>>> An earlier thread established that -sroot- (SJ) does not support -if-
>>> correctly. That's the entire point of the work-around being used here.
>>> Nick
>>> [email protected]
>>>
>>>
>>> On 9 November 2013 17:52, William Buchanan <[email protected]> wrote:
>>>> Hi Rick,
>>>>
>>>> I've adjusted some of your code below based on the information that you've provided to the listserv:
>>>>
>>>> destring gvkey, replace
>>>>
>>>> encode gvkey, gen(id)
>>>>
>>>> gen date = yq(year, fqtr)
>>>>
>>>> tsset id date, quarterly
>>>>
>>>> g Z14 = .
>>>> g Z24 = .
>>>> g Z34 = .
>>>> g Z4t = .
>>>> g Z3t = .
>>>> g Z2t = .
>>>> g Z1t = .
>>>>
>>>> su id, meanonly
>>>>
>>>> forval i = 1/3 {
>>>> sroot fcf if id==`i'
>>>> replace Z14 = r(Z14) if id== `i'
>>>> replace Z24 = r(Z24) if id== `i'
>>>> replace Z34 = r(Z34) if id== `i'
>>>> replace Z4t = r(Z4t) if id==`i'
>>>> replace Z3t = r(Z3t) if id==`i'
>>>> replace Z2t = r(Z2t) if id== `i'
>>>> replace Z1t = r(Z1t) if id== `i'
>>>> }
>>>>
>>>> You could also take Sergiy's suggestion and store everything in matrices, and if you wanted you could easily modify the user-written program around line 306 to store all of the values in a matrix that you could return in the same way as the scalars that you are referencing here. If you wanted to create a new dataset based on the results, you could possibly modify the program to make it byable and use -statsby-, or you could check out -post- and -postfile- commands to store the results to another file.
>>>>
>>>> HTH,
>>>> Billy
>>>> On Nov 9, 2013, at 10:41 AM, "Francis, Richard N" <[email protected]> wrote:
>>>>
>>>>> Hi Sergiy,
>>>>>
>>>>> Thank you for taking time out of your day for such a novice issue.
>>>>>
>>>>> The entire pgm looks like this:
>>>>>
>>>>>
>>>>> destring gvkey, replace
>>>>>
>>>>> egen id = group(gvkey), label
>>>>>
>>>>> gen date = yq(year, fqtr)
>>>>>
>>>>> tsset id date, quarterly
>>>>>
>>>>> su id, meanonly
>>>>>
>>>>> g Z14 = .
>>>>> g Z24 = .
>>>>> g Z34 = .
>>>>> g Z4t = .
>>>>> g Z3t = .
>>>>> g Z2t = .
>>>>> g Z1t = .
>>>>>
>>>>> forval i = 1/`r(max)' {
>>>>> preserve
>>>>> keep if id == `i'
>>>>> sroot fcf
>>>>> return list
>>>>> ereturn list
>>>>> replace Z14 = r(Z14) in `i'
>>>>> replace Z24 = r(Z24) in `i'
>>>>> replace Z34 = r(Z34) in `i'
>>>>> replace Z4t = r(Z4t) in `i'
>>>>> replace Z3t = r(Z3t) in `i'
>>>>> replace Z2t = r(Z2t) in `i'
>>>>> replace Z1t = r(Z1t) in `i'
>>>>> append using new
>>>>> restore
>>>>> }
>>>>>
>>>>> R(max) immediately prior to the FORVAL loop is three (3), but I'm not sure this is what you are looking for in your first comment.
>>>>>
>>>>> Does this help at all?
>>>>>
>>>>> Again, thank you!
>>>>>
>>>>> Rick Francis
>>>>>
>>>>> -----Original Message-----
>>>>> From: [email protected]
>>>>> [mailto:[email protected]] On Behalf Of Sergiy
>>>>> Radyakin
>>>>> Sent: Saturday, November 09, 2013 9:28 AM
>>>>> To: [email protected]
>>>>> Subject: Re: st: FORVAL loop incomplete
>>>>>
>>>>> Rick,
>>>>> 1) N may be 180, but what is r(max)? In Stata r(max) is the result of the previous command [of r-class]. You don't show us this command.
>>>>> Please do.
>>>>> 2) The combination of "append using new" and "restore" does not make sense, Whatever you append you immediately lose.
>>>>> 3) If append is meant to add one observation where you are saving
>>>>> the results (dataset new is a blank one observation of the same
>>>>> layout as the current dataset), consider using: expand in _N
>>>>> 4) If you want to accumulate the results of your tests, consider using a matrix to hold the results, and avoid modifying the data.
>>>>> Best, Sergiy
>>>>>
>>>>> On Sat, Nov 9, 2013 at 8:14 AM, Francis, Richard N <[email protected]> wrote:
>>>>>> I'm sorry, N = 180 obs, currently cycles through the first 60 (3 groups of 60 =180 total obs).
>>>>>>
>>>>>> Thank you!!
>>>>>>
>>>>>> Rick Francis
>>>>>>
>>>>>> -----Original Message-----
>>>>>> From: [email protected]
>>>>>> [mailto:[email protected]] On Behalf Of Nick
>>>>>> Cox
>>>>>> Sent: Saturday, November 09, 2013 9:08 AM
>>>>>> To: [email protected]
>>>>>> Subject: Re: st: FORVAL loop incomplete
>>>>>>
>>>>>> Tell us what r(max) is.
>>>>>> Nick
>>>>>> [email protected]
>>>>>>
>>>>>>
>>>>>> On 9 November 2013 15:53, Francis, Richard N <[email protected]> wrote:
>>>>>>> Hello Statalist,
>>>>>>>
>>>>>>> Have a simple FORVAL loop which should result in multiple cycles.
>>>>>>>
>>>>>>> However, she only cycles once. I'm sure the answer is obvious to experienced Stata users (which I am not).
>>>>>>>
>>>>>>> The loop is as follows:
>>>>>>>
>>>>>>>
>>>>>>> forval i = 1/`r(max)' {
>>>>>>> preserve
>>>>>>> keep if id == `i'
>>>>>>> sroot fcf
>>>>>>> return list
>>>>>>> ereturn list
>>>>>>> replace Z14 = r(Z14) in `i'
>>>>>>> replace Z24 = r(Z24) in `i'
>>>>>>> replace Z34 = r(Z34) in `i'
>>>>>>> replace Z4t = r(Z4t) in `i'
>>>>>>> replace Z3t = r(Z3t) in `i'
>>>>>>> replace Z2t = r(Z2t) in `i'
>>>>>>> replace Z1t = r(Z1t) in `i'
>>>>>>> append using new
>>>>>>> restore
>>>>>>> }
>>>>>>>
>>>>>>> I am grateful for any thoughts anyone may have.
>
> *
> * 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/
>
> *
> * 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/
*
* 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/