*Thanks. Finally ***My solution*;I got similar solution using proc sql into;       data tableB_x;   set tableb;       id=_n_;     new_rs=cat('^{newline 1}',trim(Reasons_of_parent_are_important));   if id=1 then new_rs=Reasons_of_parent_are_important;   run;               proc sql noprint;   select new_rs   into: footnote separated by ' '   from tableB_x;   quit;   %put &footnote;     ods rtf file="h:\sas\sas question\my_Expect_Table.rtf";   title1 "Expect Table : ";   ods escapechar='^';   proc report data=main_table;   column reason_for_love_parent cnt class1_n class2_n;   define reason_for_love_parent / order order=data;   define cnt / 'Overall/(N)';   define class1_n / 'Class1/(N)';   define class2_n/ 'Class2/(N)';   compute after / style={just=l};   line "Reasons of parent are important";   line "&footnote" ;   endcomp;   run;   ... View more

That is a great idea! works well. Thanks ... View more

Thanks ! Your code should work. How the layout of the footnotes should imbed under the tableA as a part of table. See my expected output below ... View more

Thanks. Iet me try !! ... View more

libname sasq "h:\...\sas\sas question"; /* CREAT MACRO VARIABLE*/ data _null_; set sasq.tableb;; call symput('footnote'||left(_n_), reasons_of_parent_are_important); run; %put &footnote1 &footnote3; /*ODS OUTPUT*/ ods rtf file="h:\...\sas\sas question\Expect_Table.rtf"; title1 "Expect Table : "; proc report data=sasq.tableA split="|" NOWD ; column Reason_For_Love_Parent Overall_N_ Class1_N_ Class2_N_; define Reason_For_Love_Parent/display "Reason For Love Parent" style=[cellwidth=2 in just=l]; define Overall_N_/display "Overall(N)" style=[cellwidth=2 in just=c]; define Class1_N_/display "Class1(N)" style=[cellwidth=2 in just=c]; define Class2_N_/display "Class2(N)" style=[cellwidth=2 in just=c]; compute after /style=[just=l ]; line "Reasons of parent are important"; line "&footnote1"; line "&footnote2"; line "&footnote3"; /* line "&footnote4"; */ /* line "&footnote5"; */ /* line "&footnote6"; */ /* line "&footnote7"; */ /* line "&footnote8"; */ /* line "&footnote9"; */ /* line "&footnote10"; */ /* line "&footnote11"; */ /* line "&footnote12"; */ endcomp; run; ods rtf close;   Dear all: Above is my sas code and output.  The question still remains on TableB is dynamic. Current only have 3 rows, so it sounds works. However, when the raw data for tableB updated, it might 10s or 100s rows. Anyone could have an ideal.   Alternative, I think using Proc Sql Select into to create macro which is dynamic. but the footnotes aredisplay as long strain not listed "row by row" . Anyone has an idea to make it listed "row by raw"?   Thanks   ... View more

I should make my question AS;   I have a two dataset, TableA, TableB. TableA has four columns, and TableB only have one column (“Reasons_of_parent_are_important”). Current the row in TableB only has 3 rows; however, the rows may changed as the input raw dataset for TableB updated.  We are requested to make tableB as DYNAMIC  footnote of TableA. The expected output is show as Expect Table.rtf. Can we use proc report to do this and how to do it? If proc report is the best way, what is the alternative way? ... View more

Thanks for reply. Yes, I do know how to create macro for each line as you stated, which I actually do it in another report. However, TableB is dynamic. Current, TableB only has 3 rows; however It might be 4 rows or even more than hundreds row as input raw dataset  for TableB updated. ... View more