Extract year from a date

[prehendere]

Hello!

I would like to extract the year of a date but i can't find of to do it.

I use proc sql to have the max et min date but i do not know how to get only the year and store them into macro variable

proc sql;
select max(date) as maxdate, min(date) as mindate
from projet.p;
quit;

%let maxdate = ..

%let mindate= ...

Could you help me please?

[novinosrin]

proc sql;
select year(max(date)) into :macro_year
 from projet.p;
quit;

%put &macro_year;

%let year=&macro_year;

%put &year;

[art297 · Accepted solution]

proc sql noprint;
  select year(max(date)),year(min(date))
    into :max_year, :min_year
      from projet.p
  ;
quit;

Art, CEO, AnalystFinder.com

[prehendere]

thank you!