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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.