Thanks Albert. I've never used CROSS TAB before. It seems pretty efficient. Is there a way to get the output from CROSSTAB into something like a CSV file? Bill
>>> Albert Berry <[EMAIL PROTECTED]> 11/11/2008 12:50 AM >>> Bill, that looks like a crosstab to me. CROSSTAB AVG(Sugar) FOR Rep BY Trial Note that AVG or MAX or MIN will work just fine. Bill Niehaus wrote: > I am trying to generate a transposed view on rows in a table. > > The table contains data like: > > Trial Rep Sugar > 81 1 15 > 81 2 14 > 81 3 16 > 81 4 15 > 81 5 14 > 81 6 16 > 82 1 13 > 82 2 12 > 82 3 14 > 82 4 15 > 82 5 11 > 82 6 15 > > > I want to generate a view with rows with data arranged like: > > Trial SugarRep1 SugarRep2 SugarRep3 SugarRep4 SugarRep5 SugarRep6 > 81 15 14 16 15 14 16 > 82 13 12 14 15 11 15 > > > I am not trying to do any calculations in R:Base, but just want to > eventually > get the data into ASCII or Excel files for sending to a different > program. > > Thanks. > > Bill > > --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
