The SAS Output Delivery System and reporting techniques

table of contents in ods RTF

Reply
Occasional Contributor
Posts: 6

table of contents in ods RTF

Hi

I am producing a report and am creating a table of contents.  At the initial creation of it the contents looks like the following:

Table 1: Headcount of students at a third and proportion of total, by age, 2009/10 to 2013/14............................................................................ 1

    Cross-tabular summary report........................................................................................................................................................................................... 1

       Table 1............................................................................................................................................................................................................................... 1

Chart 1 : Distribution of all Undergraduate UK students by age, 2009/10 to 2013/14............................................................................................... 2

      Gchart..................................................................................................................................................................................................................................... 2

Table 2: Headcount of students at a third and proportion of total, by age, 2009/10 to 2013/14............................................................................ 3

    Cross-tabular summary report........................................................................................................................................................................................... 3

       Table 1............................................................................................................................................................................................................................... 3

Chart 2 : Distribution of new Undergraduate UK students by age, 2009/10 to 2013/14............................................................................................ 4

      Gchart..................................................................................................................................................................................................................................... 4

However I do not want all the additional points that appear below the "Table 1:" or "Chart 1".  I just want the first line of each process so it looks like this:

Table 1: Headcount of students at a third and proportion of total, by age, 2009/10 to 2013/14............................................................................ 1

Chart 1 : Distribution of all Undergraduate UK students by age, 2009/10 to 2013/14............................................................................................... 2

Table 2: Headcount of students at a third and proportion of total, by age, 2009/10 to 2013/14............................................................................ 3

Chart 2 : Distribution of new Undergraduate UK students by age, 2009/10 to 2013/14............................................................................................ 4

I have added the [contents = ' '] to the proc tabulate data step and the after the table option and it removes it from the table of contents.  So at the moment my tables of contents looks like this:

Table 1: Headcount of students at a third and proportion of total, by age, 2009/10 to 2013/14............................................................................ 1

Chart 1 : Distribution of all Undergraduate UK students by age, 2009/10 to 2013/14............................................................................................... 2

                Gchart..................................................................................................................................................................................................................................... 2

Table 2: Headcount of students at a third and proportion of total, by age, 2009/10 to 2013/14............................................................................ 3

Chart 2 : Distribution of new Undergraduate UK students by age, 2009/10 to 2013/14............................................................................................ 4

                Gchart..................................................................................................................................................................................................................................... 4

However no matter what I do in proc gchart code I cannot get rid of the "Gchart" that appears in the table of contents.  I have added the option [description = ' '] but "Gchart" still appears. 


My proc ghart code looks like


   axis1 label=&axis1_label. value=none;

   axis2 label=&axis2_label.;

   axis3 label=&axis3_label.;

   legend1 label=&legend1_label.;


                  proc gchart data = &dset_out. (where = (&var1. NE ''));

                     vbar acad_yr / discrete

                                    type = sum

                                    sumvar = &headcount._PctSum_100

                                    group = &chart_var.

                                    subgroup = acad_yr

                     space=0 gspace=2.5

                     maxis=axis1

                     raxis=axis2

                     gaxis=axis3

                     legend=legend1

                     autoref clipref cref=graycc

                     coutline=black

                     des = ' '

                     description = ' '

                     ;

                  run;

                  quit;

Does anyone know I can remove the "Gchart" part from the table of contents

SAS Super FREQ
Posts: 8,819

Re: table of contents in ods RTF

Hi:

  This may be a question for Tech Support. If you can't remove the "Gchart" from the TOC any other way, then you might need to switch to ODS DOCUMENT -- create all your pieces in an ODS DOCUMENT store and then make your own folder structure and move or copy objects from the original structure to the new folder structure. I believe there have been several different forum postings about using ODS DOCUMENT to construct a custom TOC with your own defined structure. Here are a few of the previous links:

https://communities.sas.com/message/47423#47423

or

https://communities.sas.com/message/10100#10100 (instead of putting in extra levels, you want to take them out)

cynthia

Ask a Question
Discussion stats
  • 1 reply
  • 389 views
  • 3 likes
  • 2 in conversation