topic Re: Frequency of a frequency in SAS Visual Analytics

Frequency of a frequency

VicBrookes — Tue, 10 May 2016 23:09:32 GMT

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

Re: Frequency of a frequency

Astounding — Wed, 11 May 2016 02:11:47 GMT

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.

Re: Frequency of a frequency

maverickkub — Wed, 11 May 2016 09:35:49 GMT

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

Re: Frequency of a frequency

VicBrookes — Thu, 12 May 2016 05:25:15 GMT

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

Re: Frequency of a frequency

VicBrookes — Wed, 18 May 2016 22:25:55 GMT

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