From: Yu Zhang on
Hi, Jake,

Check the ODS text= if you are using SAS V9. The link to the SAS ducument
about this feature is here:

http://support.sas.com/rnd/base/topics/new92/92odsmore.html

HTH

Yu


On 1/21/07, Jake Bee <johbee(a)gmail.com> wrote:
>
> Dear SAS-L:
>
> I have the following code for tabulate, and for table all={label = ....};
> I
> can put a nice label at the top of the tabulated box.
>
> Does anyone know if there is a companion way in tabuate to do this at the
> bottom of each tabulate box?
>
> I can't use a footnote since I am putting the output to a pdf file with 4
> tabulate boxes per page, thus each box would be different.
> I would actuall prefer to put the p-Value at the bottom of each box vs.
> the
> way I'm doing it now with box={label "pValue &pval"...};
>
> Since I am using ODS and proc document to create the output, perhaps there
> is ODS [labeling] syntax to accomplish this, but
> I can't seem to find much documentation on the SAS site, probably since I
> don't know what to search for --proc document is
> new to me.
>
> This related to the previous help I had last week to set up the ODS which
> is
> also new to me. The results are great, and I think
> once completed, that I'll post the code for others to use, or comments and
> suggestions for improvement. But for now I'm going to as
> my questions one at a time.
>
> Thanks for any help, and Thanks for the help and presentation links last
> week.
>
> Jake
>
> %macro stats(prf);
> ods document name=aetx_&prf(write);
> ods noptitle;
> ods ESCAPECHAR='^';
>
> %do cat = 1 %to 4;
> ods output CrossTabFreqs = FRY_&prf._&cat;
>
> [... other proc freq code here not displayed ...]
>
> proc tabulate noseps
> data=_last_;
> class category aes dose
> ;
> var
> Frequency;
> table all={label = "%left(%trim(&adverse_event))"
> s={foreground=blue}},
> (category)*( aes all), (dose all='Total') *
> Frequency = " "* sum = ''*f=comma8. / rts=25.
> box = {label="pValue &pval" s={foreground=purple}} ;
> run;
> %end;
>
> ods document close;
>
> %mend;
>
From: Andre Wielki on
Yu,
Your reference are showing new features of v9.2!
Incidently i see that Sas would support the SVG format of Adobe
BUT This editor is just announcing that the support for SVG
is stopping at end 2007!

Andre


Yu Zhang a �crit :
> Hi, Jake,
>
> Check the ODS text= if you are using SAS V9. The link to the SAS ducument
> about this feature is here:
>
> http://support.sas.com/rnd/base/topics/new92/92odsmore.html
>
> HTH
>
> Yu
>
>
> On 1/21/07, Jake Bee <johbee(a)gmail.com> wrote:
>>
>> Dear SAS-L:
>>
>> I have the following code for tabulate, and for table all={label =
>> ....};
>> I
>> can put a nice label at the top of the tabulated box.
>>
>> Does anyone know if there is a companion way in tabuate to do this at the
>> bottom of each tabulate box?
>>
>> I can't use a footnote since I am putting the output to a pdf file with 4
>> tabulate boxes per page, thus each box would be different.
>> I would actuall prefer to put the p-Value at the bottom of each box vs.
>> the
>> way I'm doing it now with box={label "pValue &pval"...};
>>
>> Since I am using ODS and proc document to create the output, perhaps
>> there
>> is ODS [labeling] syntax to accomplish this, but
>> I can't seem to find much documentation on the SAS site, probably since I
>> don't know what to search for --proc document is
>> new to me.
>>
>> This related to the previous help I had last week to set up the ODS which
>> is
>> also new to me. The results are great, and I think
>> once completed, that I'll post the code for others to use, or comments
>> and
>> suggestions for improvement. But for now I'm going to as
>> my questions one at a time.
>>
>> Thanks for any help, and Thanks for the help and presentation links last
>> week.
>>
>> Jake
>>
>> %macro stats(prf);
>> ods document name=aetx_&prf(write);
>> ods noptitle;
>> ods ESCAPECHAR='^';
>>
>> %do cat = 1 %to 4;
>> ods output CrossTabFreqs = FRY_&prf._&cat;
>>
>> [... other proc freq code here not displayed ...]
>>
>> proc tabulate noseps
>> data=_last_;
>> class category aes dose
>> ;
>> var
>> Frequency;
>> table all={label = "%left(%trim(&adverse_event))"
>> s={foreground=blue}},
>> (category)*( aes all), (dose all='Total') *
>> Frequency = " "* sum = ''*f=comma8. / rts=25.
>> box = {label="pValue &pval" s={foreground=purple}} ;
>> run;
>> %end;
>>
>> ods document close;
>>
>> %mend;
>>
>
>


