Convert DATE9. to MMDDYY10

neeloofar — Thu, 10 Dec 2020 15:11:53 GMT

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!

Re: Convert DATE9. to MMDDYY10

Kurt_Bremser — Sat, 07 Nov 2020 06:38:53 GMT

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

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

Re: Convert DATE9. to MMDDYY10

Kurt_Bremser — Sat, 07 Nov 2020 07:07:07 GMT

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

Re: Convert DATE9. to MMDDYY10

neeloofar — Sat, 07 Nov 2020 17:47:41 GMT

Thank you!

topic Re: Convert DATE9. to MMDDYY10 in New SAS User

Convert DATE9. to MMDDYY10

Re: Convert DATE9. to MMDDYY10

Re: Convert DATE9. to MMDDYY10

Re: Convert DATE9. to MMDDYY10