Date / Time
and
Mathematical Expressions
STAT 342 – Fall 2020 Tutorial – 6
Transaction Dataset
Transaction Data: Consists of 6 variables in text file
• Customer Number
• Date of transaction (2020.01.01 to 2020.10.15)
• Time of transaction (7.00 am to 11.00 pm)
• Section at which the transaction occurred • Bakery,Produce,Office,Toys
• Quantity bought at each section
• Unit price spent at each section (in $)
Answer following questions.
1. Read the data set into SAS environment using appropriate input style(s).
2. Compute a new variable total amount (unit price x quantity)
3. Compute mean amount of products bought by a customer
4. Compute the amount of dollars spent by a customer
5. Compute the mean amount of products bought by a customer from each of the 4 sections
6. Compute the mean amount of dollars spent a customer in each of the 4 sections
Answer following questions.
7. Find the number of customers visited the store during weekdays and weekends
8. Find the number of customer visited the store between 7am-12noon, 12noon-6pm and 6pm-11pm.
9. Find the mean amount of dollars spent by a customer during weekdays and weekends
10. Find the mean amount of dollars spent by a customer from 7am-12noon, 12noon- 6pm and 6pm-11pm.
11. Let’s assume during the month of December the mean amount of dollars spent by a customer at Toy section will be squared the mean amount found above. What will be the mean amount of dollars spent in December by a customer at Toy section?