Help using Base SAS procedures

Doubt in Using REPORT Procedure

Reply
N/A
Posts: 0

Doubt in Using REPORT Procedure

Hi All,

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 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...

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
Ask a Question
Discussion stats
  • 0 replies
  • 87 views
  • 0 likes
  • 1 in conversation