Help using Base SAS procedures

HELP!! Proc Forecast error id variable not valid input

Accepted Solution Solved
Reply
Senior User
Posts: 1
Accepted Solution

HELP!! Proc Forecast error id variable not valid input

I have been working on this problem for the last few hours and I can not figure out how to fix this error I get.

 

SAS Code:

data B8;
input Month $ Rate;
datalines;
Jan63 6.8
Feb63 6.8
Mar63 6.2
Apr63 5.6
May63 5.4
Jun63 6.0
Jul63 5.4
Aug63 4.9
Sep63 4.3
Oct63 4.4
Nov63 4.9
Dec63 5.1
Jan64 6.2
Feb64 6.1
Mar64 5.7
Apr64 5.1
May64 4.7
Jun64 5.7
Jul64 4.7
Aug64 4.5
Sep64 4.0
Oct64 4.0
Nov64 4.0
Dec64 4.3
Jan65 5.3
Feb65 5.5
Mar65 4.9
Apr65 4.5
May65 4.1
Jun65 5.1
Jul65 4.2
Aug65 3.9
Sep65 3.4
Oct65 3.2
Nov65 3.3
Dec65 3.4
Jan66 4.1
Feb66 4.0
Mar66 3.8
Apr66 3.5
May66 3.4
Jun66 4.3
Jul66 3.7
Aug66 3.2
Sep66 2.9
Oct66 2.8
Nov66 3.0
Dec66 3.1
Jan67 3.8
Feb67 3.6
Mar67 3.5
Apr67 3.2
May67 3.0
Jun67 4.3
Jul67 3.7
Aug67 3.4
Sep67 3.1
Oct67 3.1
Nov67 3.0
Dec67 3.0
Jan68 3.7
Feb68 3.8
Mar68 3.4
Apr68 2.9
May68 2.7
Jun68 4.2
Jul68 3.7
Aug68 3.1
Sep68 2.7
Oct68 2.7
Nov68 2.6
Dec68 2.5
Jan69 3.3
Feb69 3.3
Mar69 3.1
Apr69 2.9
May69 2.7
Jun69 4.0
Jul69 3.6
Aug69 3.1
Sep69 3.0
Oct69 2.8
Nov69 2.7
Dec69 2.8
Jan70 3.8
Feb70 4.3
Mar70 4.2
Apr70 4.1
May70 4.2
Jun70 5.5
Jul70 5.1
Aug70 4.7
Sep70 4.5
Oct70 4.5
Nov70 4.9
Dec70 5.2
Jan71 6.1
Feb71 6.2
Mar71 5.9
Apr71 5.4
May71 5.2
Jun71 6.4
Jul71 6.0
Aug71 5.6
Sep71 5.1
Oct71 4.8
Nov71 5.1
Dec71 5.2
Jan72 6.1
Feb72 6.0
Mar72 5.8
Apr72 5.2
May72 5.1
Jun72 6.0
Jul72 5.7
Aug72 5.2
Sep72 4.6
Oct72 4.5
Nov72 4.2
Dec72 4.2
Jan73 5.1
Feb73 5.2
Mar73 4.9
Apr73 4.4
May73 4.2
Jun73 5.1
Jul73 4.7
Aug73 4.3
Sep73 3.9
Oct73 3.6
Nov73 4.0
Dec73 4.1
Jan74 5.2
Feb74 5.3
Mar74 5.0
Apr74 4.6
May74 4.5
Jun74 5.6
Jul74 5.4
Aug74 4.9
Sep74 4.9
Oct74 5.0
Nov74 5.7
Dec74 6.3
Jan75 8.7
Feb75 9.0
Mar75 9.1
Apr75 8.7
May75 8.6
Jun75 9.3
Jul75 8.7
Aug75 7.9
Sep75 7.6
Oct75 7.4
Nov75 7.5
Dec75 7.5
Jan76 8.6
Feb76 8.4
Mar76 8.0
Apr76 7.2
May76 6.8
Jun76 8.1
Jul76 7.6
Aug76 7.3
Sep76 6.9
Oct76 6.7
Nov76 7.0
Dec76 7.2
Jan77 7.9
Feb77 8.2
Mar77 7.6
Apr77 6.7
May77 6.4
Jun77 7.3
Jul77 6.9
Aug77 6.6
Sep77 6.0
Oct77 5.9
Nov77 5.9
Dec77 5.7
Jan78 6.7
Feb78 6.6
Mar78 6.2
Apr78 5.5
May78 5.5
Jun78 6.1
Jul78 6.1
Aug78 5.5
Sep78 5.1
Oct78 4.8
Nov78 5.0
Dec78 5.2
Jan79 5.9
Feb79 6.1
Mar79 5.7
Apr79 5.3
May79 5.0
Jun79 5.9
Jul79 5.7
Aug79 5.5
Sep79 5.1
Oct79 5.1
Nov79 5.2
Dec79 5.3
Jan80 6.5
Feb80 6.5
Mar80 6.4
Apr80 6.6
May80 7.2
Jun80 8.0
Jul80 8.1
Aug80 7.6
Sep80 6.9
Oct80 6.8
Nov80 7.0
Dec80 7.0
Jan81 8.0
Feb81 8.0
Mar81 7.6
Apr81 7.0
May81 7.2
Jun81 7.8
Jul81 7.4
Aug81 7.0
Sep81 6.9
Oct81 7.3
Nov81 7.8
Dec81 8.5
Jan82 9.5
Feb82 9.6
Mar82 9.7
Apr82 9.4
May82 9.5
Jun82 10.3
Jul82 10.1
Aug82 9.8
Sep82 9.7
Oct82 10.1
Nov82 10.6
Dec82 11.0
Jan83 11.9
Feb83 11.9
Mar83 11.4
Apr83 10.6
May83 10.3
Jun83 10.6
Jul83 9.8
Aug83 9.4
Sep83 8.8
Oct83 8.4
Nov83 8.2
Dec83 8.2
Jan84 8.9
Feb84 8.5
Mar84 8.3
Apr84 7.8
May84 7.4
Jun84 7.4
Jul84 7.6
Aug84 7.2
Sep84 6.8
Oct84 6.9
Nov84 6.8
Dec84 7.1
Jan85 8.0
Feb85 7.9
Mar85 7.5
Apr85 7.1
May85 7.0
Jun85 7.5
Jul85 7.4
Aug85 6.8
Sep85 6.6
Oct85 6.5
Nov85 6.6
Dec85 6.6
Jan86 7.3
Feb86 7.8
Mar86 7.5
Apr86 7.0
May86 7.1
Jun86 7.3
Jul86 7.0
Aug86 6.4
Sep86 6.5
Oct86 6.3
Nov86 6.4
Dec86 6.3
Jan87 7.2
Feb87 7.1
Mar87 6.7
Apr87 6.1
May87 6.1
Jun87 6.4
Jul87 6.1
Aug87 5.6
Sep87 5.3
Oct87 5.3
Nov87 5.4
Dec87 5.3
Jan88 6.1
Feb88 6.1
Mar88 5.8
Apr88 5.2
May88 5.4
Jun88 5.4
Jul88 5.4
Aug88 5.2
Sep88 4.8
Oct88 4.7
Nov88 4.9
Dec88 5.0
Jan89 5.7
Feb89 5.5
Mar89 5.2
Apr89 5.0
May89 5.0
Jun89 5.3
Jul89 5.3
Aug89 4.9
Sep89 4.7
Oct89 4.6
Nov89 4.9
Dec89 4.9
Jan90 5.8
Feb90 5.6
Mar90 5.4
Apr90 5.2
May90 5.1
Jun90 5.3
Jul90 5.4
Aug90 5.2
Sep90 5.3
Oct90 5.2
Nov90 5.7
Dec90 6.0
Jan91 7.0
Feb91 7.4
Mar91 7.1
Apr91 6.6
May91 6.7
Jun91 7.0
Jul91 6.9
Aug91 6.5
Sep91 6.3
Oct91 6.3
Nov91 6.6
Dec91 7.0
Jan92 8.1
Feb92 8.3
Mar92 7.9
Apr92 7.4
May92 7.4
Jun92 8.0
Jul92 7.8
Aug92 7.3
Sep92 7.0
Oct92 6.7
Nov92 7.0
Dec92 7.1
Jan93 7.9
Feb93 7.9
Mar93 7.5
Apr93 6.9
May93 6.9
Jun93 7.2
Jul93 7.1
Aug93 6.5
Sep93 6.2
Oct93 6.1
Nov93 6.0
Dec93 6.2
Jan94 7.5
Feb94 7.4
Mar94 7.0
Apr94 6.3
May94 5.9
Jun94 6.3
Jul94 6.4
Aug94 5.8
Sep94 5.5
Oct94 5.3
Nov94 5.2
Dec94 5.0
Jan95 6.1
Feb95 5.8
Mar95 5.7
Apr95 5.5
May95 5.4
Jun95 5.7
Jul95 5.8
Aug95 5.5
Sep95 5.2
Oct95 5.0
Nov95 5.1
Dec95 5.2
Jan96 6.2
Feb96 5.9
Mar96 5.8
Apr96 5.3
May96 5.3
Jun96 5.4
Jul96 5.6
Aug96 4.9
Sep96 4.8
Oct96 4.7
Nov96 4.9
Dec96 4.9
Jan97 5.8
Feb97 5.5
Mar97 5.4
Apr97 4.7
May97 4.7
Jun97 5.1
Jul97 5.0
Aug97 4.6
Sep97 4.5
Oct97 4.2
Nov97 4.1
Dec97 4.3
Jan98 5.0
Feb98 4.8
Mar98 4.8
Apr98 4.0
May98 4.2
Jun98 4.6
Jul98 4.6
Aug98 4.3
Sep98 4.1
Oct98 3.9
Nov98 3.8
Dec98 3.9
Jan99 4.6
Feb99 4.6
Mar99 4.3
Apr99 4.0
May99 3.9
Jun99 4.3
Jul99 4.4
Aug99 4.1
Sep99 3.8
Oct99 3.7
Nov99 3.6
Dec99 3.7
Jan00 4.3
Feb00 4.2
Mar00 4.1
Apr00 3.5
May00 3.7
Jun00 4.0
Jul00 4.0
Aug00 3.9
Sep00 3.5
Oct00 3.5
Nov00 3.5
Dec00 3.6
Jan01 4.5
Feb01 4.4
Mar01 4.4
Apr01 4.0
May01 4.1
Jun01 4.6
Jul01 4.6
Aug01 4.7
Sep01 4.7
Oct01 4.9
Nov01 5.2
Dec01 5.5
Jan02 6.5
Feb02 6.3
Mar02 6.2
Apr02 5.9
May02 5.7
Jun02 6.2
Jul02 6.0
Aug02 5.6
Sep02 5.3
Oct02 5.4
Nov02 5.7
Dec02 5.9
Jan03 6.6
Feb03 6.5
Mar03 6.3
Apr03 6.0
May03 6.0
Jun03 6.6
Jul03 6.4
Aug03 6.1
Sep03 5.7
Oct03 5.6
Nov03 5.7
Dec03 5.6
Jan04 6.3
Feb04 6.1
Mar04 6.2
Apr04 5.4
May04 5.5
Jun04 5.8
Jul04 5.8
Aug04 5.3
Sep04 5.1
Oct04 5.0
Nov04 5.1
Dec04 5.2
;

