SAS Studio, Programming 2, Lesson 2 Summarizing Data Challenge Practice

Juli4 — Sun, 15 Nov 2020 00:59:56 GMT

SAS Studio, Programming 2, Lesson 2 Summarizing Data Challenge Practice: Determining Maximum Amounts

Question: Why am I not seeing the same number as the solution for question 2? I typed the same code, however, in my output table, the column for TrafficMax all result in the value '0'

Question 2 of the challenge practice asks: "What is the value of TrafficMax in row 4, and why?"

Solution: TrafficMax retains the value of 1,447 from the previous row because the 772 value of Count in row 4 is not greater than the current value of TrafficMax."

Create a table, cuyahoga_maxtraffic, from the pg2.np_monthlytraffic table. Use the following specifications:

Include only rows where ParkName is equal to Cuyahoga Valley NP.
Create three columns: TrafficMax, MonthMax, and LocationMax. Initialize TrafficMax to 0.
If the current traffic count is greater than the value in TrafficMax, then:
- set the value of TrafficMax equal to Count
- set the value of MonthMax equal to Month, and
- set the value of LocationMax equal to Location
Format the Count and TrafficMax columns so that values are displayed with commas.
Keep only the Location, Month, Count, TrafficMax, MonthMax, and LocationMax columns in the output table.
Submit the program and examine the ouput data.


data cuyahoga_maxtraffic;
    set pg2.np_monthlyTraffic;
    where ParkName = 'Cuyahoga Valley NP';
    retain TrafficMax 0 MonthMax LocationMax;
    if Count>TrafficMax then do;
        TrafficMax=Count;
        MonthMax=Month;
        LocationMax=Location;
    end;
    format Count TrafficMax comma15.;
    keep Location Month Count TrafficMax MonthMax LocationMax;
run;

Thank you.

Re: SAS Studio, Programming 2, Lesson 2 Summarizing Data Challenge Practice

mharding — Mon, 16 Nov 2020 18:44:06 GMT

Hi Juli4,

Your code does match the solution, and to double check I copied your code, ran it and I did get the correct results. There could be an issue with the input table.

Did you see the following NOTE in your log?

NOTE: There were 384 observations read from the data set PG2.NP_MONTHLYTRAFFIC.
WHERE ParkName='Cuyahoga Valley NP';

Thank you

Mary

Re: SAS Studio, Programming 2, Lesson 2 Summarizing Data Challenge Practice

Juli4 — Thu, 19 Nov 2020 04:45:12 GMT

Hi Mary,

Thank you for the prompt response. I did receive the same NOTE in my log.

Upon closer look, it was a syntax error.
The code I ran was
data cuyahoga_maxtraffic;...

TrafficCount=Count;

instead of
TrafficMax=Count;

I have the correct solution now, thank you so much.

topic Re: SAS Studio, Programming 2, Lesson 2 Summarizing Data Challenge Practice in Programming 1 and 2

SAS Studio, Programming 2, Lesson 2 Summarizing Data Challenge Practice

Re: SAS Studio, Programming 2, Lesson 2 Summarizing Data Challenge Practice

Re: SAS Studio, Programming 2, Lesson 2 Summarizing Data Challenge Practice