topic Re: Date field - creating in SAS Enterprise Guide

Date field - creating

carmendee — Wed, 09 Sep 2015 19:44:07 GMT

How do I create a date field with a value using a CASE WHEN statement? Here is my statement:

CASE WHEN t1.year = 24 then '01MAY2015:00:00:00'

END

Re: Date field - creating

Tom — Wed, 09 Sep 2015 20:02:11 GMT

You probably want to use a date (or as in your example a datetime) literal. If you want a DATE then use '01MAY2015'D if you want a DATETIME value then use '01MAY2015:00:00:00'DT. You could also use a function call such as MDY(5,1,2015). You should also attach a format to the variable so the value will be displayed properly.

PROC SQL; 
  CREATE TABLE WANT AS 
    SELECT *
         , CASE WHEN t1.year = 24 THEN '01MAY2015:00:00:00'dt
          END AS DATETIME FORMAT=DATETIME20.
    FROM HAVE
  ;

Re: Date field - creating

carmendee — Wed, 09 Sep 2015 20:01:59 GMT

Problem - the date returned is today's date. Statement:
CASE WHEN t1.SCHOOL_YEAR_ID = 18 THEN DATETIME('01MAY2015:00:00:00'DT)
END

Re: Date field - creating

Tom — Wed, 09 Sep 2015 20:04:17 GMT

DATETIME() function just returns the current date time. Use just the literal or another function such as INPUTN().

Re: Date field - creating

carmendee — Wed, 09 Sep 2015 20:05:21 GMT

Oops. Removed my DATETIME and reran. Thanks Tom.