I am trying to identify trends that last at least for 10 observations. However, the output I get repeats itself if the trend lasts for more than 10 observations. For example if the trend continues for 12 observations I have observations 0-10, 1-11 and 2-12 back to back. Below is the output file. How can I eliminate the repetition in the output? I need only 0-12. Of course the max observations in the trend can be more than 12. In the output I have the Symbol, Price and the Counter. Thank you. How can I accomplish this? Thank you! Data want; set test; lagPrice=lag(Price); lag10Price=lag10(Price); if Price>lagPrice and not missing(lagPrice) then Increasing ++ 1 ; else Increasing=0 ; if Increasing > 9 then TrendUp=1 ; ISIL 18.7800 0 ISIL 18.7900 1 ISIL 18.8000 2 ISIL 18.8100 3 ISIL 18.8200 4 ISIL 18.8700 5 ISIL 18.8900 6 ISIL 18.9100 7 ISIL 18.9200 8 ISIL 18.9300 9 ISIL 18.9400 10 ISIL 18.7900 1 ISIL 18.8000 2 ISIL 18.8100 3 ISIL 18.8200 4 ISIL 18.8700 5 ISIL 18.8900 6 ISIL 18.9100 7 ISIL 18.9200 8 ISIL 18.9300 9 ISIL 18.9400 10 ISIL 18.9600 11 ISIL 18.8000 2 ISIL 18.8100 3 ISIL 18.8200 4 ISIL 18.8700 5 ISIL 18.8900 6 ISIL 18.9100 7 ISIL 18.9200 8 ISIL 18.9300 9 ISIL 18.9400 10 ISIL 18.9600 11 ISIL 18.9800 12 Message was edited by: Betsy Abbe
... View more