My statement is:
Proc SQL;
The create table temp as select distinct date from temp. The activity group by the date the order by the date desc limit 5; [I'm here to limit not (0, 5))
quit;
Proc print data=https://bbs.csdn.net/topics/temp;
run;

The output is:
Order is ok, but the date is still repeat, also could not choose the first five lines, to ask you a great god, and what reason is this?

CodePudding user response:

Can also is distinct and group by