topic Re: Help with date=mm/dd/yy in SAS Programming

Help with date=mm/dd/yy

hhchenfx — Sat, 09 Dec 2017 00:50:44 GMT

Hi,

I want to run this code but clearly I missed something.

Any help please?

Thank you.

data a; set timehour;
if date='11/29/17'd ;run;


but this one works

data a; set timehour;
if date='29NOV17'd ;
if date='29NOV2017'd ;
run;

Re: Help with date=mm/dd/yy

Tom — Sat, 09 Dec 2017 00:52:08 GMT

Doesn't look like you missed anything to me. Date literals must use the DATE format.

Re: Help with date=mm/dd/yy

hhchenfx — Sat, 09 Dec 2017 00:56:04 GMT

The format of the date is :MMDDYY8.

and here is the notice:

10581
10582 data a; set timehour;
10583 if date='11/29/17'd ;run;
-----------
77
ERROR: Invalid date/time/datetime constant '11/29/17'd.

ERROR 77-185: Invalid number conversion on '11/29/17'd.

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.A may be incomplete. When this step was stopped there were 0 observations
and 10 variables.
WARNING: Data set WORK.A was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

Re: Help with date=mm/dd/yy

ChrisBrooks — Sat, 09 Dec 2017 01:30:20 GMT

The format of your date constant is invalid - it has to be the day of the month, the three letter abbreviation of the month and the year (all in quotes) followed by a d. In your case that would be '29NOV2017'd

Re: Help with date=mm/dd/yy

Tom — Sat, 09 Dec 2017 01:39:27 GMT

If does not make any difference what format is attached to your variable. Date constants are always expressed using strings in a form that the DATE informat can recognize.

Dates are stored in SAS as the number of days since '01JAN1960'd. There are many formats that work with date values so that you can print them in a form that is understandable to you. If fact you can attach any numeric format to them.

565  data _null_;
566    date='29NOV2017'd ;
567    put (4*date) (date11. +1 mmddyy10. +1 yymmdd10. +1 comma7. ) ;
568  run;

29-NOV-2017 11/29/2017 2017-11-29  21,152

Re: Help with date=mm/dd/yy

Kurt_Bremser — Sat, 09 Dec 2017 07:44:18 GMT

SAS has only one syntax for date literals, the one that worked (either 2- or 4-digit years). If you want to compare your date with another date format, use either put() or input() functions:

if put(mydate,yymmddd10.) = '2017-12-08' then .....;
if mydate = input('2017-12-08',yymmdd10.) then ......;

Re: Help with date=mm/dd/yy

ballardw — Mon, 11 Dec 2017 22:43:30 GMT

However dates past year 9999 must use a 5 digit year in a literal and cannot exceed 31DEC20000.