topic Re: To get only Year from DATETIME20. format in SAS Programming

To get only Year from DATETIME20. format

BIDD — Fri, 08 Jun 2018 08:02:06 GMT

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.

Re: To get only Year from DATETIME20. format

Kurt_Bremser — Mon, 29 Aug 2022 13:26:00 GMT

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.

Re: To get only Year from DATETIME20. format

PeterClemmensen — Fri, 08 Jun 2018 08:04:59 GMT

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

Re: To get only Year from DATETIME20. format

BIDD — Fri, 08 Jun 2018 08:35:12 GMT

great, thanks for your help. it worked

Re: To get only Year from DATETIME20. format

BIDD — Fri, 08 Jun 2018 08:40:31 GMT

thanks for that, it worked

Re: To get only Year from DATETIME20. format

katkarparam — Fri, 08 Jun 2018 09:00:12 GMT

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;

Re: To get only Year from DATETIME20. format

BIDD — Fri, 08 Jun 2018 09:10:11 GMT

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

Re: To get only Year from DATETIME20. format

Kurt_Bremser — Fri, 08 Jun 2018 09:15:34 GMT

@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.

Re: To get only Year from DATETIME20. format

BIDD — Fri, 08 Jun 2018 09:17:11 GMT

Will check on Monday thanks for ur help...

Re: To get only Year from DATETIME20. format

katkarparam — Fri, 08 Jun 2018 09:29:55 GMT

Yes, you are right. data test;

x1 = '01jan2018xxxxxxxxxxx'd;

format x1 yymmddd10.;

run;

Output dataset contain

Obs x1

1 2018-01-01

Re: To get only Year from DATETIME20. format

katkarparam — Fri, 08 Jun 2018 11:04:53 GMT

I will let you know..

Re: To get only Year from DATETIME20. format

hnb_matt_d — Fri, 18 Sep 2020 20:41:02 GMT

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.