extract years from dates

[Caro17]

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

[andreas_lds]

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

format dateVar dtYear4.;

in proc freq.

[PeterClemmensen · Accepted solution]

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;

[Kurt_Bremser]

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;