topic Re: Date formated as "Character" - can I translate it to for instance Date9 format? in SAS Programming

Date formated as "Character" - can I translate it to for instance Date9 format?

SasStatistics — Mon, 14 Jun 2021 14:33:35 GMT

In a table that I have loaded, the dates are written as character format. For instance:

201601 represents year 2020, date 16, month 1 [16 january 2020].

Is there any way I could transform this to a date format so I could do ordinary date calculations?

Thanks.

Re: Date formated as "Character" - can I translate it to for instance Date9 format?

ballardw — Mon, 14 Jun 2021 14:40:27 GMT

You will need to create a new variable

Since there is no standard date that does year day month you will need to pull that value apart to get the month, day and year values and use the MDY function to create the date value.

Do your values always use two digits for the day of month and month of the year? If not you are going to have to provide a lot more examples and what dates they actually represent.

Re: Date formated as "Character" - can I translate it to for instance Date9 format?

PaigeMiller — Mon, 14 Jun 2021 16:46:00 GMT

@SasStatistics wrote:

In a table that I have loaded, the dates are written as character format. For instance:

201601 represents year 2020, date 16, month 1 [16 january 2020].

Is there any way I could transform this to a date format so I could do ordinary date calculations?

So, first, let's clear up something, you don't need any particular format to do date calculations. You do need to have the date value represented as an integer (which is a numeric variable) whose value is the number of days since 01JAN1960.

Ignoring (for a minute) the valid concern expressed by @ballardw about your two-digit years, you can convert this to the a numeric date like this:

numeric_date = mdy(input(substr(char_date,5,2),2.),
    input(substr(char_date,3,2),2.),
    input(substr(char_date,1,2),2.)+2000);