Level $2$

$11.$ Changing a Variable's Data Type

The data set orion.US$\_$newhire contains information about newly hired employees.

Partial orion.US$\_$newhire

$\backslash$table$[[$ID$,$Telephone,Birthday$],[,,],[120-012-40-4928,5467887,$OSDEC$1972],[120-012-83-3816,6888321,$O$3$MAY$1969],[120-341-44-0781,9418123,23$NOV$1976],[120-423-01-7721,7839191,28$JUN$1971]]$

Partial PROC CONTENTS Output of orion.US$\_$newhire

a$.$ Create a new data set from orion.US$\_$newhire.

Name the new data set US$\_$converted.

Remove the embedded hyphens in ID$.$

Convert ID to a numeric value.

Convert Telephone to character and place a $-($hyphen or dash$)$ between the third and fourth digits.

Convert Birthday to a SAS date value.

b$.$ Print US converted with an appropriate title and use PROC CONTENTS to check the variables