Search the site...

SASCRUNCH TRAINING
  • Home
  • Member's Area
  • How to Start
  • SAS Interface
  • Creating a Data Set
  • Practical SAS Training Course
  • SAS Certified Specialist Training Program
  • Proc SQL Course
  • Introduction to Time Series Analysis
  • SAS Project Training Course
  • Full Training / Membership
  • Sign up
  • About us
  • Contact us
  • Home
  • Member's Area
  • How to Start
  • SAS Interface
  • Creating a Data Set
  • Practical SAS Training Course
  • SAS Certified Specialist Training Program
  • Proc SQL Course
  • Introduction to Time Series Analysis
  • SAS Project Training Course
  • Full Training / Membership
  • Sign up
  • About us
  • Contact us
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
Already a member? Go to member's area.