Thanks Cynthia i was not aware of  this interaction between template justify/padding and the general template justify= order this is not mentionned on the style or table template sheets. but my practise of table template is too rare and of course it exists since a long time Andre ... View more

Yes but break before is necessary otherwise some more items and thus levels are reappearing !! Andre ... View more

it is possible  following another way end of your code (same template) ODS LISTING CLOSE; *ods html close; OPTIONS NODATE NONUMBER; TITLE; FOOTNOTE; OPTIONS ORIENTATION=PORTRAIT; ODS RTF FILE="d:\temp\centerTest.rtf" ; DATA _NULL_;    SET newGirl; format age best12.;    FILE PRINT ODS=(TEMPLATE="MyTABLE" COLUMNS=(name=fname  (GENERIC = ON DYNAMIC  = (COLHEADER="First name"))                             name=lname  (GENERIC = ON DYNAMIC = (COLHEADER="Last name"))                             name=nname  (GENERIC = ON DYNAMIC =(COLHEADER="Nickname"))                             age=age    (GENERIC = ON                                         DYNAMIC =(COLHEADER="Age"))                             ) );    PUT _ODS_; RUN; proc print data=newgirl noobs label Style(table)={ cellpadding=10 cellspacing=0 mm}                           style(header)={just=c}; var fname /style={just=c}; var lname /style={just=c}; var nname/style={just=c}; var age/style={just=d width=1.0in rightmargin=.25in}; run; ODS RTF CLOSE; ods listing; Now my comment upon justifying a numeric column: the amount that could appear for a numeric value can vary a lot and at start the procedure has not idea at all how to center a unknown future value numeric with decimal  comming from data with proc print although it is possible Andre But impossible through template only    perhaps not  if you follow the rules that are presented in http://support.sas.com/rnd/base/ods/scratch/styles-tips.pdf much more difficult indeed Andre ... View more

Here is my final try and success i agree about the fact that it is quite difficult with that mixed of non natural code ods html close; ods noptitle; data a; set sashelp.class; xc=1;run; ods document name=testAW(write); ods proclabel "Class"; Proc report data=a contents= "Weight < 95" nowd; Columns xc name age weight height; define xc /order noprint; break before xc / contents="" page; Define name /display; Define age/display; Define weight/display; Define height/ display; Where weight <95; Run; ods proclabel " "; Proc report data=a contents="Weight >= 95" nowd; Columns xc name age weight height; define xc /order noprint; break before xc / contents="" page; Define name /display; Define age/display; Define weight/display; Define height/ display; Where weight >=95; Run; ods pdf close; ods document close; ods ptitle; ods listing; proc document name=testAW; list/ levels=all; run; quit; *ok ok; proc document name=testAW2(write); make CLASS; dir ^^; dir CLASS; make Tab1; setlabel \Class#1\Tab1#1 "weight < 95"; copy \work.testAW\Report#1\Report#1\Report#1 to \Class#1\Tab1#1; make Tab2; setlabel \class#1\Tab2#1  "weight >95"; copy \work.testAW\Report#2\Report#1\Report#1 to \Class#1\Tab2#1; run; list/ levels=all; run; quit; proc document name=work.testAW2; ods pdf file="d:\temp\twolevels.pdf"; replay; run; ods pdf close; quit; Friday i did not see that the third level was producing an item in the toc now it is without.    Andre ... View more

Abud I have read more about document and from my solution the program is becaming now ods listing close; ods noptitle; data a; set sashelp.class; xc=1;run; ods document name=testTOC(write); ods pdf file="d:\temp\twolevels.pdf" bookmarkgen=yes ; ods proclabel "Class"; Proc report data=a contents= " Weight < 95" nowd; Columns xc name age weight height; define xc /order noprint; break before xc / contents="" page; Define name /display; Define age/display; Define weight/display; Define height/ display; Where weight <95; Run; ods proclabel " "; Proc report data=a contents=" Weight >= 95" nowd; Columns xc name age weight height; define xc /order noprint; break before xc / contents="" page; Define name /display; Define age/display; Define weight/display; Define height/ display; Where weight >=95; Run; ods pdf close; ods document close; ods ptitle; ods listing; proc document name=testTOC; list/ levels=all; run;quit; ods listing close; proc document name=newtestTOC(write); make CLASS; dir ^^; dir CLASS; dir; copy \work.testTOC\Report#1\Report#1 to ^; copy \work.testTOC\Report#2\Report#1 to ^; run; list/ levels=all; run; quit; proc document name=work.Newtesttoc; ods pdf file="d:\temp\twolevelscorrect.pdf"; replay; run; ods pdf close; quit; with this results I found it more easier to reconstruct a new document in place of moving and loosing node+labels! I recall that colored code was copied to word and then recopied  from word to this screen. Andre ... View more

Manually as the third level you want is dependent of the empty second or go into this solution i never have test http://support.sas.com/kb/16/215.html0 Andre support.sas.com/resources/papers/proceedings11/252-2011.pdf ... View more

Here is a solution data a; set sashelp.class; xc=1;run; ods pdf file="d:\temp\twolevels.pdf" bookmarkgen=yes ; ods proclabel "first knot global"; Proc report data=a contents= " Weight < 95" nowd; Columns xc name age weight height; define xc /group noprint; break before xc / contents="" page; Define name /display; Define age/display; Define weight/display; Define height/ display; Where weight <95; Run; ods noptitle ; ods proclabel " "; Proc report data=a contents=" Weight >= 95" nowd; Columns xc name age weight height; define xc /group noprint; break before xc / contents="" page; Define name /display; Define age/display; Define weight/display; Define height/ display; Where weight >=95; Run; ods pdf close; the trick is to create a non visible xc  that could help us to eliminate the third level in the report HTH Andre contents="" and not contents=" " ... View more

Scott copying from the enhanced editor to Word (2010 for me) and then copy from word to the answer screen  as it is. I think it is working data two;   length name age inc $40;   set one;   rx=prxparse("/^(.*?)(\d+)\s+(.*)$/");   if prxmatch(rx,line) then do; name=prxposn(rx,1,line);     * age=input(prxposn(rx,2,line),best.); age=prxposn(rx,2,line);     * inc=input(prxposn(rx,3,line),dollar18.); inc=prxposn(rx,3,line); inc2=input(inc,dollar18.);   end;   format inc2 dollar18.; run; HTH Andre ... View more