Overview
When creating dataset for CDISC or other standards, it is important to have the order of the variables listed in a particular order.  This is important in that it will show up in documentation and it will affect how users will view the data.  Usually the order will have the key fields or fields that have been sorted followed by the rest of the variables in alphabetically order.  The ORDERVAR will automate this process of ordering your variables while also updating your data with values such as related domain. 
 
ORDERVAR Options
The ORDERVAR screen allows you to select the data and related information which is going to be ordered.  The data flow for this tool is shown here.

Source Data

CDISC Builder ORDERVAR

Updated Data with order

The options available for selecting data and options for ORDERVAR are:

• Source Data - This is the location of the dataset that is going to be used to have the variables re-ordered.
• Datasets - Source datasets that are used to for ORDERVAR.
• Preview - A preview of the first 100 observations of the data that is selected.
• Variables - All the variables in the selected datasets.  This will be listed alphabetically which is the order in which it will be ordered.
• Keys - The key variables are usually the sorted by variables.  These will be listed first in the order of variables.  You can determine the keys and the order which you require them to be.
• Related Domain - The related domain to CDISC that the dataset is related to.
• Base Code - The path and name of the SAS program that can be optionally created to store the logic of the order variable.
• Save Code - This will save the selections that have been made into a SAS macro that can be saved and executed outside of the graphical user interface for ORDERVAR.

The ORDERVAR only be applied to one dataset at a time since the keys and other options are different.