Date:         Fri, 30 Dec 2005 17:38:14 -0500
Reply-To:     "Gerstle, John" <yzg9@CDC.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Gerstle, John" <yzg9@CDC.GOV>
Subject:      Re: ods output development ?
Comments: To: T J Lawson <lawson@aesop.Rutgers.edu>
Content-Type: text/plain; charset="us-ascii"

TJ,
What I do is use the ODS TRACE ON / LISTING; statement to see what the
table names are.  Once you know the table name, then change the ODS
TRACE statement to a ODS OUTPUT tablename = yourtable ; (with following
ODS OUTPUT CLOSE, of course).  I usually play a bit printing the table
in the listing window to see what I've got and what I need to do to use
it.

It's hard to tell you more specifically what to do from your email -
it's not specific enough what you're trying to do here (or at least I'm
missing it) - what you're wanting to merge to what.

Post back to the list...

John Gerstle, MS
Biostatistician
CDC Information Technological Support Contract (CITS)
NCHSTP \DHAP \HICSB \Research, Analysis, and Evaluation Section

>> -----Original Message-----
>> From: owner-sas-l@listserv.uga.edu
[mailto:owner-sas-l@listserv.uga.edu]
>> On Behalf Of T J Lawson
>> Sent: Friday, December 30, 2005 4:21 PM
>> To: SAS-L@LISTSERV.UGA.EDU
>> Subject: ods output development ?
>>
>> Good evening SAS-L,
>> I have been in the shadows trying to understand as much as I can for
>> about a year now.
>> SAS-L is what the www was intended to be -- the sharing of
information
>> -- Thank You.
>> At the Bottom is the program for an analysis of a field study.
>> What I am trying to grasp is the next step in the development of a MS
>> Word table.
>> -------------------
>> N   +
>> N   -
>>   lsd
>> P   +
>> P   -
>>   lsd
>> G   +
>> G   -
>>   lsd
>> R   +
>> R   -
>>   lsd
>> -----------------
>> ODS outputs a nice table for the individual levels N P R G.  I
>> understand the ods trace on / listing. How do I merger this output?
>> What term am I not pick up on??
>> Should I follow 1-ods markup, 2-ods output, 3- proc report, 4-proc
>> tabulate or something else?
>>
>> THANK YOU - HAPPY NEW YEAR
>> T J Lawson
>> Research Technician
>> Rutgers University
>> lawson@cook.rutgers.edu
>>
>> ----------------------------------
>> ods rtf file='C0607.rtf';
>> ods rtf style=journal startpage=no keepn ;
>>
>> TITLE 'Color 06 07 2005';
>>
>> Proc print data=Vel_05.C0607;
>> run;
>>
>> PROC GLM data=Vel_05.C0607;
>> CLASSES REP N P R G;
>> MODEL  Color = REP N | P | R | G ;
>>
>> MEANS N / LSD LINES;
>> MEANS P / LSD LINES;
>> MEANS R / LSD LINES;
>> MEANS G / LSD LINES;
>> MEANS N*P / LSD LINES;
>> MEANS N*R / LSD LINES;
>> MEANS N*G / LSD LINES;
>> MEANS P*R / LSD LINES;
>> MEANS P*G / LSD LINES;
>> MEANS R*G / LSD LINES;
>> MEANS N*P*R/ LSD LINES;
>> MEANS N*P*G / LSD LINES;
>> MEANS P*R*G / LSD LINES;
>> MEANS R*N*G / LSD LINES;
>> MEANS G*P*N / LSD LINES;
>> MEANS N*P*R*G / LSD LINES;
>> RUN;
>> quit;
>> ods rtf close;
>> quit;