Frequency count

[Sandhya]

Hi

I've a dataset with 4 variables.  Example of the Table is

ID	CODE	MOD	AMOUNT
1	10		100
1	10	20	110
1	10	AA	120
1	10	22	105
1	10	BB	130
2	10	20	103
2	10	22	109
2	10	BB	115

I wanted to consolidate it like

MOD	NONE	20	AA	22	BB
NONE	1(100)	1(210)	1(220)
20	1(210)	1(110)	1(230)
AA
22					2(459)
BB

It's the total number of id's in each combination and the total amount incurred by it.

Please help in deriving this solution.

Thanks,

Sandy.

[PGStats]

Could you explain further? The example doesn't seem complete? The combination 20-22 exists in both IDs and there is no total. 20-20 is not a combination in either ID.

PG