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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.