Frequency of a frequency

Solved
Occasional Contributor
Posts: 7

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

Accepted Solutions
Solution
‎05-18-2016 06:21 PM
Super User
Posts: 6,935

Re: Frequency of a frequency

Posted in reply to VicBrookes

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.

All Replies
Solution
‎05-18-2016 06:21 PM
Super User
Posts: 6,935

Re: Frequency of a frequency

Posted in reply to VicBrookes

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.

Contributor
Posts: 21

Re: Frequency of a frequency

Posted in reply to Astounding
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
Occasional Contributor
Posts: 7

Re: Frequency of a frequency

Posted in reply to maverickkub

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

Occasional Contributor
Posts: 7

Re: Frequency of a frequency

Posted in reply to Astounding

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

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

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