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

kjt1009 · Posted 02-26-2018 11:12 AM

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;

Reeza · Posted 02-26-2018 11:24 AM

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;

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

Reeza · Posted 02-26-2018 11:24 AM

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;

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

HELP!! Proc Forecast error id variable not valid input

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

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

HELP!! Proc Forecast error id variable not valid input

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

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

Click image to register for webinar

Classroom Training Available!