--
Andre Wielki
INED (Institut National d'Etudes D�mographiques)
133 Boulevard Davout 75980 Paris Cedex 20
33 (0) 1 56 06 21 54 FRANCE
From: Jake Bee on
All of this helps very much Thank You!
Jake


On 1/22/07, Andre Wielki <wielki(a)ined.fr> wrote:
>
> Yu,
> Your reference are showing new features of v9.2!
> Incidently i see that Sas would support the SVG format of Adobe
> BUT This editor is just announcing that the support for SVG
> is stopping at end 2007!
>
> Andre
>
>
> Yu Zhang a =E9crit :
> > Hi, Jake,
> >
> > Check the ODS text=3D if you are using SAS V9. The link to the SAS
> ducument
> > about this feature is here:
> >
> > http://support.sas.com/rnd/base/topics/new92/92odsmore.html
> >
> > HTH
> >
> > Yu
> >
> >
> > On 1/21/07, Jake Bee <johbee(a)gmail.com> wrote:
> >>
> >> Dear SAS-L:
> >>
> >> I have the following code for tabulate, and for table all=3D{label =
=3D
> >> ....};
> >> I
> >> can put a nice label at the top of the tabulated box.
> >>
> >> Does anyone know if there is a companion way in tabuate to do this at
> the
> >> bottom of each tabulate box?
> >>
> >> I can't use a footnote since I am putting the output to a pdf file wit=
h
> 4
> >> tabulate boxes per page, thus each box would be different.
> >> I would actuall prefer to put the p-Value at the bottom of each box vs=
..
> >> the
> >> way I'm doing it now with box=3D{label "pValue &pval"...};
> >>
> >> Since I am using ODS and proc document to create the output, perhaps
> >> there
> >> is ODS [labeling] syntax to accomplish this, but
> >> I can't seem to find much documentation on the SAS site, probably sinc=
e
> I
> >> don't know what to search for --proc document is
> >> new to me.
> >>
> >> This related to the previous help I had last week to set up the ODS
> which
> >> is
> >> also new to me. The results are great, and I think
> >> once completed, that I'll post the code for others to use, or comments
> >> and
> >> suggestions for improvement. But for now I'm going to as
> >> my questions one at a time.
> >>
> >> Thanks for any help, and Thanks for the help and presentation links
> last
> >> week.
> >>
> >> Jake
> >>
> >> %macro stats(prf);
> >> ods document name=3Daetx_&prf(write);
> >> ods noptitle;
> >> ods ESCAPECHAR=3D'^';
> >>
> >> %do cat =3D 1 %to 4;
> >> ods output CrossTabFreqs =3D FRY_&prf._&cat;
> >>
> >> [... other proc freq code here not displayed ...]
> >>
> >> proc tabulate noseps
> >> data=3D_last_;
> >> class category aes dose
> >> ;
> >> var
> >> Frequency;
> >> table all=3D{label =3D "%left(%trim(&adverse_event))"
> >> s=3D{foreground=3Dblue}},
> >> (category)*( aes all), (dose all=3D'Total') *
> >> Frequency =3D " "* sum =3D ''*f=3Dcomma8. / rts=3D25.
> >> box =3D {label=3D"pValue &pval" s=3D{foreground=3Dpurple}} ;
> >> run;
> >> %end;
> >>
> >> ods document close;
> >>
> >> %mend;
> >>
> >
> >
>
>
> --
> Andre Wielki
> INED (Institut National d'Etudes D=E9mographiques)
> 133 Boulevard Davout 75980 Paris Cedex 20
> 33 (0) 1 56 06 21 54 FRANCE
>