Date: Fri, 30 Dec 2005 19:06:47 -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 ?
Content-Type: text/plain; charset="us-ascii"
TJ,
The table/dataset called MCLINESINFO has two variables (don't see what
they're called), with 5 observations - the first observation has the
values "Alpha" and "0.05". The MCLINES table/dataset has 4 variables ...
etc..
The idea here is that ODS has created datasets containing the output
tables you've selected. By printing them (or using Proc Contents), you
can see what variables have been named and what structure the datasets
are. Then you can use and abuse them to your heart's desire.
Run this to see what you have...
Ods output mclinesinfo=first
mclines=second;
proc glm ... etc... run;
ods output close;
proc print data=first; run;
proc print data=second; run;
OK, what do the datasets look like? Are there any variables in common to
use to merge? (Again, I don't see what dataset(s) you're trying to
merge.)
Hopefully, that will get you going in the right direction.
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 6:21 PM
>> To: SAS-L@LISTSERV.UGA.EDU
>> Cc: T J Lawson
>> Subject: Re: ods output development ?
>>
>> 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;
>> >>>
>> >>>
>> >
>> >
>> >
>> >
| 
