https://communities.sas.com/t5/SAS-Procedures/Doubt-in-Using-REPORT-Procedure/m-p/24499#M5537 Hi All,<BR /> <BR /> I am having problem with my current coding.<BR /> <BR /> I have a file with Department Id, Agent Id Month and Sales info. There will be 2 - 4 occurence for a particular agent. I have to create a report for every agent with Agent Id and Department Id dipslayed on the top and Month and Sales Info as detailed lines. I am able to do one agent per page I am to put 3 agents per page but I couldnt. Any Help will be appreciated...<BR /> <BR /> The Report should look like<BR /> <BR /> ABC Insurance Co Page 1<BR /> XXx UUUU<BR /> <BR /> Agent id : 12345<BR /> Department : P&amp;C<BR /> <BR /> Month Sales<BR /> -------------------------<BR /> 01 $3,000.00<BR /> 02 $3,000.00<BR /> 01 $3,000.00<BR /> <BR /> <BR /> Agent id : 12345<BR /> Department : P&amp;C<BR /> <BR /> Month Sales<BR /> -------------------------<BR /> 01 $3,000.00<BR /> 02 $3,000.00<BR /> 01 $3,000.00<BR /> <BR /> <BR /> Agent id : 12345<BR /> Department : P&amp;C<BR /> <BR /> Month Sales<BR /> -------------------------<BR /> 01 $3,000.00<BR /> 02 $3,000.00<BR /> 01 $3,000.00<BR /> <BR /> ABC Insurance Co Page 2<BR /> XXx UUUU<BR /> <BR /> Agent id : 12345<BR /> Department : P&amp;C<BR /> <BR /> Month Sales<BR /> -------------------------<BR /> 01 $3,000.00<BR /> 02 $3,000.00<BR /> 01 $3,000.00<BR /> <BR /> <BR /> Agent id : 12345<BR /> Department : P&amp;C<BR /> <BR /> Month Sales<BR /> -------------------------<BR /> 01 $3,000.00<BR /> 02 $3,000.00<BR /> 01 $3,000.00<BR /> <BR /> <BR /> Agent id : 12345<BR /> Department : P&amp;C<BR /> <BR /> Month Sales<BR /> -------------------------<BR /> 01 $3,000.00<BR /> 02 $3,000.00<BR /> 01 $3,000.00 Tue, 10 Jun 2008 16:31:49 GMT deleted_user 2008-06-10T16:31:49Z https://communities.sas.com/t5/SAS-Procedures/Doubt-in-Using-REPORT-Procedure/m-p/24499#M5537 Hi All,<BR /> <BR /> I am having problem with my current coding.<BR /> <BR /> I have a file with Department Id, Agent Id Month and Sales info. There will be 2 - 4 occurence for a particular agent. I have to create a report for every agent with Agent Id and Department Id dipslayed on the top and Month and Sales Info as detailed lines. I am able to do one agent per page I am to put 3 agents per page but I couldnt. Any Help will be appreciated...<BR /> <BR /> The Report should look like<BR /> <BR /> ABC Insurance Co Page 1<BR /> XXx UUUU<BR /> <BR /> Agent id : 12345<BR /> Department : P&amp;C<BR /> <BR /> Month Sales<BR /> -------------------------<BR /> 01 $3,000.00<BR /> 02 $3,000.00<BR /> 01 $3,000.00<BR /> <BR /> <BR /> Agent id : 12345<BR /> Department : P&amp;C<BR /> <BR /> Month Sales<BR /> -------------------------<BR /> 01 $3,000.00<BR /> 02 $3,000.00<BR /> 01 $3,000.00<BR /> <BR /> <BR /> Agent id : 12345<BR /> Department : P&amp;C<BR /> <BR /> Month Sales<BR /> -------------------------<BR /> 01 $3,000.00<BR /> 02 $3,000.00<BR /> 01 $3,000.00<BR /> <BR /> ABC Insurance Co Page 2<BR /> XXx UUUU<BR /> <BR /> Agent id : 12345<BR /> Department : P&amp;C<BR /> <BR /> Month Sales<BR /> -------------------------<BR /> 01 $3,000.00<BR /> 02 $3,000.00<BR /> 01 $3,000.00<BR /> <BR /> <BR /> Agent id : 12345<BR /> Department : P&amp;C<BR /> <BR /> Month Sales<BR /> -------------------------<BR /> 01 $3,000.00<BR /> 02 $3,000.00<BR /> 01 $3,000.00<BR /> <BR /> <BR /> Agent id : 12345<BR /> Department : P&amp;C<BR /> <BR /> Month Sales<BR /> -------------------------<BR /> 01 $3,000.00<BR /> 02 $3,000.00<BR /> 01 $3,000.00 Tue, 10 Jun 2008 16:31:49 GMT https://communities.sas.com/t5/SAS-Procedures/Doubt-in-Using-REPORT-Procedure/m-p/24499#M5537 deleted_user 2008-06-10T16:31:49Z