Date:         Wed, 14 Apr 2004 15:13:31 +0100
Reply-To:     Ari Toikka <toikkari@YAHOO.CO.UK>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ari Toikka <toikkari@YAHOO.CO.UK>
Subject:      Re: Another rearrangement problem
In-Reply-To:  <200404132202.i3DM2pi10329@listserv.cc.uga.edu>
Content-Type: text/plain; charset=iso-8859-1

Hi,

 we probably need some by-variable here to cope with
 the "etc"-part of the data, but using just the two lines of data:


proc transpose data = test out=test2;
   var prop1 prop2 prop3;
run;

proc transpose data = test out=test3 prefix =N;
   var n;
   id condition;
run;

Proc Sql ;
   Create table test4 As
   Select *
    From test2, test3
run;
quit;


Ari Toikka
Statistics Finland


Pat Moore <pat.moore@UAA.ALASKA.EDU> wrote:
I have output that looks like this:

Condition Prop1 Prop2 Prop3 N
A 27.2 42.1 55.3 3807
B 40.5 60.1 70.9 158
etc.

I need this:

Prop PropA PropB NA NB
1 27.2 40.5 3807 158
2 42.1 60.1 3807 158
etc.

In other words, I need to attach both N values to each transposed
propA/PropB line.

TIA,

Pat Moore

---------------------------------
  Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now