Question 18.8

18.8 You have two data sets, ONE and TWO. ONE has a variable called ID, which is a charac- ter variable in the form 123-45-6789. TWO has a variable called ID, which is numeric (nine digits). You want to merge data sets ONE and TWO by the ID variables to create a new data set (BOTH) with ID (numeric and formatted with the SSN11. format), NAME, and SCORE. You can run the following short program to create the two data sets: DATA ONE ; INPUT @1 ID $11. @12 NAME $15 . ; DATALINES ;Problems 477 123-45-6789Jeff Smith 111-22-3333Stephen King 999-88-7777Jan Chambliss DATA TWO; INPUT @1 ID 9. @11 SCORE 3. ; DATALINES ; 999887777 100 123456789 65 111223333 59