topic Re: Extract year from a date in SAS Programming

Extract year from a date

prehendere — Thu, 28 Dec 2017 20:28:19 GMT

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 — Thu, 28 Dec 2017 20:42:17 GMT

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

%put &macro_year;

%let year=&macro_year;

%put &year;

art297 — Thu, 28 Dec 2017 21:20:24 GMT

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

Art, CEO, AnalystFinder.com

prehendere — Thu, 28 Dec 2017 22:14:41 GMT

thank you!