Hi,
Can a order by followed by a negative date column?
I have a code copied from somewhere like
PROC SQL; | |
CREATE TABLE mcapData AS | |
SELECT a.permno, | |
a.date, | |
a.mcap | |
FROM retData AS a | |
ORDER BY a.permno, |
|
-a.date; | |
QUIT; |
Is that a negative sign or just some error?
It is just a trick which should be written
BY a,permno, a.date DESC;
Thanks! You mean I can write like that but better use DESC?
DESC states what you want more clearly. The next person looking at the query will not wonder what you really meant to do.
Could you tell me whether SAS allows to use like that?
Yes, you can ORDER BY a SQL expression. Check the Documentation.
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.
Hi,Thank you very much ! I understand it now.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.