data B8;
set B8;
format month monyy.;
run;

proc print data=B8;
run;


proc contents data=B8;
run;
proc sgplot data=B8;
title 'Time Series Plot of Table B8';
series x=Month y=Rate;
yaxis label = 'Rate (Percent)';
run;

title 'Question 23b';
proc forecast data=B8 method=expo weight=0.2 interval=month out=smooth outall;
id month;
var Rate;
run;

 

title 'Question 23b';

10880 proc forecast data=B8 method=expo weight=0.2 interval=month out=smooth outall;

10881 id month;

ERROR: Variable Month in list does not match type prescribed for this list.

10882 var Rate;

10883 run;


Accepted Solutions
Solution
‎03-04-2018 09:01 AM
Super User
Posts: 23,685

Re: HELP!! Proc Forecast error id variable not valid input

[ Edited ]

input Month $ rate;

 

You've read month in as a character variable, it needs to be a numeric date variable instead.

 

data B8;
informat month monyy5.;
format month monyy5.;
input Month  Rate;

;

 

 

Spoiler

kjt1009 wrote:

I have been working on this problem for the last few hours and I can not figure out how to fix this error I get.

 

SAS Code:

data B8;
input Month $ Rate;
datalines;
Jan63 6.8
Feb63 6.8
Mar63 6.2
Apr63 5.6
May63 5.4
Jun63 6.0
Jul63 5.4
Aug63 4.9
Sep63 4.3
Oct63 4.4
Nov63 4.9
Dec63 5.1
Jan64 6.2
Feb64 6.1
Mar64 5.7
Apr64 5.1
May64 4.7
Jun64 5.7
Jul64 4.7
Aug64 4.5
Sep64 4.0
Oct64 4.0
Nov64 4.0
Dec64 4.3
Jan65 5.3
Feb65 5.5
Mar65 4.9
Apr65 4.5
May65 4.1
Jun65 5.1
Jul65 4.2
Aug65 3.9
Sep65 3.4
Oct65 3.2
Nov65 3.3
Dec65 3.4
Jan66 4.1
Feb66 4.0
Mar66 3.8
Apr66 3.5
May66 3.4
Jun66 4.3
Jul66 3.7
Aug66 3.2
Sep66 2.9
Oct66 2.8
Nov66 3.0
Dec66 3.1
Jan67 3.8
Feb67 3.6
Mar67 3.5
Apr67 3.2
May67 3.0
Jun67 4.3
Jul67 3.7
Aug67 3.4
Sep67 3.1
Oct67 3.1
Nov67 3.0
Dec67 3.0
Jan68 3.7
Feb68 3.8
Mar68 3.4
Apr68 2.9
May68 2.7
Jun68 4.2
Jul68 3.7
Aug68 3.1
Sep68 2.7
Oct68 2.7
Nov68 2.6
Dec68 2.5
Jan69 3.3
Feb69 3.3
Mar69 3.1
Apr69 2.9
May69 2.7
Jun69 4.0
Jul69 3.6
Aug69 3.1
Sep69 3.0
Oct69 2.8
Nov69 2.7
Dec69 2.8
Jan70 3.8
Feb70 4.3
Mar70 4.2
Apr70 4.1
May70 4.2
Jun70 5.5
Jul70 5.1
Aug70 4.7
Sep70 4.5
Oct70 4.5
Nov70 4.9
Dec70 5.2
Jan71 6.1
Feb71 6.2
Mar71 5.9
Apr71 5.4
May71 5.2
Jun71 6.4
Jul71 6.0
Aug71 5.6
Sep71 5.1
Oct71 4.8
Nov71 5.1
Dec71 5.2
Jan72 6.1
Feb72 6.0
Mar72 5.8
Apr72 5.2
May72 5.1
Jun72 6.0
Jul72 5.7
Aug72 5.2
Sep72 4.6
Oct72 4.5
Nov72 4.2
Dec72 4.2
Jan73 5.1
Feb73 5.2
Mar73 4.9
Apr73 4.4
May73 4.2
Jun73 5.1
Jul73 4.7
Aug73 4.3
Sep73 3.9
Oct73 3.6
Nov73 4.0
Dec73 4.1
Jan74 5.2
Feb74 5.3
Mar74 5.0
Apr74 4.6
May74 4.5
Jun74 5.6
Jul74 5.4
Aug74 4.9
Sep74 4.9
Oct74 5.0
Nov74 5.7
Dec74 6.3
Jan75 8.7
Feb75 9.0
Mar75 9.1
Apr75 8.7
May75 8.6
Jun75 9.3
Jul75 8.7
Aug75 7.9
Sep75 7.6
Oct75 7.4
Nov75 7.5
Dec75 7.5
Jan76 8.6
Feb76 8.4
Mar76 8.0
Apr76 7.2
May76 6.8
Jun76 8.1
Jul76 7.6
Aug76 7.3
Sep76 6.9
Oct76 6.7
Nov76 7.0
Dec76 7.2
Jan77 7.9
Feb77 8.2
Mar77 7.6
Apr77 6.7
May77 6.4
Jun77 7.3
Jul77 6.9
Aug77 6.6
Sep77 6.0
Oct77 5.9
Nov77 5.9
Dec77 5.7
Jan78 6.7
Feb78 6.6
Mar78 6.2
Apr78 5.5
May78 5.5
Jun78 6.1
Jul78 6.1
Aug78 5.5
Sep78 5.1
Oct78 4.8
Nov78 5.0
Dec78 5.2
Jan79 5.9
Feb79 6.1
Mar79 5.7
Apr79 5.3
May79 5.0
Jun79 5.9
Jul79 5.7
Aug79 5.5
Sep79 5.1
Oct79 5.1
Nov79 5.2
Dec79 5.3
Jan80 6.5
Feb80 6.5
Mar80 6.4
Apr80 6.6
May80 7.2
Jun80 8.0
Jul80 8.1
Aug80 7.6
Sep80 6.9
Oct80 6.8
Nov80 7.0
Dec80 7.0
Jan81 8.0
Feb81 8.0
Mar81 7.6
Apr81 7.0
May81 7.2
Jun81 7.8
Jul81 7.4
Aug81 7.0
Sep81 6.9
Oct81 7.3
Nov81 7.8
Dec81 8.5
Jan82 9.5
Feb82 9.6
Mar82 9.7
Apr82 9.4
May82 9.5
Jun82 10.3
Jul82 10.1
Aug82 9.8
Sep82 9.7
Oct82 10.1
Nov82 10.6
Dec82 11.0
Jan83 11.9
Feb83 11.9
Mar83 11.4
Apr83 10.6
May83 10.3
Jun83 10.6
Jul83 9.8
Aug83 9.4
Sep83 8.8
Oct83 8.4
Nov83 8.2
Dec83 8.2
Jan84 8.9
Feb84 8.5
Mar84 8.3
Apr84 7.8
May84 7.4
Jun84 7.4
Jul84 7.6
Aug84 7.2
Sep84 6.8
Oct84 6.9
Nov84 6.8
Dec84 7.1
Jan85 8.0
Feb85 7.9
Mar85 7.5
Apr85 7.1
May85 7.0
Jun85 7.5
Jul85 7.4
Aug85 6.8
Sep85 6.6
Oct85 6.5
Nov85 6.6
Dec85 6.6
Jan86 7.3
Feb86 7.8
Mar86 7.5
Apr86 7.0
May86 7.1
Jun86 7.3
Jul86 7.0
Aug86 6.4
Sep86 6.5
Oct86 6.3
Nov86 6.4
Dec86 6.3
Jan87 7.2
Feb87 7.1
Mar87 6.7
Apr87 6.1
May87 6.1
Jun87 6.4
Jul87 6.1
Aug87 5.6
Sep87 5.3
Oct87 5.3
Nov87 5.4
Dec87 5.3
Jan88 6.1
Feb88 6.1
Mar88 5.8
Apr88 5.2
May88 5.4
Jun88 5.4
Jul88 5.4
Aug88 5.2
Sep88 4.8
Oct88 4.7
Nov88 4.9
Dec88 5.0
Jan89 5.7
Feb89 5.5
Mar89 5.2
Apr89 5.0
May89 5.0
Jun89 5.3
Jul89 5.3
Aug89 4.9
Sep89 4.7
Oct89 4.6
Nov89 4.9
Dec89 4.9
Jan90 5.8
Feb90 5.6
Mar90 5.4
Apr90 5.2
May90 5.1
Jun90 5.3
Jul90 5.4
Aug90 5.2
Sep90 5.3
Oct90 5.2
Nov90 5.7
Dec90 6.0
Jan91 7.0
Feb91 7.4
Mar91 7.1
Apr91 6.6
May91 6.7
Jun91 7.0
Jul91 6.9
Aug91 6.5
Sep91 6.3
Oct91 6.3
Nov91 6.6
Dec91 7.0
Jan92 8.1
Feb92 8.3
Mar92 7.9
Apr92 7.4
May92 7.4
Jun92 8.0
Jul92 7.8
Aug92 7.3
Sep92 7.0
Oct92 6.7
Nov92 7.0
Dec92 7.1
Jan93 7.9
Feb93 7.9
Mar93 7.5
Apr93 6.9
May93 6.9
Jun93 7.2
Jul93 7.1
Aug93 6.5
Sep93 6.2
Oct93 6.1
Nov93 6.0
Dec93 6.2
Jan94 7.5
Feb94 7.4
Mar94 7.0
Apr94 6.3
May94 5.9
Jun94 6.3
Jul94 6.4
Aug94 5.8
Sep94 5.5
Oct94 5.3
Nov94 5.2
Dec94 5.0
Jan95 6.1
Feb95 5.8
Mar95 5.7
Apr95 5.5
May95 5.4
Jun95 5.7
Jul95 5.8
Aug95 5.5
Sep95 5.2
Oct95 5.0
Nov95 5.1
Dec95 5.2
Jan96 6.2
Feb96 5.9
Mar96 5.8
Apr96 5.3
May96 5.3
Jun96 5.4
Jul96 5.6
Aug96 4.9
Sep96 4.8
Oct96 4.7
Nov96 4.9
Dec96 4.9
Jan97 5.8
Feb97 5.5
Mar97 5.4
Apr97 4.7
May97 4.7
Jun97 5.1
Jul97 5.0
Aug97 4.6
Sep97 4.5
Oct97 4.2
Nov97 4.1
Dec97 4.3
Jan98 5.0
Feb98 4.8
Mar98 4.8
Apr98 4.0
May98 4.2
Jun98 4.6
Jul98 4.6
Aug98 4.3
Sep98 4.1
Oct98 3.9
Nov98 3.8
Dec98 3.9
Jan99 4.6
Feb99 4.6
Mar99 4.3
Apr99 4.0
May99 3.9
Jun99 4.3
Jul99 4.4
Aug99 4.1
Sep99 3.8
Oct99 3.7
Nov99 3.6
Dec99 3.7
Jan00 4.3
Feb00 4.2
Mar00 4.1
Apr00 3.5
May00 3.7
Jun00 4.0
Jul00 4.0
Aug00 3.9
Sep00 3.5
Oct00 3.5
Nov00 3.5
Dec00 3.6
Jan01 4.5
Feb01 4.4
Mar01 4.4
Apr01 4.0
May01 4.1
Jun01 4.6
Jul01 4.6
Aug01 4.7
Sep01 4.7
Oct01 4.9
Nov01 5.2
Dec01 5.5
Jan02 6.5
Feb02 6.3
Mar02 6.2
Apr02 5.9
May02 5.7
Jun02 6.2
Jul02 6.0
Aug02 5.6
Sep02 5.3
Oct02 5.4
Nov02 5.7
Dec02 5.9
Jan03 6.6
Feb03 6.5
Mar03 6.3
Apr03 6.0
May03 6.0
Jun03 6.6
Jul03 6.4
Aug03 6.1
Sep03 5.7
Oct03 5.6
Nov03 5.7
Dec03 5.6
Jan04 6.3
Feb04 6.1
Mar04 6.2
Apr04 5.4
May04 5.5
Jun04 5.8
Jul04 5.8
Aug04 5.3
Sep04 5.1
Oct04 5.0
Nov04 5.1
Dec04 5.2
;

