SAS: rearrange field order in data step?

Question

In SAS 9, how can I in a simple data step, rearrange the order the field. Data set2; /*Something probably goes here*/ set set1; run; So if set1 has the following fields: Name Title Salary A Chief 40000 B Chief 45000 Then I can change the field order of set2 to: Title Salary Name Chief 40000 A Chief 45000 B Thanks, Dan

Answer 1

data set1;

input Name $ Title $ Salary;

datalines;

A Chief 40000

B Chief 45000

;

run;

data set2;

retain Title Salary Name;

set set1;

run;