Toad World® Forums

Toad, Teradata, Select Statement titles like SAS ODS Output


#1

Hi, is there a way to create a title line or two using SQL in a select statement, like SAS ODS Output?

Thanks for any input!

WHP

Example:

TITLE1 “&SYSDAY”;

TITLE2 “&SYSDATE”;

TITLE3 “My Name”;

TITLE4 “Data From autoy04y05y06a”;

TITLE5 “Frequencies #2”;

TITLE6 “”;

OPTIONS NODATE NONUMBER;

ODS RTF FILE = “f:\Survive\ODS\freq2.RTF”;

proc freq data = surv.autoy04y05y06a order=freq;

tables year / nocum;

run;

Ods rtf close;

quit;


#2

I am sorry but I don’t get you question.
Could you please be more specific?

Thank you.
Aleksey