https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/Generate-report-in-two-pages/m-p/66504#M1578 How can I report the below data state wise (AP KA TN) in two pages in stead of three; AP and KA data should be in one page and TN data in another page.<BR /> plz check. I have written the program like that.(displaying in three separate pages)<BR /> data prod_sales;<BR /> input state $ pcode $ area $ month stock sale;<BR /> cards;<BR /> AP N79 HYD 1 40 20<BR /> TN N79 CHN 1 30 10<BR /> KA N79 BAN 1 45 20<BR /> AP N79 HYD 2 30 15<BR /> TN N79 CHN 2 10 10<BR /> KA N79 BAN 2 45 30<BR /> TN N79 CHN 3 20 10<BR /> KA N79 BAN 3 25 20<BR /> AP N79 HYD 3 20 15<BR /> ;<BR /> proc report data=prod_sales nowd headline;<BR /> define state/order;<BR /> define area/order;<BR /> define pcode/order;<BR /> break after state/page;<BR /> compute after state;<BR /> line 65*'-';<BR /> line 'End of the report';<BR /> endcomp;<BR /> compute before _page_;<BR /> line 'This report belongs to: ' state $6.;<BR /> endcomp;<BR /> run; Fri, 28 Jan 2011 01:54:57 GMT dash 2011-01-28T01:54:57Z https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/Generate-report-in-two-pages/m-p/66504#M1578 How can I report the below data state wise (AP KA TN) in two pages in stead of three; AP and KA data should be in one page and TN data in another page.<BR /> plz check. I have written the program like that.(displaying in three separate pages)<BR /> data prod_sales;<BR /> input state $ pcode $ area $ month stock sale;<BR /> cards;<BR /> AP N79 HYD 1 40 20<BR /> TN N79 CHN 1 30 10<BR /> KA N79 BAN 1 45 20<BR /> AP N79 HYD 2 30 15<BR /> TN N79 CHN 2 10 10<BR /> KA N79 BAN 2 45 30<BR /> TN N79 CHN 3 20 10<BR /> KA N79 BAN 3 25 20<BR /> AP N79 HYD 3 20 15<BR /> ;<BR /> proc report data=prod_sales nowd headline;<BR /> define state/order;<BR /> define area/order;<BR /> define pcode/order;<BR /> break after state/page;<BR /> compute after state;<BR /> line 65*'-';<BR /> line 'End of the report';<BR /> endcomp;<BR /> compute before _page_;<BR /> line 'This report belongs to: ' state $6.;<BR /> endcomp;<BR /> run; Fri, 28 Jan 2011 01:54:57 GMT https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/Generate-report-in-two-pages/m-p/66504#M1578 dash 2011-01-28T01:54:57Z https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/Generate-report-in-two-pages/m-p/66505#M1579 Try this...<BR /> <BR /> data prod_sales;<BR /> set prod_sales;<BR /> if state in ('AP','KA') then mypage=1;<BR /> else mypage=2;<BR /> run;<BR /> <BR /> proc report data=prod_sales nowd headline;<BR /> column mypage state pcode area month stock sale;<BR /> define mypage/order order=intenal noprint;<BR /> define state/order;<BR /> define area/order;<BR /> define pcode/order;<BR /> break after mypage/page;<BR /> compute after mypage;<BR /> line 65*'-';<BR /> line 'End of the report';<BR /> endcomp;<BR /> compute before _page_;<BR /> line 'This report belongs to: ' state $6.;<BR /> endcomp;<BR /> run; Wed, 02 Feb 2011 14:10:23 GMT https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/Generate-report-in-two-pages/m-p/66505#M1579 NickR 2011-02-02T14:10:23Z