@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);
... View more