option limwarn=0;

freq m; smpl 46:1 95:11;
read(file='ex154.xls', format=excel)   PW1191   PWO2   PW81   PW51   PW531;

? price indexes of the following commodities
oilgas= PW1191; 
fueloil=PWO2;
lumber=PW81 ;
coal= PW51;
natgas=PW531;

list var oilgas fueloil lumber coal natgas;

title 'oilgas';
unit(nocoint, tsq, nows, terse, maxlag=1, minlag=1) oilgas;
title 'fueloil';
unit(nocoint, tsq, nows, terse, maxlag=1, minlag=1) fueloil;
title 'lumber';
unit(nocoint, tsq, nows, terse, maxlag=1, minlag=1) lumber;
title 'coal';
unit(nocoint, tsq, nows, terse, maxlag=1, minlag=1) coal;
title 'natgas';
unit(nocoint, tsq, nows, terse, maxlag=1, minlag=1) natgas;

freq a;
convert(average) oilgas;
convert(average) fueloil;
convert(average) lumber;
convert(average) coal;
convert(average) natgas;
write(file='ex154a.xls', format=excel) oilgas fueloil lumber coal natgas;
 
?dot var;
?unit(nocoint, tsq, nows, terse, maxlag=1, minlag=1) .;
?enddot;

end;stop;