Navigating Enterprise Guide
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.
2023-12-16