SAS® Programming 2: Data Manipulation Techniques Lesson 6 Practice Challenge

[coder1234]

Modify the DO statement to produce the following results. The DO statement will now be based on a list of values instead of a value that is incremented.

An alternate solution instead of: 

Spoiler

typing out the Year 1, Year 2... manually which the solution suggests, could use 

YearZ=cat('Year ', Year);

data IncMPG;
    set sashelp.cars;
    MPG=mean(MPG_City, MPG_Highway);

DO Year = 1 to 5; 
MPG=sum(MPG*1.03);
YearZ=cat('Year ', Year);
output;
end;
run;

title 'Projected Fuel Efficiency with 3% Annual Increase';
proc print data=IncMPG;
    var Make Model YearZ MPG;
	format MPG 4.1;
run;
title;

Which gives the same end result.