topic Re: Date Format in SAS Programming

Date Format

anonymous_user — Wed, 17 Sep 2014 13:33:47 GMT

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?

Re: Date Format

RW9 — Wed, 17 Sep 2014 14:01:44 GMT

Try yearpart() function.

Re: Date Format

stat_sas — Wed, 17 Sep 2014 14:07:08 GMT

proc sql;

create table work.green as

select

curr_term_exp as maturity format=year.

from work.green;

quit;

Re: Date Format

Hima — Wed, 17 Sep 2014 15:18:20 GMT

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;

Re: Date Format

Tom — Wed, 17 Sep 2014 15:32:31 GMT

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.