data B8;
set B8;
format month monyy.;
run;

proc print data=B8;
run;


proc contents data=B8;
run;
proc sgplot data=B8;
title 'Time Series Plot of Table B8';
series x=Month y=Rate;
yaxis label = 'Rate (Percent)';
run;

title 'Question 23b';
proc forecast data=B8 method=expo weight=0.2 interval=month out=smooth outall;
id month;
var Rate;
run;

 

title 'Question 23b';

10880 proc forecast data=B8 method=expo weight=0.2 interval=month out=smooth outall;

10881 id month;

ERROR: Variable Month in list does not match type prescribed for this list.

10882 var Rate;

10883 run;


View solution in original post


All Replies
Solution
‎03-04-2018 09:01 AM
Super User
Posts: 23,685

Re: HELP!! Proc Forecast error id variable not valid input

[ Edited ]

input Month $ rate;

 

You've read month in as a character variable, it needs to be a numeric date variable instead.

 

data B8;
informat month monyy5.;
format month monyy5.;
input Month  Rate;

;

 

 

Spoiler

kjt1009 wrote:

I have been working on this problem for the last few hours and I can not figure out how to fix this error I get.

 

SAS Code:

data B8;
input Month $ Rate;
datalines;
Jan63 6.8
Feb63 6.8
Mar63 6.2
Apr63 5.6
May63 5.4
Jun63 6.0
Jul63 5.4
Aug63 4.9
Sep63 4.3
Oct63 4.4
Nov63 4.9
Dec63 5.1
Jan64 6.2
Feb64 6.1
Mar64 5.7
Apr64 5.1
May64 4.7
Jun64 5.7
Jul64 4.7
Aug64 4.5
Sep64 4.0
Oct64 4.0
Nov64 4.0
Dec64 4.3
Jan65 5.3
Feb65 5.5
Mar65 4.9
Apr65 4.5
May65 4.1
Jun65 5.1
Jul65 4.2
Aug65 3.9
Sep65 3.4
Oct65 3.2
Nov65 3.3
Dec65 3.4
Jan66 4.1
Feb66 4.0
Mar66 3.8
Apr66 3.5
May66 3.4
Jun66 4.3
Jul66 3.7
Aug66 3.2
Sep66 2.9
Oct66 2.8
Nov66 3.0
Dec66 3.1
Jan67 3.8
Feb67 3.6
Mar67 3.5
Apr67 3.2
May67 3.0
Jun67 4.3
Jul67 3.7
Aug67 3.4
Sep67 3.1
Oct67 3.1
Nov67 3.0
Dec67 3.0
Jan68 3.7
Feb68 3.8
Mar68 3.4
Apr68 2.9
May68 2.7
Jun68 4.2
Jul68 3.7
Aug68 3.1
Sep68 2.7
Oct68 2.7
Nov68 2.6
Dec68 2.5
Jan69 3.3
Feb69 3.3
Mar69 3.1
Apr69 2.9
May69 2.7
Jun69 4.0
Jul69 3.6
Aug69 3.1
Sep69 3.0
Oct69 2.8
Nov69 2.7
Dec69 2.8
Jan70 3.8
Feb70 4.3
Mar70 4.2
Apr70 4.1
May70 4.2
Jun70 5.5
Jul70 5.1
Aug70 4.7
Sep70 4.5
Oct70 4.5
Nov70 4.9
Dec70 5.2
Jan71 6.1
Feb71 6.2
Mar71 5.9
Apr71 5.4
May71 5.2
Jun71 6.4
Jul71 6.0
Aug71 5.6
Sep71 5.1
Oct71 4.8
Nov71 5.1
Dec71 5.2
Jan72 6.1
Feb72 6.0
Mar72 5.8
Apr72 5.2
May72 5.1
Jun72 6.0
Jul72 5.7
Aug72 5.2
Sep72 4.6
Oct72 4.5
Nov72 4.2
Dec72 4.2
Jan73 5.1
Feb73 5.2
Mar73 4.9
Apr73 4.4
May73 4.2
Jun73 5.1
Jul73 4.7
Aug73 4.3
Sep73 3.9
Oct73 3.6
Nov73 4.0
Dec73 4.1
Jan74 5.2
Feb74 5.3
Mar74 5.0
Apr74 4.6
May74 4.5
Jun74 5.6
Jul74 5.4
Aug74 4.9
Sep74 4.9
Oct74 5.0
Nov74 5.7
Dec74 6.3
Jan75 8.7
Feb75 9.0
Mar75 9.1
Apr75 8.7
May75 8.6
Jun75 9.3
Jul75 8.7
Aug75 7.9
Sep75 7.6
Oct75 7.4
Nov75 7.5
Dec75 7.5
Jan76 8.6
Feb76 8.4
Mar76 8.0
Apr76 7.2
May76 6.8
Jun76 8.1
Jul76 7.6
Aug76 7.3
Sep76 6.9
Oct76 6.7
Nov76 7.0
Dec76 7.2
Jan77 7.9
Feb77 8.2
Mar77 7.6
Apr77 6.7
May77 6.4
Jun77 7.3
Jul77 6.9
Aug77 6.6
Sep77 6.0
Oct77 5.9
Nov77 5.9
Dec77 5.7
Jan78 6.7
Feb78 6.6
Mar78 6.2
Apr78 5.5
May78 5.5
Jun78 6.1
Jul78 6.1
Aug78 5.5
Sep78 5.1
Oct78 4.8
Nov78 5.0
Dec78 5.2
Jan79 5.9
Feb79 6.1
Mar79 5.7
Apr79 5.3
May79 5.0
Jun79 5.9
Jul79 5.7
Aug79 5.5
Sep79 5.1
Oct79 5.1
Nov79 5.2
Dec79 5.3
Jan80 6.5
Feb80 6.5
Mar80 6.4
Apr80 6.6
May80 7.2
Jun80 8.0
Jul80 8.1
Aug80 7.6
Sep80 6.9
Oct80 6.8
Nov80 7.0
Dec80 7.0
Jan81 8.0
Feb81 8.0
Mar81 7.6
Apr81 7.0
May81 7.2
Jun81 7.8
Jul81 7.4
Aug81 7.0
Sep81 6.9
Oct81 7.3
Nov81 7.8
Dec81 8.5
Jan82 9.5
Feb82 9.6
Mar82 9.7
Apr82 9.4
May82 9.5
Jun82 10.3
Jul82 10.1
Aug82 9.8
Sep82 9.7
Oct82 10.1
Nov82 10.6
Dec82 11.0
Jan83 11.9
Feb83 11.9
Mar83 11.4
Apr83 10.6
May83 10.3
Jun83 10.6
Jul83 9.8
Aug83 9.4
Sep83 8.8
Oct83 8.4
Nov83 8.2
Dec83 8.2
Jan84 8.9
Feb84 8.5
Mar84 8.3
Apr84 7.8
May84 7.4
Jun84 7.4
Jul84 7.6
Aug84 7.2
Sep84 6.8
Oct84 6.9
Nov84 6.8
Dec84 7.1
Jan85 8.0
Feb85 7.9
Mar85 7.5
Apr85 7.1
May85 7.0
Jun85 7.5
Jul85 7.4
Aug85 6.8
Sep85 6.6
Oct85 6.5
Nov85 6.6
Dec85 6.6
Jan86 7.3
Feb86 7.8
Mar86 7.5
Apr86 7.0
May86 7.1
Jun86 7.3
Jul86 7.0
Aug86 6.4
Sep86 6.5
Oct86 6.3
Nov86 6.4
Dec86 6.3
Jan87 7.2
Feb87 7.1
Mar87 6.7
Apr87 6.1
May87 6.1
Jun87 6.4
Jul87 6.1
Aug87 5.6
Sep87 5.3
Oct87 5.3
Nov87 5.4
Dec87 5.3
Jan88 6.1
Feb88 6.1
Mar88 5.8
Apr88 5.2
May88 5.4
Jun88 5.4
Jul88 5.4
Aug88 5.2
Sep88 4.8
Oct88 4.7
Nov88 4.9
Dec88 5.0
Jan89 5.7
Feb89 5.5
Mar89 5.2
Apr89 5.0
May89 5.0
Jun89 5.3
Jul89 5.3
Aug89 4.9
Sep89 4.7
Oct89 4.6
Nov89 4.9
Dec89 4.9
Jan90 5.8
Feb90 5.6
Mar90 5.4
Apr90 5.2
May90 5.1
Jun90 5.3
Jul90 5.4
Aug90 5.2
Sep90 5.3
Oct90 5.2
Nov90 5.7
Dec90 6.0
Jan91 7.0
Feb91 7.4
Mar91 7.1
Apr91 6.6
May91 6.7
Jun91 7.0
Jul91 6.9
Aug91 6.5
Sep91 6.3
Oct91 6.3
Nov91 6.6
Dec91 7.0
Jan92 8.1
Feb92 8.3
Mar92 7.9
Apr92 7.4
May92 7.4
Jun92 8.0
Jul92 7.8
Aug92 7.3
Sep92 7.0
Oct92 6.7
Nov92 7.0
Dec92 7.1
Jan93 7.9
Feb93 7.9
Mar93 7.5
Apr93 6.9
May93 6.9
Jun93 7.2
Jul93 7.1
Aug93 6.5
Sep93 6.2
Oct93 6.1
Nov93 6.0
Dec93 6.2
Jan94 7.5
Feb94 7.4
Mar94 7.0
Apr94 6.3
May94 5.9
Jun94 6.3
Jul94 6.4
Aug94 5.8
Sep94 5.5
Oct94 5.3
Nov94 5.2
Dec94 5.0
Jan95 6.1
Feb95 5.8
Mar95 5.7
Apr95 5.5
May95 5.4
Jun95 5.7
Jul95 5.8
Aug95 5.5
Sep95 5.2
Oct95 5.0
Nov95 5.1
Dec95 5.2
Jan96 6.2
Feb96 5.9
Mar96 5.8
Apr96 5.3
May96 5.3
Jun96 5.4
Jul96 5.6
Aug96 4.9
Sep96 4.8
Oct96 4.7
Nov96 4.9
Dec96 4.9
Jan97 5.8
Feb97 5.5
Mar97 5.4
Apr97 4.7
May97 4.7
Jun97 5.1
Jul97 5.0
Aug97 4.6
Sep97 4.5
Oct97 4.2
Nov97 4.1
Dec97 4.3
Jan98 5.0
Feb98 4.8
Mar98 4.8
Apr98 4.0
May98 4.2
Jun98 4.6
Jul98 4.6
Aug98 4.3
Sep98 4.1
Oct98 3.9
Nov98 3.8
Dec98 3.9
Jan99 4.6
Feb99 4.6
Mar99 4.3
Apr99 4.0
May99 3.9
Jun99 4.3
Jul99 4.4
Aug99 4.1
Sep99 3.8
Oct99 3.7
Nov99 3.6
Dec99 3.7
Jan00 4.3
Feb00 4.2
Mar00 4.1
Apr00 3.5
May00 3.7
Jun00 4.0
Jul00 4.0
Aug00 3.9
Sep00 3.5
Oct00 3.5
Nov00 3.5
Dec00 3.6
Jan01 4.5
Feb01 4.4
Mar01 4.4
Apr01 4.0
May01 4.1
Jun01 4.6
Jul01 4.6
Aug01 4.7
Sep01 4.7
Oct01 4.9
Nov01 5.2
Dec01 5.5
Jan02 6.5
Feb02 6.3
Mar02 6.2
Apr02 5.9
May02 5.7
Jun02 6.2
Jul02 6.0
Aug02 5.6
Sep02 5.3
Oct02 5.4
Nov02 5.7
Dec02 5.9
Jan03 6.6
Feb03 6.5
Mar03 6.3
Apr03 6.0
May03 6.0
Jun03 6.6
Jul03 6.4
Aug03 6.1
Sep03 5.7
Oct03 5.6
Nov03 5.7
Dec03 5.6
Jan04 6.3
Feb04 6.1
Mar04 6.2
Apr04 5.4
May04 5.5
Jun04 5.8
Jul04 5.8
Aug04 5.3
Sep04 5.1
Oct04 5.0
Nov04 5.1
Dec04 5.2
;

data B8;
set B8;
format month monyy.;
run;

proc print data=B8;
run;


proc contents data=B8;
run;
proc sgplot data=B8;
title 'Time Series Plot of Table B8';
series x=Month y=Rate;
yaxis label = 'Rate (Percent)';
run;

title 'Question 23b';
proc forecast data=B8 method=expo weight=0.2 interval=month out=smooth outall;
id month;
var Rate;
run;

 

title 'Question 23b';

10880 proc forecast data=B8 method=expo weight=0.2 interval=month out=smooth outall;

10881 id month;

ERROR: Variable Month in list does not match type prescribed for this list.

10882 var Rate;

10883 run;


☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 102 views
  • 0 likes
  • 2 in conversation