Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Frequency of a frequency

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 7
Accepted Solution

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
Respected Advisor
Posts: 4,648

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.

View solution in original post


All Replies
Solution
‎05-18-2016 06:21 PM
Respected Advisor
Posts: 4,648

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.

Contributor
Posts: 21

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
Occasional Contributor
Posts: 7

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

Occasional Contributor
Posts: 7

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.

Post a Question
Discussion Stats
  • 4 replies
  • 275 views
  • 2 likes
  • 3 in conversation