Just insert the crosstab into a temporary table and export as csv from
there.
Albert
Bill Niehaus wrote:
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.
================================================
