BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
kjt1009
Calcite | Level 5

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;

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

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

1 REPLY 1
Reeza
Super User

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;


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!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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