Hello, I have a dataset that is sorted by only an ID variable. However, I would like to re-sort the data ID and Date of BIRTH and SEX in that order. Can I use Proc SQL to store the resorted data in a new table ? Or will the order by be used only to display the results? I am interested in resorting and saving the data in a new table, so any hints will help. I know it is easy to do this using Proc Sort in the Data Step Thanks Proc SQL; create table NEW as select * from OLD order by ID, DOB, SEX; quit;
... View more
