topic Re: extract years from dates in SAS Programming

extract years from dates

Caro17 — Wed, 01 Jul 2020 10:07:56 GMT

Hey,

I have many dates like this: 01.01.2018:00:00:00’. Now I want to see just the years in a proc freq. How can I do this?

Thanx a lot!

Caro

Re: extract years from dates

andreas_lds — Wed, 01 Jul 2020 10:20:43 GMT

This doesn't look like a date, but a datetime-value. Try

format dateVar dtYear4.;

in proc freq.

Re: extract years from dates

PeterClemmensen — Wed, 01 Jul 2020 10:22:24 GMT

Use the Dtyear. format like this

data have;
    do datetime = 1 to 1e9 by 1e4;
        x = 1;
        output;
    end;
    format datetime datetime20.;
run;

proc freq data=have;
    tables datetime;
    format datetime dtyear.;
run;

Re: extract years from dates

Kurt_Bremser — Wed, 01 Jul 2020 10:24:39 GMT

Just assign the DTYEAR4. format to your date variable, and PROC FREQ will automatically group by years:

data have;
input datetime :e8601dt19.;
format datetime nldatms19.;
datalines;
2018-01-01T00:00:00
2018-01-01T00:00:00
2019-01-01T00:00:00
;

proc freq data=have;
format datetime dtyear4.;
tables datetime;
run;