Sentry Page Protection

Please Wait...

Coding Exercise (Answer)
​
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;

Next