May 22, 2010

SAS Project 3: Retailing Industry....SAS Technical Problem to solve....DIY

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
CustomerIDtransactiondateamountcategory
980123410/01/1998123.98toys
980223412/10/199780.34books
980223412/10/1997100.00apparel
980555608/01/199622.90toys
980555609/10/199625.50apparel
980555610/11/199618.90books
980113411/11/199912.11toys
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)

1 comment:

  1. Hi..
    I am not able to download the sample data files from any of the mini projects that have been listed. Can you please look into the issue. Getting HTTP503 error.

    Thanks in advance!

    ReplyDelete

Note: Only a member of this blog may post a comment.