Date:         Wed, 7 Jul 2004 17:29:58 +0100
Reply-To:     ben.powell@cla.co.uk
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ben Powell <Ben.powell@CLA.CO.UK>
Organization: cla
Subject:      Re: Another array based data transposition question
Comments: To: Gina Nicolosi <ginanicolosi@HOTMAIL.COM>
Content-Type: text/plain; charset="us-ascii"

Dear Gina,

Your solution seems to be working and has shown up some duplication in the
data, as you were suggesting might be the case. It turns out that this is
because of title headers being repeated when a title's "other" values were
continued onto the next output page(!!). This has lead to the transposed
dataset being very wide, much wider than I would have expected anyway.

Otherwise, the isn header also caused an error in transposition owing to
duplication in the by variable, possibly for the above reason. So I just
renamed isn to other and can filter them out afterwards (bodge).

I'll have a look at this tomorrow, hopefully I can sort it out.

Thanks for the assistance and to others who posted,

Regards,

Ben.

-----Original Message-----
From: Gina Nicolosi [mailto:ginanicolosi@HOTMAIL.COM]
Sent: 07 July 2004 16:57
To: SAS-L@LISTSERV.UGA.EDU; Ben.powell@CLA.CO.UK
Subject: Re: Another array based data transposition question


Ben,
To order the variables exactly the way you listed in your most recent
example (with isn preceding the other variables), you'll need to add the
following data step after the PROC TRANSPOSE:

data five;
retain author title isn;
set four;
run;

Good luck - Gina Nicolosi