What are the different ways to create a table in proc SQL?

1.	What are the different ways to create a table in proc SQL?
Answer» DATA test; input id sal; cards; 1 300 1 200 3 900 2 300 2 400 3 700 2 100 3 800 ; run; PROC sort data =test out=test1; by id sal; run; proc sql; CREATE table test2(drop=number) as select , monotonic() as number from test1 GROUP by id having number=max(number); quit*;

Discussion