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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.