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

    Posted on May 6, 2012 by in SAS, SAS Tutorials

    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)
    Be Sociable, Share!

    Written by

    View all articles by

    Email : [email protected]

    Leave a Reply