topic Re: I can not extract part of a date in SAS Enterprise Guide

I can not extract part of a date

fabiopjr — Fri, 02 Sep 2016 19:51:21 GMT

I have this table with some fields of type date (example, column DAT_INICIO_ENTREGA_PROPOSTA)

When I try to extract the year (or month, or day), the result is null (.)

Help me.

Reeza — Fri, 02 Sep 2016 20:01:40 GMT

Its hard to see because your pictures don't show clearly enough but I think you have a datetime not a date variable.

The functions Year/Month/Day require a date. To convert your datetime to a date use the DATEPART() function.

Year(datepart(date_var))

fabiopjr — Fri, 02 Sep 2016 20:06:16 GMT

Thanks.