Hi All,
I have already posted this in "SAS Proc" forum then I thought this would be better place to post my question. Appreciate all your help....
I am having problem with my current coding.
I have a file with Department Id, Agent Id Month and Sales info. There will be 2 - 4 occurrence for a particular agent. I have to create a report for every agent with Agent Id and Department Id displayed 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 couldn't. Any Help will be appreciated...
The Report should look like
ABC Insurance Co Page 1
XXx UUUU
Agent id : 12345
Department : P&C
Month Sales
-------------------------
01 $3,000.00
02 $3,000.00
01 $3,000.00
Agent id : 12345
Department : P&C
Month Sales
-------------------------
01 $3,000.00
02 $3,000.00
01 $3,000.00
Agent id : 12345
Department : P&C
Month Sales
-------------------------
01 $3,000.00
02 $3,000.00
01 $3,000.00
ABC Insurance Co Page 2
XXx UUUU
Agent id : 12345
Department : P&C
Month Sales
-------------------------
01 $3,000.00
02 $3,000.00
01 $3,000.00
Agent id : 12345
Department : P&C
Month Sales
-------------------------
01 $3,000.00
02 $3,000.00
01 $3,000.00
Agent id : 12345
Department : P&C
Month Sales
-------------------------
01 $3,000.00
02 $3,000.00
01 $3,000.00