Martin Weiss <[email protected]> :
Well, it changes the output dataset, and the poster -sort-ed, so I did, too.
On Mon, Nov 9, 2009 at 5:04 PM, Martin Weiss <[email protected]> wrote:
>
> <>
>
> Why bother to -sort-? Does not change anything here, does it?
>
>
>
> HTH
> Martin
>
>
> -----Ursprüngliche Nachricht-----
> Von: [email protected]
> [mailto:[email protected]] Im Auftrag von Austin Nichols
> Gesendet: Montag, 9. November 2009 23:04
> An: [email protected]
> Betreff: Re: st: using postfile in a loop
>
> There is no loop there. Try:
>
> use masterfile
> sort date ticker prc
> tempname A
> tempfile signals
> preserve
> qui sum RminusI, d
> keep if RminusI < r(p10)
> save `A'
> restore
>
> On Mon, Nov 9, 2009 at 4:54 PM, Kushan Thakkar <[email protected]> wrote:
>> I have a dataset the contains the following data:
>>
>> cusip ticker date prc ....(few more variables).... RminusI
>>
>> I need to isolate data points for which RminusI is less than its first
>> decile and then post these data points in a different file. This is
>> the code I am using.
>>
>> =========================================
>>
>> use masterfile
>>
>> sort date ticker prc
>>
>> quitely sum RminusI
>>
>> tempname A
>> tempfile signals
>>
>> postfile 'A' ticker date prc using `signals', replace
>>
>> post `A' (if RminusI < r(p10) ) //post to a new file if RminusI is
>> less than first decile
>>
>> postclose `A'
>>
>> =========================================
>>
>> However, after the post command I get the following error:
>>
>> ifRminusI not found
>> post: above message corresponds to expression 1, variable cusip
>>
>>
>> What am I doing wrong? Is there a more efficient way to do this ?
>>
>> Thanks,
>> Kush
>
> *
> * 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/
