ods word with table of contents using proc(s)

acordes — Mon, 09 Jan 2023 11:03:12 GMT

I want ods to create a table of content.

But it is empty.

I'd like to reference in the TOC every table the proc generates.

the trace on statement reveals the distinct tables:

Output Added:

-------------

Name: NObs

Label: Number of Observations

Template: freqTab.freqTab.NObs

Path: CAS.freqTab.NObs

-------------

Output Added:

-------------

Name: LevelInfo

Label: Variable Level Information

Template: freqTab.freqTab.LevelInfo

Path: CAS.freqTab.LevelInfo

-------------

Output Added:

-------------

Name: OneWayFreqs

Label: One-Way Frequencies

Template: freqTab.freqTab.OneWayFreqs

Path: CAS.freqTab.Table1.OneWayFreqs

-------------

Output Added:

-------------

Name: OneWayFreqs

Label: One-Way Frequencies

Template: freqTab.freqTab.OneWayFreqs

Path: CAS.freqTab.Table2.OneWayFreqs

-------------

Output Added:

-------------

Name: OneWayFreqs

Label: One-Way Frequencies

Template: freqTab.freqTab.OneWayFreqs

Path: CAS.freqTab.Table3.OneWayFreqs

-------------

Output Added:

-------------

Name: OneWayFreqs

Label: One-Way Frequencies

Template: freqTab.freqTab.OneWayFreqs

Path: CAS.freqTab.Table4.OneWayFreqs

-------------

Output Added:

-------------

Name: OneWayFreqs

Label: One-Way Frequencies

Template: freqTab.freqTab.OneWayFreqs

Path: CAS.freqTab.Table5.OneWayFreqs

-------------

Output Added:

-------------

Name: OneWayFreqs

Label: One-Way Frequencies

Template: freqTab.freqTab.OneWayFreqs

Path: CAS.freqTab.Table6.OneWayFreqs

-------------

Output Added:

-------------

Name: OneWayFreqs

Label: One-Way Frequencies

Template: freqTab.freqTab.OneWayFreqs

Path: CAS.freqTab.Table7.OneWayFreqs

-------------

Output Added:

-------------

Name: OneWayFreqs

Label: One-Way Frequencies

Template: freqTab.freqTab.OneWayFreqs

Path: CAS.freqTab.Table8.OneWayFreqs

-------------

Output Added:

-------------

Name: OneWayFreqs

Label: One-Way Frequencies

Template: freqTab.freqTab.OneWayFreqs

Path: CAS.freqTab.Table9.OneWayFreqs

-------------

Output Added:

-------------

Name: OneWayFreqs

Label: One-Way Frequencies

Template: freqTab.freqTab.OneWayFreqs

Path: CAS.freqTab.Table10.OneWayFreqs

-------------

Output Added:

-------------

Name: OneWayFreqs

Label: One-Way Frequencies

Template: freqTab.freqTab.OneWayFreqs

Path: CAS.freqTab.Table11.OneWayFreqs

-------------

Output Added:

-------------

Name: OneWayFreqs

Label: One-Way Frequencies

Template: freqTab.freqTab.OneWayFreqs

Path: CAS.freqTab.Table12.OneWayFreqs

-------------

Output Added:

-------------

Name: OneWayFreqs

Label: One-Way Frequencies

Template: freqTab.freqTab.OneWayFreqs

Path: CAS.freqTab.Table13.OneWayFreqs

-------------

Output Added:

-------------

Name: OneWayFreqs

Label: One-Way Frequencies

Template: freqTab.freqTab.OneWayFreqs

Path: CAS.freqTab.Table14.OneWayFreqs

-------------

Output Added:

-------------

Name: OneWayFreqs

Label: One-Way Frequencies

Template: freqTab.freqTab.OneWayFreqs

Path: CAS.freqTab.Table15.OneWayFreqs

-------------

Output Added:

-------------

Name: OneWayFreqs

Label: One-Way Frequencies

Template: freqTab.freqTab.OneWayFreqs

Path: CAS.freqTab.Table16.OneWayFreqs

-------------

Output Added:

-------------

Name: Timing

Label: Timing

Template: freqTab.freqTab.Timing

Path: CAS.freqTab.Timing

-------------

Output Added:

-------------

Name: OutputCasTables

Label: Output CAS Tables

Template: CAS.Common.OutputCasTables

Path: CAS.freqTab.OutputCasTables

And I have another challenge. How Do I output comments to the destination?

Imagine having a proc freq followed by a proc sgplot.

I want to add a comment lines BETWEEN the proc output so that I can guide the reader.

ods word file="/caslibs/marketing/&tab._topn.docx" options(contents="on" toc_data="on" keep_next="on");
title "Top 10 Freq";
ods proclabel=" ";

proc cas;   action freqTab.freqTab /displayOut={names={"OneWayFreqs"="out2"}} 
tabDisplay={format= "list", maxLevels=10,missingFreq=false} order= "FREQ", 
descending=false,table={name="ALEX_PPNC_HIST_V1", caslib="&casy."}      
tabulate={'Mes_Actual', 'Codigo_marca', 'Mes_actual_poliza', 'Tipo', 'Tipo_de_tarifa_de_seguro', 'Num_Siniestros', 
'Top_modelo', 'Grupo_duracion_contrato', 'Meses_contables_operacion', 'Tipo_de_cliente', 'Estado_operacion', 'Poliza_cancelada', 
'Operacion_viva', 'Poliza_en_riesgo_informe_TAM', 'Anyo_Vencimiento_operacion', 'NIF_CIF'};
run;

ods word close;

Re: ods word with table of contents using proc(s)

acordes — Mon, 09 Jan 2023 11:56:18 GMT

Ok, with an ODS text="your text"; line I can add text between proc outputs.

In the generated docx I can select the table to "insert caption". Then I create a table of figures and it recognizes the different tables.

Can I force the tables to have caption, i.e. the pathname from the trace log?

Output Added:

-------------

Name: OneWayFreqs

Label: One-Way Frequencies

Template: freqTab.freqTab.OneWayFreqs

Path: CAS.freqTab.Table2.OneWayFreqs

Re: ods word with table of contents using proc(s)

acordes — Mon, 09 Jan 2023 15:23:25 GMT

I've seen that the ods pdf generates what I'm looking for.

But can ods word do the same?

Re: ods word with table of contents using proc(s)

ballardw — Mon, 09 Jan 2023 18:29:05 GMT

Last time I checked ODS WORD is still not production.

I would recommend ODS RTF and then if a docx file format is required to use your word processor to change from RTF to docx.

Re: ods word with table of contents using proc(s)

cminard — Thu, 05 Dec 2024 14:05:38 GMT

Word does not automatically display the TOC.

1. Generate your word document.

2. press ctrl+a to select all (i.e., the entire document)

3. press f9

https://support.sas.com/resources/papers/proceedings20/4265-2020.pdf

Note that Word doesn't automatically display the TOC when you open the document. You
can manually display the TOC by pressing CTRL+A F9 on your keyboard. Another Word tip:
If you jump f rom the TOC to the body of the report, then you can jump back to the TOC by
pressing ALT ←.

topic ods word with table of contents using proc(s) in SAS Programming

ods word with table of contents using proc(s)

Re: ods word with table of contents using proc(s)

Re: ods word with table of contents using proc(s)

Re: ods word with table of contents using proc(s)

Re: ods word with table of contents using proc(s)