Cut and paste the data given in the Excel worksheet in to SAS editor window and
ID: 3353445 • Letter: C
Question
Cut and paste the data given in the Excel worksheet in to SAS editor window and make sure that the data is aligned properly to the beginning and ending columns.
Please do not import Excel data set into SAS.
(No credit will be given if you import the data set into SAS).
Please note that BIRTHDATE is entered as a CHARACTER field.
Objective:
Your task is to display your SAS proficiency by writing a SAS programs to read this data set in various ways. Specifically,
Write a program to read in the data using column input. Call the created dataset column.
Write a program to read in the data using formatted input. Call the created dataset formatted.
Note: Your output should clearly show the complete data for the character variables, RACE, GENDER, MARITAL and EDUCATION.
Once you have successfully read in the data to create the 2 temporary SAS datasets above, type the program below [exactly as it appears] into SAS and run it to answer the supervisor’s questions (do not concern yourself with the details of this code at this time):
Proc sort data=formatted;
By gender;
Run;
proc freq data=formatted;
tables gender*education;
title 'Question 1: Breakdown of EDUCATION by GENDER';
run;
proc means data=formatted mean maxdec=3;
var height weight;
title 'Question 2: Mean HEIGHT and WEIGHT by GENDER';
by gender;
run;
What is the breakdown of EDUCATION by GENDER among this group of subjects?
What is the mean HEIGHT and WEIGHT by GENDER in this study?
Id Race birthdate FEV Height Gender weight coffee1 Duration temperature wbccount marital education 1 white 1/2/45 1.708 57 female 57 0 5 99 8 Married Masters Degree 2 black 2/1/56 1.724 67.5 female 76 2 10 98 5 Married Masters Degree 3 black 3/5/67 1.72 54.5 female 114 0 6 99 12 Married High school diploma 4 other 12/30/72 1.558 53 male 62 0 11 98.2 4 Married Four-year College 5 asian 3/10/55 1.895 57 male 58 14 5 98.5 11 Married Masters Degree 6 hispanic 1/20/68 2.336 61 female 49 0 14 96.8 6 Married Four-year College 7 white 4/12/65 1.919 58 female 78 0 30 99.5 8 Divorced High school diploma 8 white 11/25/78 1.415 56 female 76 14 11 98.6 7 Single High school diploma 9 white 10/15/73 1.987 58.5 female 64 28 17 98 7 Divorced Four-year College 10 hispanic 10/25/77 1.942 60 female 58 21 3 98 12 Divorced Masters Degree 11 asian 9/10/81 1.602 53 female 60 28 9 97.6 7 Married Four-year College 12 mutliracial 6/6/61 1.735 54 male 70 21 3 97.8 3 Married High school diploma 13 white 7/8/82 2.193 58.5 female 81 7 8 99.5 11 Married High school diploma 14 white 10/9/44 2.118 60.5 male 61 21 8 98.4 14 Divorced Four-year College 15 multiracial 2/3/81 2.258 58 male 55 14 5 98.4 11 Divorced High school diploma 16 black 4/12/65 1.932 53 male 61 42 5 99 9 Married High school diploma 17 other 11/25/78 1.472 50 male 62 0 7 99.2 6 Married Masters Degree 18 white 10/15/73 1.878 53 female 70 28 4 98 6 Married High school diploma 19 white 10/25/77 2.352 59 male 53 28 3 97 5 Married Four-year College 20 black 1/2/45 2.604 61.5 male 60 28 7 98.2 6 Divorced Masters Degree 21 white 2/1/56 1.4 49 female 68 0 9 98.2 10 Divorced High school diploma 22 white 3/5/67 1.256 52.5 female 70 7 11 98.6 14 Single High school diploma 23 white 2/3/81 0.839 48 female 60 49 11 97.6 4 Single Two-year College 24 hispanic 4/12/65 2.578 62.5 male 60 42 9 98.6 5 Single High school diploma 25 asian 11/25/78 2.988 65 female 57 0 4 98 5 Married Two-year College 26 mutliracial 10/15/73 1.404 51.5 male 58 0 4 98 6 Divorced Masters Degree 27 white 10/25/77 2.348 60 male 72 14 3 97 5 Single High school diploma 28 white 1/2/45 1.755 52 male 112 0 7 98.2 6 married doctoral degree 29 multiracial 2/1/56 2.98 60 female 97 7 9 98.2 10 Married Two-year College 30 black 3/5/67 2.1 60 female 59 7 11 98.6 14 Divorced Masters Degree 31 white 1/2/46 1.582 51 male 112 0 7 98.2 5 married Masters Degree 32 black 2/3/82 2.258 57 female 55 23 6 98.4 13 Divorced Two-year College 33 asian 10/25/79 1.942 58 female 58 21 3 98 9 Divorced Masters Degree 34 white 9/10/80 1.602 54 female 60 28 9 97.6 10 Married Four-year College 35 multiracial 6/6/63 1.735 56 male 70 21 3 97.8 4 Married High school diplomaExplanation / Answer
Sorting of Education by Gender
Education
Male
Female
Total
Doctoral Degree
1
-
1
Master’s Degree
5
5
10
4-year College
3
4
7
2-year College
-
4
4
High School Diploma
6
7
13
Total
15
20
35
Mean Weight and Height by Gender
Gender
Mean Weight
Mean Height
Male
68.40
55.93
Female
68.35
57.025
Education
Male
Female
Total
Doctoral Degree
1
-
1
Master’s Degree
5
5
10
4-year College
3
4
7
2-year College
-
4
4
High School Diploma
6
7
13
Total
15
20
35
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.