Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Open SAS Studio create a new program and run the following code / * the following 3 lines of code assign all the CAS libraries

Open SAS Studio create a new program and run the following code
/* the following 3 lines of code assign all the CAS libraries and lists the into the log window*/
cas mySession sessopts=(caslib=casuser timeout=1800 locale="en_US");
caslib _all_ list;
caslib _all_ assign;
locate the PRICEDATA data set from the following library SASHELP.
Run a proc contents to explore the data set.
Complete (Questions 1-6) using proc contents and proc freq or proc sql.
Promote the PRICEDATA data set into CASUSER CAS library. You can run the following code;
/* you can name this whatever you wan but library must be casuser*/
/* we need to promote the pricedata into CAS to access by Visual Forecasting*/
data casuser.somedatasetname (promote=yes);
set sashelp.pricedata;
run;
Verify that the data set you created above is in the CASUSER library
Open Viya Model Studio and create a forecast project using the autoforecast
Use the following procedures; Variable for Date-time, Time Interval is month, Multiplier =1 and shift =1.
Create a seasonal model and a nave model by right clicking data node and create forecast.
Choose WMAPE as a metric to declare a model champion
Create an override and submit
How many observations are there in the data set (1 mark)?
How many Variables are in the data set (1 mark)?
What is the unit of time for this forecast (2 marks)?
How many unique time periods are there (2 marks)?
What is the earliest time period (2 marks)?
What month did the largest Sales volume occur (2 marks)?
What is the predicted sales value of; REGION=1, LINE=1, and PRODUCT=2 for May 03(2 marks)?
What model was most prevalent in the Auto Forecasting (Marks=2)?
What was the upper confidence interval value for Jun03 for Line 5 Product 16(2 marks)?
What model was the champion model between seasonal/autoforecasting/nave (2 marks)?
Display the predicted values series with the following override: the sales in March 03 were going to be $10,000(2 marks)?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essential SQLAlchemy Mapping Python To Databases

Authors: Myers, Jason Myers

2nd Edition

1491916567, 9781491916568

Students also viewed these Databases questions