SAS Using Functions to Manipulate Data
Budget: $10 – $30 USD
1. Use addresses data in cert library to create the new data below with 3 new variables zip code, address, and phone number. Use at least 4 unique SAS functions to create the new variables. Please note that only a portion of data is shown below.
2. Use agencyemp data in cert library to create the new data below with 1 new variable name. Use at least 4 unique SAS functions to create the new variable.
3. Use survey data in cert library to create the new data below with 5 new variables average of item1-10, minimum of all items, maximum of all items, standard deviation of all items (rounded with 2 decimal places), and average of item1-10 (rounded up to the next integer). Use at least 6 unique SAS functions to create the new variables.
4. Use reps data in cert library to create the new data below with 4 new variables last 4 digits of phone number, age at hiring (in years), number of months as an employee (as of day homework is done), and last name. Use at least 4 unique SAS functions to create the new variables.
5. Use dates data in cert library to create the new data below with 1 new variable date of game. Use at least 1 unique SAS function to create the new variable.
2. Use agencyemp data in cert library to create the new data below with 1 new variable name. Use at least 4 unique SAS functions to create the new variable.
3. Use survey data in cert library to create the new data below with 5 new variables average of item1-10, minimum of all items, maximum of all items, standard deviation of all items (rounded with 2 decimal places), and average of item1-10 (rounded up to the next integer). Use at least 6 unique SAS functions to create the new variables.
4. Use reps data in cert library to create the new data below with 4 new variables last 4 digits of phone number, age at hiring (in years), number of months as an employee (as of day homework is done), and last name. Use at least 4 unique SAS functions to create the new variables.
5. Use dates data in cert library to create the new data below with 1 new variable date of game. Use at least 1 unique SAS function to create the new variable.