Read in date

[zimcom]

Hello community,

I am using 'C_date_new = input(C_date,anydtdte20.);' to read in a date variable (saved as text field) with date value of '18/10/24', but after I read in, the date was converted to '2024-10-18', is there another way to read in the text date field and make the correct conversion?

Appreciate your help and thank you!

[novinosrin]

is this a formatting problem rather?

data w;
C_date='18/10/24';
date_new = input(C_date,anydtdte20.);
format date_new yymmdd8.;
run;

[novinosrin · Accepted solution]

And why aren't you using 

date_new = input(C_date,yymmdd8.);

[ballardw]

---

@zimcom wrote:

Hello community,

I am using 'C_date_new = input(C_date,anydtdte20.);' to read in a date variable (saved as text field) with date value of '18/10/24', but after I read in, the date was converted to '2024-10-18', is there another way to read in the text date field and make the correct conversion?

Appreciate your help and thank you!

---

Are your values like '18/10/24' supposed to be YEAR Month Day? then you need to explicitly use a format that does that like yymmdds8.

ANYDTDTE has to guess when there is not an explicit 4 digit year and will usually assume that a YEAR is the last value generally.

And after the whole Y2K thing I have a lot of wonder why anyone is unsophisticated enough to start creating more issues by using two-digit years.

[zimcom]

Thank you @ballardw!

Thank you @novinosrin!