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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.