Solved: Change the DATE format from string - SAS Support Communities

🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Calcite | Level 5

Calcite | Level 5

Change the DATE format from string

Posted 09-08-2021 09:16 PM (1646 views)

Could anyone help me to change to the DATE format from the character? I have added the first two observations for the character variable:

10/9/2020, 12:11 AM

10/28/2020, 1:04 PM

Thank you very much.

1 ACCEPTED SOLUTION

Accepted Solutions

Super User

Super User

Re: Change the DATE format from string

Posted 09-08-2021 09:23 PM (1629 views) | In reply to Friend1

dateVar = input(scan(charVar, 1, ","), mmddyy10.);
format dateVar date9.;

View solution in original post

2 REPLIES 2

Super User

Super User

Re: Change the DATE format from string

Posted 09-08-2021 09:23 PM (1630 views) | In reply to Friend1

dateVar = input(scan(charVar, 1, ","), mmddyy10.);
format dateVar date9.;

Calcite | Level 5

Calcite | Level 5

Re: Change the DATE format from string

Posted 09-08-2021 09:28 PM (1607 views) | In reply to Reeza

Thank you, Reeza for your help.

744853-sas-innovate-data-ai (1).jpg

Catch up on SAS Innovate 2026

Dive into keynotes, announcements and breakthroughs on demand.

Explore Now →