topic Re: YYYMMDD where the field reads as a date in SAS Software for Learning Community

YYYMMDD where the field reads as a date

Q1983 — Wed, 22 Feb 2023 20:50:23 GMT

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

Re: YYYMMDD where the field reads as a date

tom_grant — Wed, 22 Feb 2023 21:09:53 GMT

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.

Re: YYYMMDD where the field reads as a date

tom_grant — Wed, 22 Feb 2023 21:14:20 GMT

Whoops - correct format is yymmddn.