Date Format

[#1]

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?

[RW9]

Try yearpart() function.

[stat_sas]

proc sql;

create table work.green as

select

curr_term_exp as maturity format=year.

from work.green;

quit;

[Hima]

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;

[Tom]

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.