Transform.pdf
Transform expression values
Overview
This module transforms all values in an Omic Data object, using one of the available Transformation methods
Input Data Requirements
It works on Omic data types.
To run this module, type MicroArray  Preprocess  Transform.
General Options
Input/Output
 Project & Data: The window includes a dropdown box to select the Project and Data object to be filtered.
 Variables: Selections can be made on which variables should be included in the filtering (options include All variables, Selected variables, Visible variables, and Customized variables (select any pregenerated Lists)).
 Observations: Selections can be made on which observations should be included in the filtering (options include All observations, Selected observations, Visible observations, and Customized observations (select any pregenerated Lists).
 Output name: The user can choose to name the output data object.
Options
 The user can Add a constant to the transformed data, or Multiply by a constant when transforming the data.
 Array Studio allows the user to censor the value if less than a specified value or greater than a specified value. For microarray data, this could be important, as log transforming a value of <1 will result in a negative number. This will prevent that from occurring.
 Transformation methods available include: No transformation, Log2, SLog2, Exp2, SExp2,Nexp2, Log10, NLog10, Exp10, NExp10, Log, Exp, and Percentile.
 User can also mark values as missing of it is less or greater than a cutoff.
 Finally, the user has the option of performing a variety of numeric calculations, using the values for each chip in a numeric design column (Divide, Divided by, Multiply, Add, Subtract, and Subtracted By). This will only be active if the dataset in question contains design columns that have a numeric column type.
The Output type will either be set to Change input data, in which case the original Data object will be permanently changed, or if the user enters a name in the Output name field, the Output type will switch to Transformed Microarray Data, and a new Data object will be created in the Solution Explorer.
No Transformation 
Y=X 
This is the default option and leaves the data unchanged 
Abs 
Y=Abs(X) 
Report the absolute value of each data point (i.e. remove '' from values) 
Log2 
Y= log2(X) 

SLog2 
Y= sign(X)*(log2(X)) 
Performs a logarithm to the base 2 transformation of the absolute value and then applies the appropriate sign. 
Exp2 
Y=2^X 
Exponential base 2 function. Can be used to unlog the Log2 transformed data 
SExp2 
Y=sign(X)*2^X 
Performs an absolute value exponential base 2 function and then applies the appropriate sign. 
NExp2 
Y=2^(x) 
Negative exponential base 2 function. 
Log10 
Y= log10(X) 
Performs a base 10 logarithm transformation 
NLog10 
Y= log10(X) 
The natural logarithm is the logarithm to the base e, where e is an irrational constant approximately equal to 2.718281828. 
Exp10 
Y=10^X 
This used to mean 10 raised to the power of x. This is the inverse function of log 10(x). 
NExp10 
Y=10^(x) 
Negative exponential base 10 function. 
Log 
Y= loge(X) 
This means logarithm to base e. 
Exp 
Y=e^X 
This means the exponential function of x. 
Percentile 
p = (R/N)*100 
p = percentile rank R = rankorder position (1, 2, 3...) of nonmissing indices N = total number of data points 
ArcSinh 
Y = Log(x + Sqrt(x*x+1)) 
Inverse hyperbolic sine transformation 
Output Results
The Output type will either be set to Change input data, in which case the original Data object will be permanently changed, or if the user enters a name in the Output name field, the Output type will switch to Normalized Microarray Data, and a new Data object will be created in the Solution Explorer.
WARNING: If users don't specify output name, the original MicroArray or Omic data object will be overwritten by the new transformed data.
OmicScript
Related Articles
 Latest Tutorials
 Omicsoft aligner wiki and publication