Sentry Page Protection
Coding Exercise (Answer)
Exercise 1
Answer:
proc sql;
select *
from tripdata;
quit;
Exercise 2
Exercise 1
Answer:
proc sql;
select *
from tripdata;
quit;
Exercise 2
Answer:
proc sql;
select tripid, duration, startdate, enddate
from tripdata
order by duration;
quit;
Exercise 3
Answer:
proc sql;
select bikeno, count(bikeno) as n
from tripdata
group by bikeno
having n > 1;
quit;
Exercise 4
Answer:
proc sql;
select *
from tripdata
where timepart(startdate) between '9:00't and '10:00't;
quit;
Exercise 5
Answer:
proc sql;
select *
from tripdata
where endterminal = 11;
quit;
Exercise 6
Answer:
proc sql;
select *
from tripdata
where duration > 7200;
quit;
Exercise 7
Answer:
proc sql;
select startstation,
mean(duration)/60 as mean
from tripdata
group by startstation
order by mean desc;
quit;
Exercise 8
Answer:
proc sql;
select
case
when timepart(startdate) >= '12:00't then "Afternoon"
else "Morning"
end as trip, count(*) as n
from tripdata
group by trip;
quit;
Exercise 9
Answer:
proc sql;
select distinct startstation
from tripdata;
quit;
Exercise 10
Answer:
proc sql;
select *
from tripdata
where endstation in
(select station
from newstations);
quit;
proc sql;
select tripid, duration, startdate, enddate
from tripdata
order by duration;
quit;
Exercise 3
Answer:
proc sql;
select bikeno, count(bikeno) as n
from tripdata
group by bikeno
having n > 1;
quit;
Exercise 4
Answer:
proc sql;
select *
from tripdata
where timepart(startdate) between '9:00't and '10:00't;
quit;
Exercise 5
Answer:
proc sql;
select *
from tripdata
where endterminal = 11;
quit;
Exercise 6
Answer:
proc sql;
select *
from tripdata
where duration > 7200;
quit;
Exercise 7
Answer:
proc sql;
select startstation,
mean(duration)/60 as mean
from tripdata
group by startstation
order by mean desc;
quit;
Exercise 8
Answer:
proc sql;
select
case
when timepart(startdate) >= '12:00't then "Afternoon"
else "Morning"
end as trip, count(*) as n
from tripdata
group by trip;
quit;
Exercise 9
Answer:
proc sql;
select distinct startstation
from tripdata;
quit;
Exercise 10
Answer:
proc sql;
select *
from tripdata
where endstation in
(select station
from newstations);
quit;