topic Re: Character to Date format in SAS Programming

Character to Date format

Eugenio211 — Mon, 15 Aug 2022 19:00:42 GMT

Hello,

how can we translate a character into date format,

here is an example of my data: 2022-01-01 04:12:30.9808034 -05:00

thank you.

Re: Character to Date format

ballardw — Mon, 15 Aug 2022 19:21:20 GMT

If you truly only need the date portion this is probably easiest:

data example;
   x= "2022-01-01 04:12:30.9808034 -05:00";
   y= input(x,yymmdd10.);
   format y yymmdd10.;
run;

If you need the time and time zone info you need to get used to dealing with SAS terminology of date, time and datetime as DATE values use different units, days, than time and datetime values which use seconds.

https://communities.sas.com/t5/SAS-Communities-Library/Working-with-Dates-and-Times-in-SAS-Tutorial/ta-p/424354 has a PDF with much information about dates.

Re: Character to Date format

Reeza — Tue, 16 Aug 2022 16:51:14 GMT

Not being pedantic, but this is a datetime, not a date and SAS treats them differently.

A date is stored as the number of days from January 1, 1960.

A datetime is stored as the number of seconds from January 1, 1960.

Do you want a date or datetime read in?

Here's a great, but longer and in depth, reference for dates and times in SAS
https://communities.sas.com/t5/SAS-Communities-Library/Working-with-Dates-and-Times-in-SAS-Tutorial/ta-p/424354

@Eugenio211 wrote:

Hello,

how can we translate a character into date format,

here is an example of my data: 2022-01-01 04:12:30.9808034 -05:00

thank you.