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,$O$5$DEC$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 IS$\_$converted with an appropriate title and use PROC CONTENTS to check the variables types$\mathrm{.}5\mathrm{.}5$ Converting Variable Type

$5-81$

Partial US$\_$converted $(10$ Total Observations$)$

$\backslash$table$[[$US New Hires$],[$ID$,$Telephone,Birthday,$],[,,,],[120012404928,546-7887,4722,],[120012833816,688-8321,3410,],[120341440781,941-8123,6171,],[120423017721,783-9191,4196,]]$

Partial PROC CONTENTS Output

$\backslash$table$[[$Variables in Creation Order$],[$#$,$Variable,Type,Len$],[1,10,\backslash$table$[[$Num$]],8],[2,$Telephone,Char,$8],[3,$Birthday,Num,$8]]$

End of Exercises