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

coder1234 — Thu, 20 Mar 2025 21:48:35 GMT

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:

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.

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

OleSteen — Fri, 03 Oct 2025 14:33:56 GMT

You are asked to change from a DO-loop with incremented numeric year, to create a character value like "Year 1", "Year 2" etc.

This can be done with a DO-loop like:

Do Year = "Year 1", "Year 2" etc.

topic Re: SAS® Programming 2: Data Manipulation Techniques Lesson 6 Practice Challenge in Programming 1 and 2

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

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