At 13:38 27/09/03 -0400, tin-shun-jimmy chan wrote:

>I want to delete redundant data in order to do the transpose procedure. >Could you tell me how to do it ? Thanks. For example: > >Stock year Parameter Estimates StandardError >AAA 1988 alpha1 0.06 0.03 >AAA 1988 alpha2 0.03 0.002 >AAA 1988 beta 0.5 0.21 >AAA 1988 sigma 0.9 0.62 >AAA 1988 alpha2 0.03 0.002 >... > >In this case, the alpha2 is redundant and i want to delete it. Because >there are too many such redundant data, so I am asking if there is any >method to do it at once.

Jim, you could very easily ccreate a new dataset (or view) with all observations deleted for which parameter=alpha2, and then use that for your PROC TRANSPOSE step - but, if I understand you correctly, your simplest solution would be to include a WHERE statement or dataset option in your PROC TRANSPOSE, like:

PROC TRANSPOSE (Where = (parameter ne "alpha2")) ; .... etc. or PROC TRANSPOSE ; WHERE parameter ne "alpha2" ; .... etc.

Does that help?

Kind Regards,

John

---------------------------------------------------------------- Dr John Whittington, Voice: +44 (0) 1296 730225 Mediscience Services Fax: +44 (0) 1296 738893 Twyford Manor, Twyford, E-mail: John.W@mediscience.co.uk Buckingham MK18 4EL, UK mediscience@compuserve.com ----------------------------------------------------------------