SAS Visual Analytics

Dashboards, reports, BI and analytics - all from a single interface.
BookmarkSubscribeRSS Feed
96asiah
Calcite | Level 5

I would like to ask few questions. I have a set of data set and how do I find this using excel. 

1. How long is the second purchase from the first?
2. How often do customers return?
3. What’s the average time between purchases?
4. Suggested metrics to track based on the Part 1 Analysis

Please give me an idea. Thank you

4 REPLIES 4
Reeza
Super User
Are you trying to do your work in Excel or SAS?

A CSV file is a "comma separated value" file, stored in a text format and is not an Excel file.
96asiah
Calcite | Level 5
Hi,
The data is in excel. I already transfer it to sas and planning to do the analysis in SAS
PaigeMiller
Diamond | Level 26

@96asiah wrote:

I have a set of data set and how do I find this using excel. 


Did you mean to say "How do I find this using SAS"?

--
Paige Miller
96asiah
Calcite | Level 5
Hi,
Yes. I have a set of the data as you can see in the attachment. I want to make it visualise and find the answer

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 4 replies
  • 709 views
  • 0 likes
  • 3 in conversation