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.
================================================
