BookmarkSubscribeRSS Feed
Mozammel
Calcite | Level 5

Summary:

-Every month based on the need of  our different department we ask different vendors to provide us contractors to meet our work load.

-The contractors that the vendors provide start entering FTE hours as soon as they start working.

- Based on the data we will need  a model that will predict the future FTE hours for a particular state,  a particular city, a particular job family, a particular position title.

 

Example:

  • We have monthly data from 2014 to 2015 for the total FTE hours entered
  • The column headers are as follows:

 

 

 

 

 

 

 

Year

Month

State

City

Job Family

Job Title

Total Hrs

2014

April

AL

Selma

PM

PM3

10000

2015

Feb

AR

Hot Springs

Analyst

Analyst2

2300

          

 

 

So based on the above data we will be able to predict for

2016 September

2016 October

2016 November

For each state and for each of the city and for each of the job family and for each of the job title

Approximately how much hrs are needed.

 

1 REPLY 1
mitrov
SAS Employee

I would suggest that you look at Forecast Server. It is specifically designed for last scale automatic forecasting of time series organized in a hierarchical fashion. This video gives a brief overview of the feture of Forecast Server by guiding through a typical project creation.

https://www.youtube.com/watch?v=yZWY8cCzOKU

 

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

Multiple Linear Regression in SAS

Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 933 views
  • 1 like
  • 2 in conversation