Hi,
Im trying to change the date from dd/mm/yyyy to yyyy but my code doens't work. The field presents the data dd/mm/yyyy but the column properties show different.
The column properties are -
length 8
format ddmmyy
informat 10.
My code -
proc sql;
create table work.green as
select
curr_term_exp as maturity format=yyyy.
from work.green;
quit;
Any ideas please?
Try yearpart() function.
proc sql;
create table work.green as
select
curr_term_exp as maturity format=year.
from work.green;
quit;
data green;
format curr_term_exp ddmmyy10.;
informat curr_term_exp ddmmyy10.;
input curr_term_exp $;
cards;
1/1/2013
1/1/2014
1/1/2015
;
run;
proc sql;
select curr_term_exp as maturity format=year4. from work.green;
quit;
If you want to display it differently then just attach the YEAR format.
If you want to make a new variable that only has year then use the YEAR() function.
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.