Hey Aditya1, As you are saying you are having three tables with same variables, then you have to use set statement or use union with PROC SQL. ... View more

I am giving some clues, You can follow this : data have; input adj_code year value treatment $ state $; datalines; 0 2005 12 therap MI 1 2006 20 inpati CA 2 2007 22 inpati MI 1 2005 21 inpati MI 2 2005 22 therap CA 0 2005 10 therap CA 1 2006 19 inpati CA 2 2007 10 inpati MI 2 2006 20 therap CA 1 2006 11 inpati MI 0 2005 90 therap CA 0 2006 11 inpati MI 0 2005 99 therap MI ; run; proc format; value adj_code 0="0-NO ADJUSTMENT OF CLAIMS WAS REQUIRED" 1="1-AT LEAST ONE ORIGINAL CLAIM AND AT LEAST ONE ADJUSTMENT CLAIM" 2="2-NOT POSSIBLE TO COMPLETE THE ADJUSTMENT PROCESS"; value $treatment 'therap'="OTHER THERAPY PERCENTAGES" 'inpati'="INPATIENT PERCENTAGES"; run; ods escapechar='^'; ods pdf; proc report nowd data=have spanrows; title1 "Adjustment code claims 2.2.2, 2.3.2"; title2 "&statename., 0-18 years old"; title3 "2005-2007"; column state (adj_code) treatment,year,value;* year value treatment; define state/group; break after state/page; define adj_code/'Adjustment Code' group format=adj_code.; define treatment/''across order=internal format=$treatment.; define year/' 'across order=internal ; define value/'' sum; rbreak after/ summarize; run; ods pdf close; ... View more

@lakshmi_74 wrote: proc sql outobs=3; create table want as select * from have group by agent, priority; quit; proc print data=have;run; This would generate 200 total observations, not 200 per agent? ... View more

Thanks @gamotte . if suppose instead of only 1 buffer i have 3 buffers (buffer_1 ,buffer_2,buffer_3) and needs to pick some % of count from each buffer how can we add this in the same code. for example if you run the code 1st row remainign column value 43 so 43 required for that 43 i need three columns like buffer_1 22(50%43) and buffer_2 value(30%43) and (buffer_2 value(20%43)   Buffer 1000                             Buffer_1 500 50%   Remain Buffer_1 Buffer_2 Buffer_3 Buffer_2 300 30%   43 22 13 9 Buffer_3 200 20%           ... View more

Check the options of the client you are using. Enterprise Guide and SAS Studio have options to prevent the opening of generated results. Unfortunately this option is active or not for all results. ... View more

I don't have the software to upload the sas file here- but here is sample input file ... View more