topic converting character date to numeric date in SAS Programming

converting character date to numeric date

TANMOY05 — Thu, 26 Mar 2020 16:16:05 GMT

i have a variable "date" which contains dates whose formats are in $11. But i want those in format YYYY-MM-DD.how to do this?

for example the dates are like Apr 01 2019, i want it to be like 2019-04-01.

Re: converting character date to numeric date

PaigeMiller — Thu, 26 Mar 2020 16:19:19 GMT

numeric_date=(input(char_date,anydtdte.));
format numeric_date yymmddd10.;

Re: converting character date to numeric date

novinosrin — Thu, 26 Mar 2020 16:26:34 GMT

Hi @TANMOY05 Please offer the credit to @PaigeMiller whose original solution is the right one. I would like to point a very minor typo that the default length that anydtdte. informat would read is 9 bytes. I am afraid the typo needs to be corrected by specifying 11. as suffix to make it work without errors

Example

data have;
char_date='Apr 01 2019';
sas_date=input(char_date,anydtdte11.);
format sas_date date9.;
run;

Re: converting character date to numeric date

PaigeMiller — Thu, 26 Mar 2020 16:33:54 GMT

That's very gracious, @novinosrin ! Thank you.

However, your code has a typo as well. I think it should say

format sas_date yymmddd10.;

otherwise the stated output desired is not achieved.

Re: converting character date to numeric date

novinosrin — Thu, 26 Mar 2020 16:39:31 GMT

Hahaha, I blame the Dunkin coffee. 🙂 or I must admit I am noticing my hair growing grey, joining the elders club .hahahahahahha

Re: converting character date to numeric date

TANMOY05 — Thu, 26 Mar 2020 18:31:59 GMT

haha, I would give credit to both of you. Both of your solutions helped to solve my problem. Both of you are great guys. 🙂