Convert DATE9. to MMDDYY10

[neeloofar]

I am changing the current variable name of DOB (character) to BirthDt (numeric). The DOB variable is listed in DATE9. and I am trying to change it to MMDDYY10, but keep receiving an error. 

Here is my code:

DATA WORK.D;
SET Hyp.M( KEEP = SocSecNum Gender Eth Racial DOB
RENAME = ( SocSecNum = SSN
DOB = BirthDt));
LENGTH SSN $11
GenderCd 8
EthCd $1
RaceCd $1
EthRaceCd $3;

IF Gender = 'Male' THEN GenderCd = 1;
ELSE IF Gender = 'Female' THEN GenderCd = 2;

IF Eth = 'Hispanic or Latino' THEN EthCd = 'H';
ELSE IF Eth = 'Not Hispanic or Latino' THEN EthCd = 'N';

IF MISSING(Racial) = 1 THEN RaceCd = ' ';
ELSE IF Racial = 'Caucasian' THEN RaceCd = 'W';
ELSE IF Racial = 'African American' THEN RaceCd = 'B';
ELSE IF Racial = 'Other Race' THEN RaceCd = 'O';

IF Eth = 'Hispanic or Latino' THEN EthRaceCd = 'HIS';
ELSE IF Racial = 'African American' THEN EthRaceCd = 'NHB';
ELSE IF Racial = 'Caucasian' THEN EthRaceCd = 'NHW';
ELSE IF Racial = 'Other Race' THEN EthRaceCd = 'NHO';

BirthDt = INPUT(DOB, ANYDTDTE32.);
Format BirthDt MMDDYY10.;
RUN;

Here is my log:

Here's the first line of data I am working from:

 the 22JAN1974 to 01/22/1974

I'm not sure what I am missing, I suspect my variable is still not converting from character to numeric, but thought that the INPUT statement would do that... any advice would be great, thanks in advance!

 

[Kurt_Bremser · Accepted solution]

You cannot "rename" a variable to a different type.

Remove the complete RENAME= dataset option, and your code should work.

[neeloofar]

Thank you!

[Kurt_Bremser]

PS are you, by any means, working on the same project as @Krissy217 or @rodrima4 ? Your datasets look quite similar.