03-19-2016 11:44 PM
Can a order by followed by a negative date column?
I have a code copied from somewhere like
|CREATE TABLE mcapData AS|
|FROM retData AS a|
Is that a negative sign or just some error?
03-20-2016 12:47 AM
Added explanation. SAS dates are just numbers. Under the hood, the date 01JAN2010 is just 18263. So -date is also just a number; -18263 when viewed as a date is 31DEC1909. When SAS is sorting by a SAS date, it is in fact just sorting numbers.
Hope this helps.