topic Re: Read in date in SAS Programming

Read in date

zimcom — Fri, 11 Jan 2019 17:08:22 GMT

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!

Re: Read in date

novinosrin — Fri, 11 Jan 2019 17:17:21 GMT

is this a formatting problem rather?


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

Re: Read in date

novinosrin — Fri, 11 Jan 2019 17:18:23 GMT

And why aren't you using

date_new = input(C_date,yymmdd8.);

Re: Read in date

ballardw — Fri, 11 Jan 2019 17:25:55 GMT

@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.

Re: Read in date

zimcom — Fri, 11 Jan 2019 17:31:30 GMT

Thank you @ballardw!

Thank you @novinosrin!