Stata 15 help for order

[D] order -- Reorder variables in dataset

Syntax

order varlist [, options]

options Description ------------------------------------------------------------------------- first move varlist to beginning of dataset; the default last move varlist to end of dataset before(varname) move varlist before varname after(varname) move varlist after varname alphabetic alphabetize varlist and move it to beginning of dataset sequential alphabetize varlist keeping numbers sequential and move it to beginning of dataset -------------------------------------------------------------------------

Menu

Data > Data utilities > Change order of variables

Description

order relocates varlist to a position depending on which option you specify. If no option is specified, order relocates varlist to the beginning of the dataset in the order in which the variables are specified.

Options

first shifts varlist to the beginning of the dataset. This is the default.

last shifts varlist to the end of the dataset.

before(varname) shifts varlist before varname.

after(varname) shifts varlist after varname.

alphabetic alphabetizes varlist and moves it to the beginning of the dataset. For example, here is a varlist in alphabetic order: a x7 x70 x8 x80 z. If combined with another option, alphabetic just alphabetizes varlist, and the movement of varlist is controlled by the other option.

sequential alphabetizes varlist, keeping variables with the same ordered letters but with differing appended numbers in sequential order. varlist is moved to the beginning of the dataset. For example, here is a varlist in sequential order: a x7 x8 x70 x80 z.

Examples

Setup . webuse auto4

Describe the dataset . describe

Move make and mpg to the beginning of the dataset . order make mpg

Describe the dataset . describe

Make length be the last variable in the dataset . order length, last

Describe the dataset . describe

Make weight be the third variable in the dataset . order weight, before(price)

Describe the dataset . describe

Alphabetize the variables . order _all, alphabetic

Describe the dataset . describe


© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index