BookmarkSubscribeRSS Feed
coder1234
Obsidian | Level 7

Which month in 2016 had the highest number of campers (CampTotal) for ParkCode ACAD (Acadia National Park)?

A potential sas solution: 

 

Spoiler
data work.np_combine; 
    set pg2.np_2015 pg2.np_2016;
    CampTotal=sum(of Camping:);
    where Month in(6, 7, 8) and ParkCode='ACAD' and Year=2016;
    format CampTotal comma15.;
    drop Camping:;
run;

ods select extremeobs;
proc univariate data=work.np_combine nextrobs=1; 
	var CampTotal; 
	id ParkCode Month Year;
run;
Spoiler
.An alternative may also be using Proc Sort by CampTotal and looking for the last.campTotal.

epg2v204_3_b_quiz

A correction may be made in Question 1:  

"forma,t"

coder1234_0-1741963325038.png

 

 

 

2 REPLIES 2
coder1234
Obsidian | Level 7
There is no question. The post has been flaired/tagged displaying that an "Answer" is not required. Thank you,

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

LIBNAME 101

Follow along as SAS technical trainer Dominique Weatherspoon expertly answers all your questions about SAS Libraries.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 4529 views
  • 0 likes
  • 2 in conversation