## [answered] BRADBURY, JANICE WILL 4Gray Brown 5 00 F018 ODELL, LENA WIL

Overview

In this SAS assignment, you are to write a SAS program to compute some statistics and print some graphs from data about students in the fictitious course CSCI 220.? To practice their SAS programming, each student has provided some personal information about himself or herself.? For the personal information that some students refused to divulge, there are missing values with a period in the first column of that data item in the student's (observation's) record in the input file.

Input

The input file is named studentstats.txt and it contains a record for each student (or for each observation) having the following format:

`Columns: 1-20 name of student`
` 22-31 county of residence`
` 34 class standing (1 = Freshman, 2 = Sophomore, 3 = Junior, 4 = Senior, 5 = Graduate)`
` 35-40 eye color`
` 42-47 hair color`
` 49 height: the 'feet' part of the height`
` 51-52 height: the 'inches' part of the height`
` 54 sex (F = female, M = male)`
` 55-57 age`

Programming Requirements

NOTE:? In completing the following steps, complete them in order and one at a time to be sure each successive step is working exactly as it should.? Be sure to check the Log tab for the latest execution of your program.? If there is any brown type, there is a problem with that step!? Fix it before moving on!? Also, the highlighted word(s) in each numbered item below will give you a hint of which function you need to use to accomplish the task.? For example, the word 'sort' tells you that you need to use the PROC SORT.

Write a SAS program to do the following:

Create a new SAS data set named student_stats_1.? Besides using ALL of the data provided in the input data set for each student (observation), you will create a few new variables by manipulating the data in the raw data set.? First, create a new variable to hold the calculated value for total height-in-inches.? The required value can be obtained from the input data values for the feet and inches portions of the observation's height. Second, create another a new variable to hold the value 'Freshman' for those students with class standing of 1, the value 'Sophomore' for those students with class standing of 2, etc.

Sort the SAS data set created in Step 1 on the following keys:

The primary sort key is to be the county of residence.

The secondary sort key is to be the total height-in-inches.

The sorting is to be in ascending order on the primary and key, and in descending order on the secondary key. The output from this sort step is to be written to a second SAS data set called student_stats_2. You will now have two SAS files passed around in your program.

Use the MEANS procedure to obtain statistics on the age and total height-in-inches variables, using student_stats_2 for input. The statistics required for this report are:

the number of observations

the number of missing observations

the mean

the standard deviation

the maximum value

the minimum value

the range

Use the title 'CSCI 220 - STUDENT INFORMATION' and two subtitles '** STUDENT HEIGHT STATISTICS **' and '** FALL 2016 **'.? Add a footnote to this report stating 'Report prepared by ' followed by YOUR name.

Print the values in the county, total height-in-inches and name variables. Use the SAS data set (student_stats_2) that was created in Step 2 as the input data set for this step.

Write this information using the title 'CSCI 220 - STUDENT TOTAL HEIGHT-IN-INCHES' and using two subtitles '** SORTED BY COUNTY and TOTAL HEIGHT-IN-INCHES **' and '** FALL 2016 **'.? Add a footnote to this report stating 'Report prepared by ' followed by YOUR name.

Sort the SAS data set created in Step 1 on the following keys:

The primary sort key is to be the county of residence.

The secondary sort key is to be the class standing (the numeric value).

The tertiary sort key is to be the name of the student.

The sorting is to be in ascending order on all three keys. The output from this sort step is to be written to a new SAS data set called student_stats_3. (You will now have three SAS files.)

Produce a pie chart of student enrollments by eye color using student_stats_1 for input.

Use the following lines for the title and subtitle for this step: 'CSCI 220 - CHART OF STUDENT EYE COLOR' and '** FALL 2016 **'. ?Add a footnote to this report stating 'Report prepared by ' followed by YOUR name.

Produce a vertical bar chart of student enrollments by county using student_stats_2 for input. Use the following lines for the title and subtitle for this step: 'CSCI 220 - STUDENT FREQUENCY????? CHART BY COUNTY' and '** FALL 2016 **'.? Add a footnote to this report stating 'Report prepared by ' followed by YOUR name.

Using student_stats_2 for input, produce another vertical bar chart of student total height-in-inches using the midpoint values of 58, 61, 64, 67, 70, 73, 76 and 79, and using the SEX variable for subgrouping. Use the following lines for the title and two subtitles, respectively:? 'CSCI 220 - STUDENT FREQUENCY CHART BY HEIGHT', '** SUBGROUP = SEX **' and '** FALL 2016 **'.? Add a footnote to this report stating 'Report prepared by ' followed by YOUR name.

Produce a block chart of student enrollments by class grouped on the Sex variable.

Use student_stats_3 for input, and use the following lines for the title and two subtitles, respectively:? 'CSCI 220 - STUDENT FREQUENCY CHART BY CLASS', '** GROUP = SEX **' and '** SPRING ?2016 **'.? Add a footnote to this report stating 'Report prepared by ' followed by YOUR name.

