topic Re: Changing the date format in New SAS User

Changing the date format

Sandeep77 — Fri, 26 May 2023 10:14:04 GMT

Hi all,

I have a data set which had date format 01/12/2000:00:00:00. I want to change it to 01/12/2000 format. I used the datepart function but the date I am getting is now in 01DEC2000 format. Can you suggest how to get the output in 01/12/2000 format?

Proc sql;
create table Linked_for_CF as 
select debt_code as accountnumber, 
 AddressLine1, 
AddressLine2, 
AddressLine3, 
AddressLine4, 
Postcode, 
Title, 
Forename, 
Surname,
Datepart (Dr_DOB) format date9. as Dateofbirth 
from Linked_acc;
quit;

Re: Changing the date format

PaigeMiller — Fri, 26 May 2023 10:16:24 GMT

After you use the datepart function, assign format mmddyys10.

Re: Changing the date format

Sandeep77 — Fri, 26 May 2023 10:19:42 GMT

Thank you. It worked. I actually wanted it in ddmmyys10. format. Thanks again.

Re: Changing the date format

PaigeMiller — Fri, 26 May 2023 10:28:07 GMT

Adding ... don't assign it format DATE9. if you want some other format.