Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | Michael Bondegård <michael@apub.se> |
To | statalist@hsphsun2.harvard.edu |
Subject | Re: st: RE: forval predict values into same column |
Date | Mon, 24 Jan 2011 21:37:27 +0100 |
Thanks to you both, it works :) On Mon, Jan 24, 2011 at 21:31, Jesper Lindhardsen <JESLIN01@geh.regionh.dk> wrote: > Hej Mike, > > Regarding Q1 I would use -egen rowmax- or -egen rownonmiss- to gather the data in one column after the loop, e.g., > > ..loop.. > > Egen jointpredictvar=rowmax(y1hat*) > > > As for Q2 you can do it several ways. One approach could be > > egen maxgroup=max(groupid) > Local n = maxgroup[1] > > Forval i=1/`n' { > > Regards, > > Jesper > > > > Jesper Lindhardsen > MD, Ph.d. student > Department of Cardiovascular Research > Copenhagen University Hospital, Gentofte > Denmark > > > > > > > -----Original Message----- > From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Michael Bondegård > Sent: 24 January 2011 21:15 > To: statalist@hsphsun2.harvard.edu > Subject: st: forval predict values into same column > > Hello, > 1. question 1 > > I wonder how to make this > forval i=1/6 { > regress Y1 X1 X2 if GROUPID ==`i' > predict Y1HAT if e(sample) > } > > When i do this it tells me Y1HAT already defined (so it stops after > second run, return just values first time) > > I know that i can do this: > forval i=1/6 { > regress Y1 X1 X2 if GROUPID ==`i' > predict Y1HAT_`i' if e(sample) > } > > As you see i add same number to the predictor that way i can go trough > this problem but what i want is to put the prediction in same column > from the start. > > This is because the GROUPID is diffrent for each prediction so it wont > overwrite anything once it input the prediction values into it. > > 2, question 2 > How to make return a maximum value for the GROUPID, as you see in the > example above the forval runs 6 timas (6 is the max in GROUPID) > > My question is, is there any way to make the similar to this wish: > forval i=1/MAX(GROUPID) > > I been looking for the right answer but no luck:( > > Thanks for help > best regards Mike > * > * 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/