Print a complete report of student_stats_3 as sorted in step 7 above.

Use the following lines for the title and subtitle for this step:? 'CSCI 220 - COMPLETE STUDENT REPORT' and '** FALL 2016 **'.? Add a footnote to this report stating 'Report prepared????? by ' followed by YOUR name.

Produce a block chart of student enrollments by class using for input the SAS data set student_stats_3. Use the following lines for the title and subtitle for this step: 'CSCI 220 - STUDENT FREQUENCY CHART BY CLASS' and '** FALL 2016 **'.? Add a footnote to this report stating 'Report prepared by ' followed by YOUR name. Be sure to add line comments(Coding and Documentation Guidelines).

BRADBURY, JANICE WILL 4Gray Brown 5 00 F018 ODELL, LENA WILL 5Gray Brown 5 00 F018 ONJACK, CHRISTOPHER DEKALB 3Gray Gray 6 01 M059 PAVORIS, DARREN COOK 4Blue Brown 5 02 M. HAWKINS, RHONDA COOK 3Brown Brown 4 09 F020 BRADY, JEANE WINNEBAGO 4Blue Red 4 10 F023 HILDEBRAND, TOM LAKE 3Blue Brown 6 00 M021 DIRIENZO, ROBERT DUPAGE 3Blue Brown 5 10 M022 AVVISATI, LOU COOK .Hazel Brown 5 08 M018 OBERT, PETER KANE 1Hazel Brown 6 00 .019 BRAKE, CHRISTEL KANE 3Hazel Black 5 02 F021 MASUD, SHABANO DEKALB 4Brown Black 5 06 F. CZOSEK, EDWARD COOK 4Green Blond 5 06 M023 SLENES, TED . 2Blue Brown 6 02 M018 CASTENSON, LORI DEKALB 4Brown Brown 5 05 F030 KAMBEROS, LEE COOK 2. . 5 09 M022 WALDECK, BART DEKALB 2Green Brown 5 10 M022 PROKSA, JOHN COOK 2Gray Brown 6 01 M. CAVENDER, KATIE LAKE 4Brown Brown 5 05 F021 ROHR, CHRISTINE DUPAGE 2Gray Brown 5 03 F018 THOMPSON, DONNELL COOK 4Brown Blond 6 03 M019 ROGERS, LATONYA COOK .Green Blonde 5 03 F017 DAY, DEANA KANE 2Blue Blonde 4 11 F019 BUDRECK, PAULETTE KANE 4Brown Brown 5 00 F020 LEWIS, TODD DEKALB 3Hazel Brown 6 03 M021 KELLY, MELICE COOK 4Brown Brown 5 05 F022 MUNCIE, SHERRI LAKE 5Brown Brown 5 05 F020 DAYTON, SUE DEKALB 4. Brown 5 07 F019 DORSAM, LORI DEKALB 4Brown Brown 5 02 F018 BARBARO, SALVATORE DUPAGE 4Brown Brown 5 09 M022 CORNO, CHRISTINA DUPAGE 2Blue Blonde 5 08 F025 DAVIS, ROSE WINNEBAGO 3Brown Brown 5 02 F034 MINETT, GAYLORD COOK 3Blue Blond 6 00 M023 MAKI, BRIAN COOK 3Brown Black 6 00 M019 SIMAC, ANDREW DUPAGE 3Blue None 5 10 M019 FRANZENE, KIM MCHENRY 4Brown . 5 07 F023 TODD, JENNIFER . 3Gray Black 5 03 F020 MOATS, ALICIA LAKE 2Blue Blonde 5 05 F018 FLEGEL, ROY DEKALB 3Blue None 5 10 M. GOOD, KAREN DEKALB 3Blue Red 5 00 F022 LIMON, DAVID COOK 3Brown Brown 5 07 M023 SCHIMANSKI, SABRINA COOK 3Blue Blonde 5 07 .018 ARQUILLA, JIM COOK 4. Brown 6 05 M018 LAROPA, LINDA WINNEBAGO 1Brown Brown 5 00 F019 BADON, RONALD JR. COOK 5Gray Brown 6 01 M018 BLAKE, FRANK COOK 3Blue None 5 05 M019 WAGNER, BRIAN COOK 3Blue None 6 04 M020 ERWIN, KATIE COOK Hazel Brown 5 06 F018 HOROWITZ, RICK COOK 3Hazel Red 6 06 M019 ABADEER, SAMEH WINNEBAGO 3Brown Blond 5 11 M019 HANLEY, MIKE COOK 2Blue Red 6 04 M021 MILLIES, ROBERT WILL 3Blue Brown 6 00 M020 VANNESS, STEVE DUPAGE 3Blue Brown 6 00 M020 MOORE, DENISE COOK 3Brown Brown 5 06 F020 SCHAFER, MIKE JO DAVIES 4Brown Brown 6 03 M024 ZROBACK, JEFF COOK 3Blue None 6 00 M022 THOMPSON, JEFF . 2Brown Brown 6 03 .021 MONOHAN, ROB DEKALB 2Blue None 6 00 M018 SUNICH, TRISH DEKALB 3Hazel Brown 5 07 F019 SHANDLER, PATRICIA JO DAVIES 5Hazel Blonde 5 02 F019 THAYER, TRICIA LEE 2Gray Gray 5 02 F058 WRAY, MARK DEKALB 3Green None 6 05 M017 RASMUSSEN, DAVID DEKALB 1Brown Brown 5 09 M018 CORTES, JESUS DUPAGE 3Brown Black 5 07 M020 JARPY, JANA COOK 4Blue Black 6 00 F021 TEKAMPE, SUSAN LAKE 3Brown Brown 5 09 F018 BRATTSET, BERIT MCHENRY 3Brown Blond 5 06 M019 SCHWARTZ, TOM COOK 2Hazel Brown 5 05 M. RAFFERTY, BRIAN COOK 4Brown Brown 6 00 M022 SARULLO, PETE COOK 3Brown Brown 5 10 M020 POPP, JON COOK 3Blue Brown 5 11 M018 NELSON, MICHAEL PEORIA 2Blue None 5 11 M019 HERDMAN, JIM COOK 3Blue Brown 5 08 M024 DUTKA, MICHAEL WILL 3Blue Brown 6 04 M038 SCHROEDER, KELLY LAKE 3Hazel Brown 5 06 F031 CHMIELEWSKI, EDWARD DEKALB 2Gray Brown 5 11 M022 BARKELY, BRIAN DEKALB 1Gray Gray 5 11 M051 KING, BRIAN WINNEBAGO 3Brown Brown 5 09 M020 WRIGHT, JEAN COOK 3Green Red 5 04 F025 VANGYSEGHAM, ROBERT KANE 4Blue Brown 5 11 M018 MADOWIA, CARL COOK 4Blue None 6 01 M019 GRANDIN, NANCY-LEE DUPAGE 4Gray Brown 5 01 F020 GADBOW, GREGOR MONROE 2Gray White 6 02 M080 MENTZEL, CHRIS WINNEBAGO 2Blue Brown 5 06 M020 CLARK, MARY DEKALB 3Green Brown 5 05 F019 RAY, TIM DEKALB 4Brown Brown 6 02 M018 SOCO, JONATHAN COOK 4Brown Blond 5 07 M019 SCURIO, DAN COOK 3Blue Blond 6 01 M018 JEMILO, MICHAEL COOK 4Hazel Brown 5 11 M018 STEPHENS, MIKE DEKALB 3Brown . 6 01 M019 DEMEO, MICHAEL COOK .Brown Brown 5 11 M020 BIENASZ, JEFF LAKE 2Brown Brown 6 02 M021 LOPATOWSKI, DAN COOK 2Brown Gray 5 08 M052 KAMERLY, BETTY DUPAGE 1Brown Brown 5 05 F023 KERMOTSU, BRETT WINNEBAGO 4Brown Blond 5 09 M024 CANNON, BRIAN DUPAGE 3Blue Brown 5 08 M022 FICKE, TIM DEKALB 3Brown Brown 5 10 M018 LUCITT, KAREN COOK 2Gray Brown 5 09 F020 OLSON, ROBERT MCHENRY 3Blue None 5 07 M019 PELIKAN, DONNA COOK 4Brown Brown 5 06 F021 BRITT, LINETTE KANE 4Gray Blonde 5 05 F023 BOOE, TIM LAKE .Gray Brown 5 09 M018 WITHER, JIM OGLE 3Brown Brown 5 09 M020 PETRUGALLO, ANTONIO MCHENRY 3Brown Brown 6 03 M021 BATJES, DAVE COOK 2Brown Brown 6 01 M022 EZOP, KEN MCHENRY 2Brown Gray 5 08 M064 CHATTERTON, MICHAEL WHITESIDE 4Brown Brown 5 11 M023 MASON, STEPHEN WINNEBAGO 3Brown Brown 6 02 M021 STOYNOFF, PETE WILL 3Brown None 5 11 M020 ROZECKI, CARL SANGAMON 5Brown White 5 10 M100 ORT, KARIN MCHENRY 3Blue Black 5 06 F018 VANDEN HEUVEL, PAUL DUPAGE 3Blue Brown 6 01 M018 FULL, AMY KANE 3Brown Brown 5 03 F018 SUM, CYNTHIA COOK 4Blue Brown 5 04 F019 SCHEIDHAUER, WILLIAM DUPAGE 4Blue None 5 08 M020 ONEAL, KIMBERLY DEKALB 3Gray Blonde 5 04 F018 COAKLEY, WILL COOK 3Brown Brown 5 11 M018 FONG, GEORGE COOK 4Brown Blond 5 04 M019 RIEBEL, MIKE PEORIA 5Blue Brown 6 00 M020 CORSO, CHRIS DUPAGE 4Blue Brown 5 08 M018 THOMAS, BRIDGETTE COOK 3Brown Black 5 05 F. YATES, JOE WILL 4Brown Brown 5 09 M019 CISON, JOHN COOK 3Blue Brown 6 00 M021 CONARCHY, JOHN LAKE 4Blue Brown 5 10 M020 GOAR, MARSHA IROQUOIS 5Gray Brown 5 04 F020 MARKESE, JON LAKE 3Brown Brown 6 02 M020 DIXON, JOHN LEE 3Blue Brown 6 01 M024 ECHLIN, MIKE KANE 2Brown Brown 6 05 M022 KINDRICK, CRAIG COOK 4Blue Brown 5 08 M021 HUCALL, JAMIE KANE 4Hazel Blonde 5 06 F018 ANDRETICH, LISA COOK 4Brown Brown 5 04 F019 FISCUS, DAVE IROQUOIS 3Blue Brown 5 11 M019 CUSHING, DANIEL WILL 2Hazel Brown 5 08 M018 GILLIS, DAVID COOK 3Brown Brown 5 11 M017 MURNANE, TERRI COOK 3Brown Brown 5 06 F018 POZECK, TONY COOK 2Brown Brown 5 10 M020 BELL, SCOTT COOK 4Brown Brown 6 01 M021 KORBEL, HEIDI COOK 2Brown Red 5 01 F018 BROWN, JOHN WILL 3Brown Brown 6 02 M019

