I think i make the question complicated with my world and dummy data attachment, all of the variables in my attachment are for display only, no summary calculation. The overalleval was not a summary data, it is a trait measurement like oil product. so there is no summary data in table. the year 2009-2013 etc are just for display purpose, it can be one year, two years, so it doesn't matter how many columns. let me make the question easier with the shoe table. and use Africa as example. I want to create a shoe sale report for Africa. Same subsidiary will have a one common title1, each shoe product will have an individual table and individual title2. (i know it looks silly with this 1 row table, but it represent my problem well) i want to create a table like below for all shoe product. the ideal report template is in attached for shoes table. therefore, for subsidiary Addis Ababa, i will have 8 similar shoe product tables , each page can have maximum 3 tables, title 1 only appeared once at the first table for the same subsidiary, and title 2 need to incluced for each individual product table. title1 : Addis Ababa title 2 Boot Sale Prodcut: Boot Number of stores Total sales Total Inventory Total Returns Boot 12 $29,761 $191,821 $769 therefore, it will occupie 3 pages for the subsidiary Addis Ababa, and then i need start at page 4 for a new Subsidiary Algiers. ALgiers do not have all 8 product, only 7 products, therefore 7 table, still occupie 3 pages, for the next subsidiary Cairo, i will start at page7. so far so good, but when come to the subsidiary Johannesburg, there are only 5 shoe products, it will only use two pages, then i need go to a new subsidiary. something like that (see attached). I am not sure whether i clear enough. i have attached a pdf layout. after all the subsidiary for Africa was done, then the report for Africa is done. My original thought, hard code for all titles and all product one by one. I know it's looks stupid to do this, but that makes me have control on page number and table numbers in each page. but the problem is that when I go to the second subsidiary, it has no product for women's causual, therefore, i have title text, and space reserved , but no data, and a big blank left in the report. ods pdf file='test1.pdf'; ods layout start; /*define page numer*/ ods region x=11in y=7.5in width=0.2 in height=0.2in; ods text= "1"; /*define text title*/ ods region x=2.0in y=0.5 in width=7.8 in height=1in; ods text= "Shoes sale for Addis Ababa"; ods region x=2.0in y=0.7 in width=7.8 in height=1in; ods text= "Boot sale"; ods region x=0.1in y=0.9in width=11.5in height=3.5in; proc report data=shoes nowd ; column product Stores Sales inventory returns; where region="Africa" and subsidiary="Addis Ababa" and product="Boot"; run; ods layout end; ods pdf close; This is really disgusting looking with many blanks for these missing shoe product. so i am think using below code to avoid blank. but i lost the control of table number at each page, and the title not working very well. ods pdf file='test1.pdf' startpage=no; options nobyline nonumber; title1 "Subsidiary: #byval(subsidiary)"; title2 "#byval(product) Sale"; proc report data=shoes nowd ; column product Stores Sales inventory returns; by subsidiary product; where region="Africa" ; define subsidiary/order noprint; define product/order noprint; compute before _page_; length pgline $25; pgline = catx(' ',"Product for",Product); line pgline $25.; endcomp; run; ods pdf close; any help will really appreciated.
... View more