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?
proc sql noprint; select year(max(date)),year(min(date)) into :max_year, :min_year from projet.p ; quit;
Art, CEO, AnalystFinder.com
proc sql;
select year(max(date)) into :macro_year
from projet.p;
quit;
%put ¯o_year;
%let year=¯o_year;
%put &year;
proc sql noprint; select year(max(date)),year(min(date)) into :max_year, :min_year from projet.p ; quit;
Art, CEO, AnalystFinder.com
thank you!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.