YYYMMDD where the field reads as a date

[Q1983]

data test;

borrower_dob = 25AUG1947:00:00:00.000000;

BORROWER_DOB1 = BORROWER_DOB;
format BORROWER_DOB1 yyyymmdd10.;

run;

I get the results truncated with a bunch of ........... in the field

Desired result is 19470825

[tom_grant]

data test;

borrower_dob = '25AUG1947:00:00:00.000000'dt;

BORROWER_DOB1 = datepart(BORROWER_DOB);
format BORROWER_DOB1 yymmdd10.;

run;

You have to tell SAS it is a datetime value (in-close in quotes & add dt) then use datepart function to pull out the date.  The correct format is yymmdd10.

[tom_grant · Accepted solution]

Whoops - correct format is yymmddn.