To get only Year from DATETIME20. format

[BIDD]

Hi Friends,

I need your help in year format.

I have a data set which has got commencement_dt as 23MAY2013:00:00:00 which is in DATETIME20. format, from the same commencement_dt i want to get only year. Is there a way where i can get only year format or by creating another variable only for year to appear.

Appreciate your help.

[Kurt_Bremser · Accepted solution]

Use the datepart() and year() functions:

data have;
input commencement_dt :datetime20.;
format commencement_dt datetime20.;
cards;
23MAY2013:00:00:00
;
run;

data want;
set have;
commencement_year = year(datepart(commencement_dt));
run;

You can also use the DTYEAR format to display just the year from a datetime value in SAS -- no need to create a different variable.

[BIDD]

thanks for that, it worked

[PeterClemmensen]

data _null_;
   dt="23MAY2013:00:00:00"dt;
   year=year(datepart(dt));
   put year=;
run;

[BIDD]

great, thanks for your help. it worked

[katkarparam]

we can use Year() fun to extract the year from sas date value.

Data    Demo;

Var1='21feb2002:22:23:00'd;

var2=year( var1);

run;

[BIDD]

Hi, thanks for that... My requirement is;i have over 1000 records on
commencement_date variable, if you can provide me the solution to change at
one shot for all rather than one date.. It would be great ...Sorry I forgot
to mention that in the post

[Kurt_Bremser]

@katkarparam only wanted to show that SAS accepts any longer string as a date literal, as long as the start is a SAS date:

data test;
x1 = '01jan2018xxxxxxxxxxx'd;
format x1 yymmddd10.;
run;

For existing data, use a data step similar to mine.

[BIDD]

Will check on Monday thanks for ur help...

[katkarparam]

Yes, you are right. data test;

x1 = '01jan2018xxxxxxxxxxx'd;

format x1 yymmddd10.;

run;

Output dataset contain

Obs          x1

1             2018-01-01

[katkarparam]

I will let you know..

[hnb_matt_d]

Realize this is a while following the original post, but I got this to work in a select proc sql statement with an existing datetime20. formatted variable in a table:

year(datepart(table_cases.item_date)) as ITEM_YEAR

It's a numerical variable, but it worked.