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;
Click image to register for webinar
