BookmarkSubscribeRSS Feed
dash
Obsidian | Level 7
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;
1 REPLY 1
NickR
Quartz | Level 8
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;

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

New Learning Events in April

 

Join us for two new fee-based courses: Administrative Healthcare Data and SAS via Live Web Monday-Thursday, April 24-27 from 1:00 to 4:30 PM ET each day. And Administrative Healthcare Data and SAS: Hands-On Programming Workshop via Live Web on Friday, April 28 from 9:00 AM to 5:00 PM ET.

LEARN MORE

Discussion stats
  • 1 reply
  • 909 views
  • 0 likes
  • 2 in conversation