PLEASE COMPLETE ALL FOUR PROJECTS AND THEN EMAIL EVERYTHING REQUIRED IN ONE EMAIL BY EOD SUNDAY. MAKE SURE TO CC ALL TEAM MEMBERS. CAN DO IN GROUPS. THANKS, AND HAVE A GREAT HOLIDAY!
Project 1 – Navigating Enterprise Guide
File to be used – productinformation.sas7bdat
1. CreateanewprojectandaddtheproductinformationSASfile.
2. Characterize the data and limit the categories to 10 unique values. Export
the results as an html file called ‘results1_project1’.
3. Produce the data set attributes. Sort rows by variable order in the table.
Export the results as a pdf file called ‘results2_project1’.
4. Savetheprojectasfinal_project1andemailittome.
Computer Science Tutoring
Project 2 – Accessing/Importing SAS/DATA Files
Files to be used – customer_demographics.sas7bdat, customer_banking_info_promo.xlsx, customer_banking_info.csv
1. Assignalibrarycalled‘mylib’tothelocationwhereyousavedthe customer_demographics.sas7bdat file
2. Usetheserverlisttogoto‘mylib’andaddcustomer_demographicstothe project
3. Importcustomer_banking_info_promo.xlsx
a. Changethenameofthevariable‘customer_id2’to‘customer_id’ b. Changethelabelofthe‘poutcome’variableto‘PreviousOutcome’
4. Importcustomer_banking_info.csv
a. Readinonly200observations
b. Donotchangeanyvariablenames
c. Generalize the import step to run outside of Enterprise Guide
d. Optional–ExporttheSASdataset(itwillsaveyoutimeinProject4)
5. SaveprojectasFinal_Project2andemailittome.
程序代写 CS代考 加QQ: 749389476
Project 3 – Creating a Freq/List/Graph Report (do not replace results when doing this project)
File to be used – fitness.sas7bdat
1. Start a new project and import the fitness file (HINT: Do A and B and C before running. If not go back through Modify Tasks)
a. Produceone-wayfrequenciesforbothGenderandAge
b. ProduceaVerticalPlot
c. Title it ‘Frequencies of Gender and Age’.
2. CreateaListReport
a. ShowonlyName,Gender,Age,andPerformance
b. LabelName‘PatientsName’,Gender‘PatientsGender’,andAge
‘Patients Age’
c. Modify the results to show only the Females
3. CreateaBarandPieChart
a. CreateaBarchartforGenderbyPerformance(HINT:BarandBar
b. Which group has the largest total Performance?
c. Create a 3D Pie chart for Gender by Average Performance (HINT: Must change Sum to Average).
d. Which group Performs better (assume the higher score is better)
4. Save project as final_project3 and email it to me. Make sure to answer questions 3b and 3d. Can add a Note to the project or can put your answers in your email.
Programming Help, Add QQ: 749389476
Project 4 – Joining Tables
Files to be used – customer_demographics.sas7bdat and customer_banking_info.sas7bdat (created in Project 2. If you did not save it create again from customer_banking_info.csv and limit to 200 observations).
1. Opencustomer_demographics
2. Open(orcreate)customer_banking_info
3. Join the two tables by the corresponding customer numbers. Keep
customer numbers that are in customer_banking_info.
4. Keepvariablescustomer_id,Age,Job,Balance,andLoan.
5. SortbydescendingBalance
6. Droptherow(observation)ifMaritalStatusisdivorced
7. Runtoproducedataset
8. Modifytomakethefollowingchanges
a. Label Age ‘Age of Applicant’ and Job ‘Job of Applicant’
b. FormatBalancetoDollarw.d 9. Run
10. Save as final_project4 and email to me.