Frequency count

Sandhya — Mon, 25 Jun 2012 18:58:55 GMT

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

Re: Frequency count

PGStats — Mon, 25 Jun 2012 19:43:12 GMT

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.

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

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

topic Frequency count in SAS Procedures

Frequency count

Re: Frequency count

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