I am still not sure I have completely understand what you want. I thought my solution could do what you just asked. if you could just post several line of data to show what your wanted table look like, that would definitely help. Regards, Haikuo ... View more

data temp; input a $ b ; cards; A 840 A 841 A 842 A 843 A 844 A 845 B 840 B 841 B 842 C 840 C 841 C 842 C 843 C 844 C 845 D 842 D 843 D 844 D 845 ;run; data temp2(keep=a); set temp; by a; if first.a then counter =1; else counter +1; if counter=6 then output; run; i am checking if a stock has 6 records if it is so then i am taking that stock to output.. not sure if this is what u wanted. ... View more

Thanks Cynthia and Ksharp. @ Ksharp: Yes the code works perfectly. I've learned to work with arrays now... but still need to practice:-) Stefaan ... View more

Hi You can find a lot of sampling samples on the SAS website. May be the following links are helpful: http://support.sas.com/rnd/app/da/new/dasurvey.html http://support.sas.com/kb/?st=11&la=en&qm=3&ct=54042 HTH Patrick ... View more

Sure.Of course. E-mail: xiakeshan@yahoo.com.cn But I am in china now. And maybe you need some more time to consider for your whole data. I can explain my code if you has some uncertainty. Try it at your best. So I think you can do it by yourself. Good Luck. [pre] 19/03/2004 100174701 BE0003565737 44,8 buy 2300 6/03/2007 100174701 BE0003565737 89,67 sell 2300 24/03/2004 100174701 BE0003565737 44,59 buy 12050 6/03/2007 100174701 BE0003565737 89,67 sell 37700 23/06/2005 100174701 BE0003565737 66,65 buy 3900 6/03/2007 100174701 BE0003565737 89,67 sell 33800 [/pre] 33800=37700-3900 not 37700-12050 Is it rigth? Message was edited by: Ksharp ... View more