A local high school collects data on student performance in grades 9 through 12. In grades 9 and 10, data were collected for Science and English only, while for grades 11 and 12, Math scores were also recorded.

Unfortunately, the data so collected were recorded as described below resulting in two completely different data layouts. Write a SAS program to create a temporary SAS data set called perform which contains observations for all four years of high school by accessing raw data (may be, containing 100s of data lines) as described below. Turn in your SAS program.

Sample Data Lines:

123 Columns:123456789012345678901234567890 ______________________________ 0962432736578 118091315736792 0945712817859 125916294847689 1076543057182 112479329697883 Data Description: (note the two types of data lines depending on grade)

Field Variable description Columns Type 1 Grade 1–2 Char (09 or 10)

2 Student Id 2–6 Char 3 GPA 7–9 Numeric (with 2 decimals)

4 Science 10–11 Numeric (whole number)

5 English 12–13 Numeric (whole number)

1 Grade 1–2 Char (11 or 12)

2 Student Id 2–6 Char 3 GPA 7–9 Numeric (with 2 decimals)

4 Science 10–11 Numeric (whole number)

5 Math 12–13 Numeric (whole number)

6 English 14–15 Numeric (whole number)