Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit

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

Create a new project and add the productinformation SAS file.

Characterize the data and limit the categories to 10 unique values.  Export the results as an html file called ‘results1_project1’.

Produce the data set attributes.  Sort rows by variable order in the table. Export the results as a pdf file called ‘results2_project1’.

Save the project as final_project1 and email it to me.

Project 2 – Accessing/Importing SAS/DATA Files

Files to be used – customer_demographics.sas7bdat, customer_banking_info_promo.xlsx, customer_banking_info.csv

Assign a library called ‘mylib’ to the location where you saved the customer_demographics.sas7bdat file

Use the server list to go to ‘mylib’ and add customer_demographics to the project

Import customer_banking_info_promo.xlsx

Change the name of the variable ‘customer_id2’ to ‘customer_id’

Change the label of the ‘poutcome’ variable to ‘Previous Outcome’

Import customer_banking_info.csv

Read in only 200 observations

Do not change any variable names

Generalize the import step to run outside of Enterprise Guide

Optional – Export the SAS dataset (it will save you time in Project 4)

Save project as Final_Project2 and email it to me.

Project 3 – Creating a Freq/List/Graph Report

(do not replace results when doing this project)

File to be used – fitness.sas7bdat

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)

Produce one-way frequencies for both Gender and Age

Produce a Vertical Plot

Title it ‘Frequencies of Gender and Age’.  

Create a List Report

Show only Name, Gender, Age, and Performance

Label Name ‘Patients Name’, Gender ‘Patients Gender’, and Age ‘Patients Age’

Modify the results to show only the Females

Create a Bar and Pie Chart

Create a Bar chart for Gender by Performance (HINT: Bar and Bar Height).

Which group has the largest total Performance?

Create a 3D Pie chart for Gender by Average Performance (HINT: Must change Sum to Average).

Which group Performs better (assume the higher score is better)

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.

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).

Open customer_demographics

Open (or create) customer_banking_info

Join the two tables by the corresponding customer numbers.  Keep customer numbers that are in customer_banking_info.

Keep variables customer_id, Age, Job, Balance, and Loan.

Sort by descending Balance

Drop the row (observation) if Marital Status is divorced

Run to produce dataset

Modify to make the following changes

Label Age ‘Age of Applicant’ and Job ‘Job of Applicant’

Format Balance to Dollarw.d

Run

Save as final_project4 and email to me.