topic Formatting Date in SAS Programming

Formatting Date

parmis — Fri, 06 Jul 2018 14:45:06 GMT

Hello,

I have a field which contains both time and date, ex: "2018-10-20 10:30"

Does anyone know how I can select only date with condition like the following:

proc sql;

select date_time as date between '2018-01-01' and '2018-01-31"

Thank you!

Re: Formatting Date

pau13rown — Fri, 06 Jul 2018 14:53:22 GMT

datepart: http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000245883.htm

i don't know why you'd need to use the condition, extract the date, keep what you want, discard what you don't

Re: Formatting Date

Reeza — Fri, 06 Jul 2018 14:53:52 GMT

Whats the type and format of the datetime variable?

If it's a number with a datetime format then you can use:

where datepart(date) betweeen '01Jan2018'd and '31Jan2018'd;

@parmis wrote:

Hello,

I have a field which contains both time and date, ex: "2018-10-20 10:30"

Does anyone know how I can select only date with condition like the following:

proc sql;

select date_time as date between '2018-01-01' and '2018-01-31"

Thank you!

Re: Formatting Date

Tom — Fri, 06 Jul 2018 14:57:23 GMT

To compare with datetime values you need to use datetime literals.

select date_time 
  from have 
  where date between "01JAN2018:00:00"dt and "31DEC2018:23:59"dt 
;

Or convert it to a date and use date literals.

select date_time 
  from have 
  where datepart(date) between "01JAN2018"d and "31DEC2018"d 
;

Note that the literals must use a format that is recognized by the DATE (or DATETIME) informat.

Re: Formatting Date

parmis — Thu, 12 Jul 2018 12:04:42 GMT

Thank you very much