Fluorite | Level 6

## Frequency of a frequency

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

1 ACCEPTED SOLUTION

Accepted Solutions
Opal | Level 21

## Re: Frequency of a frequency

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.

4 REPLIES 4
Opal | Level 21

## Re: Frequency of a frequency

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.

Obsidian | Level 7

## Re: Frequency of a frequency

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
Fluorite | Level 6

## Re: Frequency of a frequency

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

Fluorite | Level 6

## Re: Frequency of a frequency

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

Discussion stats
• 4 replies
• 972 views
• 2 likes
• 3 in conversation