topic Re: problem with if statement on dates in SAS Programming

problem with if statement on dates

sasprogramming — Tue, 25 May 2021 05:25:14 GMT

data moomoo;
set moo;
if DATE= '2019-04-30'd	 then  dummy= 1;
run;

 1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 72         
 73         data moomoo;
 74         set moo;
 75         if PORTFOLIO_DATE = '2019-04-30'd then  dummy= 1;
                                _____________
                                77
 ERROR: Invalid date/time/datetime constant '2019-04-30'd.
 ERROR 77-185: Invalid number conversion on '2019-04-30'd.
 
 77         run;
 
 NOTE: The SAS System stopped processing this step because of errors.
 WARNING: The data set WORK.MOOMOO may be incomplete.  When this step was stopped there were 0 observations and 8 variables.
 WARNING: Data set WORK.MOOMOO 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
       
 
 78         
 79         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 92

Why does the if statement not work? I have tried almost everything in regards to date formats.

Re: problem with if statement on dates

ballardw — Tue, 25 May 2021 05:30:03 GMT

The date value must be in one of the forms the DATE. format uses such as "30Apr2019"d.

There are just too many random sequences of digits to provide all of them as date literal values, partially because some of them are just plain too ambiguous. Consider, what date would '01-02-03' mean?

Re: problem with if statement on dates

Oligolas — Tue, 25 May 2021 11:27:50 GMT

Hi,

use

'30Apr2019'd

mdy(04,30,2019)