table of contents in ods RTF

JBrazier — Tue, 14 Apr 2015 14:32:37 GMT

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

Chart 2 : Distribution of new Undergraduate UK students by age, 2009/10 to 2013/14............................................................................................ 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

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

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

Re: table of contents in ods RTF

Cynthia_sas — Tue, 14 Apr 2015 15:01:14 GMT

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

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

cynthia

topic Re: table of contents in ods RTF in ODS and Base Reporting

table of contents in ods RTF

Re: table of contents in ods RTF