This is SAS Programming in Statistics 4330 class.

Suppose that a data set called, College.sas7bdat is in E:SASProgramming 1 Data. This data set contains data on students attending a 4-year state university

Write a SAS program that produces the specified reports. Each report should utilize the following

aspects:

-Descriptive title(s). The title should contain the Report Number and description of what is

contained in the report

-Formatted values for GENDER, CLASSIFICATION, and COLLEGE (see table below). You should

define your formats using one PROC FORMAT. In addition use SAS formats where appropriate

(dates, currency, etc.)

-Suppress observation numbers and use labels to describe variables.

-If the report requires sorting you can either sort the permanent dataset or create a sorted

dataset in the work library.

Report #1

Create a list of students using the following criteria:

-Variables in report student id, last name, first name, gender, credit hours

-Include only Business students

-List by alphabetical order of last name

-Provide the total number of credit hours. Credit hours should be displayed in whole numbers

no decimal points.

Report #2

Create a list of students using the following criteria:

-Variables in report student id, last name, first name, college, birthdate

-Include only junior female students with a GPA between 2.5 and 3.5

-List by alphabetical order of colleg

-Format birth date so month, day, and year are printed (the exact format is your preference)

Report #3

Create a list of students using the following criteria:

-Variables in report student id, last name, first name, college, classification, gpa

-Include students from Business or Engineering

-Sort by college and last name

-GPA should be formatted by dividing into the following levels:

0.00 0.99 -- F

1.00 1.99 -- D

2.00 2.99 -- C

3.00 3.99 -- B

4.00 -- A

Data Description for College Variable Name Student ID First Name Last Name Gender Description Student ID First name of student Last name of student Gender Values F-Female M-Male BirthDate Classification Date of birth Class of student FR-Freshman SO-Sophomore JR-Junior SR-Senior SAT College Highest SAT score College of student AS-Arts & Sciences BU-Business EN Engineering Major Credit hrs Maior of student Credit hours attempted by student for semester Cumulative GPA GPA Data Description for College Variable Name Student ID First Name Last Name Gender Description Student ID First name of student Last name of student Gender Values F-Female M-Male BirthDate Classification Date of birth Class of student FR-Freshman SO-Sophomore JR-Junior SR-Senior SAT College Highest SAT score College of student AS-Arts & Sciences BU-Business EN Engineering Major Credit hrs Maior of student Credit hours attempted by student for semester Cumulative GPA GPA