Frequency of a frequency

[VicBrookes]

 I'm new to sas and have achieved building a report based on my data pulled through from sas enterprise guide. I would love to finish my report with a clear understanding of customer calls to action numbers.

each customer has a unique Id and they may have phoned us once or more to perform a task. 

I can see how many times there record appears within the data but I would like now to see how many customers have called us once, twice, three times ...

example of of what I would like to create is

calls made by customer   How many customers

                     1                                  10

                     2                                   4

                     3                                    27

average calls to resolve = x

is there a agrgated measure I could build? 

Any help would be really appreciated 

vic

[Astounding · Accepted solution]

Using base SAS, this could be a two-step job:

proc freq data=have;

tables customer / noprint out=counts;

run;

proc freq data=counts;

tables count / nocum nopercent;

run;

It may take a little bit of working through the pieces to realize that this is the report you are looking for ... minus the fancy labeling.

[maverickkub]

Hi. I cab simple if you are trying to achieve it through Visual Analystics.All you need to do is create a list where the frequency counts are listed and selction can be made which can show you the customers according to a particular freq of calls.e.g. List all customers where calls>10 Cust Freq of calls 1-sim 21 2-Cam 23 3-relly 19

[VicBrookes]

I agree that you have also provide me with a great solution but because of my version of va I can not use it at this time. 

My currect version does not let me cross 2 data sources. I am begging for the upgrade as I think it will prove a great solution and anylise even more of our customer behaviour. 

Thank you

[VicBrookes]

Thank you I will try and work through your recommendation. May take some time as I'm new to the system.