Greetings Expert, Please, see attached. Enclosed are directions you need to complete the project successfully. The project is due on February 12th, 2022, before noon EST.
Please, use the both URL link and the loggin information to complete the assignment.
URL: https://welcome.oda.sas.com/login
Username: [email protected]
Password: [email protected]!
Then, once succesfully login you will see I’ve create for you the Week5 folder with the four data sets attachments you need to complete the project.
Which are called, countries.sas7bdat, unitedstates.sas7dbat, uscitycoords.sas7dbat, and postalcodes.sas7dbat.
Save them to the Week5 folder:
\SASUniversityEdition\myfolders\Week5.
Do not change the directory. Otherwise, the directory in the problems will not work.
Project 5 consists of three problems. Complete each of the three problems as follows:
Problem 1
Using data set countries,
1. Create a table with Continent, sum of Population, and number of the Countries;
2. Sub-set a data set from Continent that only includes the Continents with more than 40 countries, then, create a table with Continent, sum of Population, and number of the Countries;
Problem 2
Using data sets unitedstates, postalcodes, uscitycoords, create a table containing all States in US with columns of State, State_code, Capital, Latitude, and Longitude.
Problem 3
Compare DATA step match-merges with PROC SQL joins, and see how they work similarly and differently. Create a table with columns of FLD_ID, Farmer, and Crop by joining below two tables together using data step and PROC SQL joins
Submission
Your submission will include the following files.
- Name your SAS codes as ‘project5.sas’, and submit it.
- Save the results into a pdf file named ‘project5_results.pdf‘, and submit it
