Question: Problem 6 . You are provided with the following data set:Variables are day 1 , month 1 , year 1 , day 2 , month

Problem 6.
You are provided with the following data set:Variables are day1, month1, year1, day2, month2 and year2.I
Use MDY function to create the variable DOB (from day1 month1 year1 variables), and same to create the variable VISIT (from day2 month2 year2 variables). Calculate variable AGE1 by subtracting DOB from VISIT. Round it to the nearest year (ie use ROUND function). Calculate variable AGE2 by subtracting DOB from today's date (use appropriate function(s)), and return only integer part of the age.
Don't forget the output formats for date variables.
 Problem 6. You are provided with the following data set:Variables are

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!