https://communities.sas.com/t5/SAS-Visual-Analytics/Question-for-Data-Analyst/m-p/692612#M14337 <P>I would like to ask few questions. I have a set of data set and how do I find this using excel.&nbsp;</P><P>1. How long is the second purchase from the first?<BR />2. How often do customers return?<BR />3. What’s the average time between purchases?<BR />4. Suggested metrics to track based on the Part 1 Analysis</P><P>Please give me an idea. Thank you</P> Mon, 19 Oct 2020 16:17:06 GMT 96asiah 2020-10-19T16:17:06Z https://communities.sas.com/t5/SAS-Visual-Analytics/Question-for-Data-Analyst/m-p/692612#M14337 <P>I would like to ask few questions. I have a set of data set and how do I find this using excel.&nbsp;</P><P>1. How long is the second purchase from the first?<BR />2. How often do customers return?<BR />3. What’s the average time between purchases?<BR />4. Suggested metrics to track based on the Part 1 Analysis</P><P>Please give me an idea. Thank you</P> Mon, 19 Oct 2020 16:17:06 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Question-for-Data-Analyst/m-p/692612#M14337 96asiah 2020-10-19T16:17:06Z https://communities.sas.com/t5/SAS-Visual-Analytics/Question-for-Data-Analyst/m-p/692614#M14338 Are you trying to do your work in Excel or SAS?<BR /><BR />A CSV file is a "comma separated value" file, stored in a text format and is not an Excel file. Mon, 19 Oct 2020 16:18:25 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Question-for-Data-Analyst/m-p/692614#M14338 Reeza 2020-10-19T16:18:25Z https://communities.sas.com/t5/SAS-Visual-Analytics/Question-for-Data-Analyst/m-p/692615#M14339 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/348336">@96asiah</a>&nbsp;wrote:<BR /> <P>I have a set of data set and how do I find this using excel.&nbsp;</P> <HR /></BLOCKQUOTE> <P>Did you mean to say "How do I find this using SAS"?</P> Mon, 19 Oct 2020 16:18:38 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Question-for-Data-Analyst/m-p/692615#M14339 PaigeMiller 2020-10-19T16:18:38Z https://communities.sas.com/t5/SAS-Visual-Analytics/Question-for-Data-Analyst/m-p/692617#M14340 Hi,<BR />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<BR /><BR /> Mon, 19 Oct 2020 16:23:06 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Question-for-Data-Analyst/m-p/692617#M14340 96asiah 2020-10-19T16:23:06Z https://communities.sas.com/t5/SAS-Visual-Analytics/Question-for-Data-Analyst/m-p/692618#M14341 Hi,<BR />The data is in excel. I already transfer it to sas and planning to do the analysis in SAS<BR /> Mon, 19 Oct 2020 16:24:05 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Question-for-Data-Analyst/m-p/692618#M14341 96asiah 2020-10-19T16:24:05Z