[SASTechies] SAS Project 3: Retailing Industry....SAS Technical Problem to so...

[LearnSAS]

This SAS Screening Problem was asked at Gap Inc...

The following shows 6 sample records of a large SAS data set. 

The data set name is trans 

CustomerID                 transactiondate       amount      category

9801234                        10/01/1998               123.98        toys

9802234                         12/10/1997               80.34         books

9802234                         12/10/1997               100.00       apparel

9805556                         08/01/1996               22.90         toys

9805556                         09/10/1996               25.50         apparel

9805556                         10/11/1996               18.90         books

9801134                          11/11/1999              12.11         toys

Write some SAS code that that will answer the questions below using the SAS file above. 

These questions get at your understanding of different levels of summarization and in more general terms, how you approach programming problems.  There are many ‘right’ answers.

You do not have to use the original dataset as input to each question, you may want to summarize at one step and use that summarization in later steps. 

1. Total and average amount spent by category
2. Which category has the highest average purchase
3. What is the average number of categories that customers purchase
4. What is the average and total amount by customer
5. What is the average number of days between purchases (as of today)      

 Check your solution with my Solution..under Projects | Mini Projects 2 Try...

--
Posted By LearnSAS to SASTechies at 5/22/2010 08:11:00 PM