If you use a "Create Table" as part of your proc sql, the actual variables in your SAS dataset will be reordered which I forgot to mention.  I should say that it really "re-creates" the SAS dataset RAM using the "CREATE TABLE" statement with the variables in the order you have in the "SELECT" statement.   PROC SQL;   CREATE TABLE RAM AS      SELECT NAME, S_DATE, N_DATE FROM RAM; QUIT;   If you run a "PROC CONTENTS" on RAM dataset before and after this SQL statement, you will notice the difference in the order of the variables in the SAS dataset using the VARNUM option as shown below:   PROC CONTENTS DATA=RAM VARNUM; RUN;   VARNUM shows the output variables list in the same order as they were defined in the SAS dataset, else I believe it will be alphabetic.   Hope this helps.... Good Luck...!!! ... View more