I have another text file which Derek Hinz provided with some information on classes that students 
are taking.  The student ID numbers are fake, but other aspects are real.  The name of the 
data set is  STUDENTS.txt  and the first lines look like this: 

746187689  HED   MR  ST   610N    002  SPTP-EXPLORE DATA   0805  0855 M W F DICKEY                        3
014947264  ZO    MR  ST   520     001  ST PR CLIN TRI EPI  0805  0920  T H  D ZHANG                       3
453531608  ZO    DR  ST   711     002  DESIGN OF EXPERIM   1225  1315 M W F M GUMPERTZ                    3 

We have the (fake) student ID, major, class, department offering course, course ID, section number
course title, start time, end time, days of week, name of instructor, and credit hours. 

Do (try) least 4 of these 6 tasks:

     

  1.  Make a data set for all courses taught by WOODARD or R WOODARD and another for DICKEY, both 
sorted by course number and section. Print these datasets. 

  2.  Make a data set with all the courses whose course ID ends with a letter (like ours 610N) 
and sort these by the course title in alphabetical order

  3.  Sort the big data set by instructor.  Run PROC MEANS N; by instructor to count up how many students
each instructor has. 

  4.  We want to find the records for all students who, like us, love to get up early. Make two data sets 
of all records for the courses that start at 805 - one for the Tuesday - Thursday classes and one for MWF. 
Print them, sorted by end times.  Are the end times always the same within each data set?

  5.  Find all the records for classes that meet on Wednesday, and put them in a dataset. How many records are 
chosen?  Can you tell without printing them out? (Log) Do this assuming that a course might meet MWF or 
MW or TWH etc.(H is Thursday) Using an IF statement, create a subset of those records, if any, that meet 
on W but are NOT listed as M W F classes.  Are there any? 

  6.  Print out a dataset that has a single line for every (class, instructor) combination that has 
auditors (0 credit hours).  On each line, print the class, instructor, and number of auditors 
(e.g. ST 610A Dickey 2).   

  7.  Suggest and solve some other interesting SAS problem involving this data. If you do something worth 
presenting, let me know! You could be the next ST610N idol!