SAS On Demand

As an analytics developer, you need to know how to produce different types of output such as minimum, maximum and mean sales. You will also use ODS interface to display the output in graphical format.

Using the data from the Train.csv file, complete the activities below:

Step 1: Include PROC UNIVARIATE in your SAS script and calculates mean sales over the holiday per store/department for each month.

Step 2: Produce the standard deviation over the holiday per store/department for each month.

Step 3: Produce the min and max range over the holiday per store/department for each month.

Step 4: Use ODS interface and generate all the output in graphical format.

(Example of train.csv data file)

ID	Store	Dept	Date	Weekly_Sales	IsHoliday
1	1	1	2/5/2010	24924.5	FALSE
2	1	1	2/12/2010	46039.49	TRUE
3	1	1	2/19/2010	41595.55	FALSE
4	1	1	2/26/2010	19403.54	FALSE
5	1	1	3/5/2010	21827.9	FALSE