I have a dataset of 1.2 million rows, each representing an e-mail with email_id as primary key. A customer might have received several e-mails, and the row for each e-mail contains the customer_id it was sent to. I want to make a bar chart representing how many customers received 1, 2, 3, 4 etc. e-mails from us. Ideally, it should be done dynamically within SAS VA, so that the reader can use a slider to decide the period he/she wants to look into.
In python, I would count the number of received e-mails per customer_id, append these numbers as a column to the dataset and run .value_counts() on the appended column. How can this be done in the drag-and-drop environment of SAS VA?
We are getting closer! To continue on your cars example, I'd like to do a bar chart representing how many 'make' were bought 7 times, 8 times, 9 times etc. In your screenshot, all makes have different buying frequencies but say if Ferrari, Skoda and Tesla were bought 7 times like Acura, the bar representing "bought 7 times" should have a height of 4. Any suggestions? : ))
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.