https://communities.sas.com/t5/SAS-Programming/Proc-repot/m-p/43897#M8999 provider drugname totalsales<BR /> ABC mydrug 250<BR /> ABC comp1 100 <BR /> ABC mydrug 250<BR /> ABC comp2 100 <BR /> ABC comp3 100 <BR /> PQR mydrug 250<BR /> PQR comp1 100 <BR /> pqr mydrug 250<BR /> pqr comp2 100 <BR /> pqr comp3 100 <BR /> <BR /> For the above data I need to generate output this way.<BR /> Note:The numbers are arbitrary.This is only to show how the data looks and how the output must look.In real data, I have around 20 providers and 7 different drugs.<BR /> The percentage shows the percentage of the drug sales.<BR /> I tried this creating 20 different datasets for each drug and its sum and percentage.This is tedious in a way.<BR /> Any help is appreciated.<BR /> <BR /> <BR /> <BR /> <BR /> Provider totalpres mydrug comp1 comp2 mydrug comp3 <BR /> ABC 1000 250 30% 20% 25% 25%<BR /> PQR 500 250 15% 20% 50% 25% Fri, 12 Jun 2009 15:20:50 GMT SASPhile 2009-06-12T15:20:50Z https://communities.sas.com/t5/SAS-Programming/Proc-repot/m-p/43897#M8999 provider drugname totalsales<BR /> ABC mydrug 250<BR /> ABC comp1 100 <BR /> ABC mydrug 250<BR /> ABC comp2 100 <BR /> ABC comp3 100 <BR /> PQR mydrug 250<BR /> PQR comp1 100 <BR /> pqr mydrug 250<BR /> pqr comp2 100 <BR /> pqr comp3 100 <BR /> <BR /> For the above data I need to generate output this way.<BR /> Note:The numbers are arbitrary.This is only to show how the data looks and how the output must look.In real data, I have around 20 providers and 7 different drugs.<BR /> The percentage shows the percentage of the drug sales.<BR /> I tried this creating 20 different datasets for each drug and its sum and percentage.This is tedious in a way.<BR /> Any help is appreciated.<BR /> <BR /> <BR /> <BR /> <BR /> Provider totalpres mydrug comp1 comp2 mydrug comp3 <BR /> ABC 1000 250 30% 20% 25% 25%<BR /> PQR 500 250 15% 20% 50% 25% Fri, 12 Jun 2009 15:20:50 GMT https://communities.sas.com/t5/SAS-Programming/Proc-repot/m-p/43897#M8999 SASPhile 2009-06-12T15:20:50Z https://communities.sas.com/t5/SAS-Programming/Proc-repot/m-p/43898#M9000 Suggest a DATA step to prepare your data (hint: UPCASE on provider), then PROC TRANSPOSE (vertical data to horizontal) using BY. Then PROC PRINT or PROC REPORT.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Fri, 12 Jun 2009 15:39:54 GMT https://communities.sas.com/t5/SAS-Programming/Proc-repot/m-p/43898#M9000 sbb 2009-06-12T15:39:54Z