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

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

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
  • 4467 views
  • 0 likes
  • 2 in conversation