Date: Fri, 30 Dec 2005 18:20:39 -0500
Reply-To: lawson@AESOP.RUTGERS.EDU
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: T J Lawson <lawson@AESOP.RUTGERS.EDU>
Subject: Re: ods output development ?
In-Reply-To: <148E8334465C024399DD7B14E61D7D150DB26A0F@m-nchstp-2.nchstp.cdc.gov>
Content-type: text/plain; format=flowed; charset=ISO-8859-1
John and SAS-L
How do you pull out the values I would like from the ods output.
This output would flow into summary table.
Thank you
T J Lawson
-------------
Name: MCLinesInfo
Label: Information
Template: stat.GLM.SquashFact
Path: GLM.Means.R.Color.MCLines.T.MCLinesInfo
-------------
Alpha 0.05
Error Degrees of Freedom 45
Error Mean Square 0.273611
Critical Value of t 2.01410
Least Significant Difference *0.2634*
-------------
Name: MCLines
Label: Comparisons
Template: stat.GLM.MCLines
Path: GLM.Means.R.Color.MCLines.T.MCLines
-------------
Means with the same letter are not significantly
different.
t Grouping Mean N *R** *
A *6.1875** * 32 *+*
B *5.8750** * 32 *-*
-------------------------------------------------------------------------------------
Gerstle, John wrote:
>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;
>>>
>>>
>
>
>
>
| 
