Generate report in two pages

Reply
Contributor
Posts: 25

Generate report in two pages

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.
plz check. I have written the program like that.(displaying in three separate pages)
data prod_sales;
input state $ pcode $ area $ month stock sale;
cards;
AP N79 HYD 1 40 20
TN N79 CHN 1 30 10
KA N79 BAN 1 45 20
AP N79 HYD 2 30 15
TN N79 CHN 2 10 10
KA N79 BAN 2 45 30
TN N79 CHN 3 20 10
KA N79 BAN 3 25 20
AP N79 HYD 3 20 15
;
proc report data=prod_sales nowd headline;
define state/order;
define area/order;
define pcode/order;
break after state/page;
compute after state;
line 65*'-';
line 'End of the report';
endcomp;
compute before _page_;
line 'This report belongs to: ' state $6.;
endcomp;
run;
Frequent Contributor
Posts: 81

Re: Generate report in two pages

Try this...

data prod_sales;
set prod_sales;
if state in ('AP','KA') then mypage=1;
else mypage=2;
run;

proc report data=prod_sales nowd headline;
column mypage state pcode area month stock sale;
define mypage/order order=intenal noprint;
define state/order;
define area/order;
define pcode/order;
break after mypage/page;
compute after mypage;
line 65*'-';
line 'End of the report';
endcomp;
compute before _page_;
line 'This report belongs to: ' state $6.;
endcomp;
run;
Ask a Question
Discussion stats
  • 1 reply
  • 307 views
  • 0 likes
  • 2 in conversation