Data Transformations Commands

CAPITL

accumulates a capital stock from an investment series

CONVERT

changes a series from higher to lower frequency (stock or flow)

COPY

copies any variable

DELETE

deletes any variables

DIVIND

computes Divisia price and quantity indices

DUMMY

makes dummy variables from a series

GENR

creates a series using an algebraic formula

LENGTH

computes length of a TSP list (useful in PROCs)

NORMAL

normalizes a series (usually a price index, via division)

RANDOM

random number generator: normal (univariate or multivariate), uniform, Poisson, or empirical (bootstrap)

RENAME

renames a variable

SAMA

Seasonal adjustment using the moving average method

SET

modify a scalar or series/matrix element with an algebraic formula

SORT

sorting data

TREND

create linear trend variable (can be repeating like months)