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-white.png

Missed SAS Innovate in Orlando?

Catch the best of SAS Innovate 2025 — anytime, anywhere. Stream powerful keynotes, real-world demos, and game-changing insights from the world’s leading data and AI minds.

 

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
  • 1080 views
  • 0 likes
  • 2 in conversation