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
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.
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.
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
Thank you I will try and work through your recommendation. May take some time as I'm new to the system.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.