ERROR: Function DATEPART requires a numeric expression as argument 1.ERROR: Expression using less than or equal (<=) has components that are of different data types.ERROR: Function DATEPART requires a numeric expression as argument 1.ERROR: Expression using less than or equal ...
if i use substr function, new_date come out -> "26FEB1781" data test3;set test;format new_date date9.;new_date=substr(orig_date,1,7);run; 0 Likes PaigeMiller Diamond | Level 26 Re: datepart Posted 05-13-2019 11:43 AM (8630 views) | In reply to woo How about this: dat...
if i use substr function, new_date come out -> "26FEB1781" data test3;set test;format new_date date9.;new_date=substr(orig_date,1,7);run; 0 Likes PaigeMiller Diamond | Level 26 Re: datepart Posted 05-13-2019 11:43 AM (8805 views) | In reply to woo How about this: dat...
if i use substr function, new_date come out -> "26FEB1781" data test3;set test;format new_date date9.;new_date=substr(orig_date,1,7);run; Your original code was correct. Post the log and indicate why you think it's incorrect. If there are warnings in the log it's likely becau...
Invalid (or missing) arguments to the DATEPART function have caused the function to return a missing Posted 09-19-2019 11:34 AM (1695 views) What is the effect of the above error/warning as far as the rest of the data is concerned once this error is encountered? Does ...
Since the original PDDATE is datetime you will want to include the DATEPART() function. WHERE datepart(SOURCE.PDDATE) BETWEEN '01JAN2024'd AND '31JAN2024'd Or perhaps use DATETIME constants instead. If the values of PDDATE include non-zero time of day parts then be careful. WHERE '0...
Posted 12-20-2012 05:12 PM (2540 views) | In reply to Data_Detective_23219 I've had to do this a lot myself so here is a macro you can feed the list from the above SQL into and it doesn't use arrays, just statements using the DATEPART function: macro Util_Convert_DT_Columns...
But first off, the today() function in your INTNX function should not be in quotation marks 🙂 The DATA to DATA Step MacroBlog: SASnrd 0 Likes Reply SkandaPannu Calcite | Level 5 Re: datepart and intnx in oracle pass through using proc sql Posted 11-21-2017 03:3...