Help using Base SAS procedures

Frequency count

Reply
Contributor
Posts: 57

Frequency count

Hi

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

IDCODEMOD
AMOUNT
110100
11020110
110AA120
11022105
110BB130
21020103
21022109
210BB115

I wanted to consolidate it like

MOD
NONE20AA22
BB
NONE1(100)1(210)1(220)
201(210)1(110)1(230)
AA
222(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.

Respected Advisor
Posts: 4,919

Re: Frequency count

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

PG
Ask a Question
Discussion stats
  • 1 reply
  • 152 views
  • 0 likes
  • 2 in conversation