GREEN, GRETA JO DAVIES 5Blue Brown 5 06 F021 SMILGYS, AUDREY DEKALB 3Brown Brown 5 04 F022 GREENE, TOM DEKALB 4Gray None 6 00 M020 HOAG, ROBERT KANE 3Blue None 5 11 M018 RAJECK, SCOTT DUPAGE 3Brown Blond 6 06 M019 KAMMINSKI, BRIAN COOK 2Blue Brown 5 09 M024 LAMB, ERIN COOK 2Blue Black 5 05 F038 BROWN, LARRY WINNEBAGO 5Brown Brown 5 11 M031 CHANDLER, WILLIAM COOK 3Brown Brown 5 10 M022 LERETTE, TAMI LAKE 3Gray Brown 5 06 F021 MANCE, TOM COOK 3Hazel Brown 5 10 M020 ORBEK, HELEN KANE 5Hazel Brown 5 09 F025 MASKEL, DENNIS DEKALB 3Brown Brown 6 00 M018 ONEILL, LEANNE COOK 3Gray Black 5 07 F019 KOUSINS, KEITH LAKE 3Brown Brown 6 00 M035 BARNES, JILL KANE 3Blue Brown 5 02 F020 KISSEL, ALICA LAKE 4Blue Red 5 03 F019 LAUBER, JIM KANE 3Hazel Blond 6 00 M018 HUH, JAMES DEKALB 3Brown Blond 5 08 M019 KERN, DAN LAKE 4Blue Brown 5 11 M018 STEVENS, NICK MCHENRY 3Hazel Brown 5 09 M018 CELAM, MARY KANKAKEE 1Hazel Brown 5 00 F019 LUSSNIG, MKE COOK 4Brown Brown 6 02 M020 REED, DEBORAH SANGAMON 4Brown Blonde 5 10 F021 BOBBITT, WILLIAM COOK 2Brown Brown 5 09 M022 RACZEK, DANIEL DEKALB 4Brown Brown 5 10 M023 KOSSMAN, ERIC LAKE 4Blue None 6 03 M024 MIZERIC, ED DUPAGE 3Blue Brown 5 09 M022 OLDANI, MICHELLE WILL 3Gray Brown 5 04 F018 GRIGUS, LAURA COOK 2Brown Brown 5 08 F020 FURTEK, THOMAS DEKALB 4Brown Blond 5 10 M019 PRINCIS, CHRIS WILL 2Gray Brown 5 09 M021 MASUD, SHABANO KANKAKEE 2Brown Brown 5 06 F023 PEZOCK, SARAH MCHENRY 5Blue Brown 5 05 F018

Solution details:
STATUS
QUALITY
Approved

This question was answered on: Sep 18, 2020

Solution~0001005754.zip (25.37 KB)

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy from our tutoring website www.aceyourhomework.com (Deadline assured. Flexible pricing. TurnItIn Report provided)

STATUS

QUALITY

Approved

Sep 18, 2020

EXPERT

Tutor