The
Import a Designed Experiment from Text, CSV, or Excel Files
input engine imports a set of raw data files into a single SAS data set along with associated experimental design information.
|
•
|
An
Experimental Design File (EDF)
that indexes the individual raw data files for the experiment. The EDF is typically a text file or Excel spread sheet and must be created before the data can be imported. A typical EDF, the
AgingExperimentTable.txt
file, is shown below.
|
|
•
|
Raw data files, which must be located and copied to a single folder. The raw data files must be formatted either as
tab-delimited
or
comma-separated value
text files, SAS data sets, or Excel files with the appropriate extensions. The
OF1A3.OF6A5.DAT
file is an example of a suitable raw data file.
|
Although the format is flexible, all data files must have the
same
format. Furthermore, all of the raw data files must have the same organization; the order of columns and data start rows must be the same. Column and row names should be consistent across all data files. The
OF1A3.OF6A5.DAT
file is a tab-delimited text file. Column names are listed in the first row. Rows 2 through 8 list comments and remarks about the data. Row 9 is the data start row. This data file, along with 23 others (all named using the *
.DAT
format), is included with JMP Genomics, in the
Sample Data\Microarray\Scanalyze Drosophila
directory. You can open these files using a text editor to compare their structure and organization.
The following example uses 24 raw data files and an
Experimental Design File (EDF)
from
Drosophila Aging Experimental Data
. The
OF1A3.OF6A5.DAT
file represents one of these files. All files are structured and organized in the same manner as the
OF1A3.OF6A5.DAT
file. Each raw file contains two-channel
expression
data for one of the experimental groups. Experimental groups are differentiated based on sex, age, and line. These files are located in the
Sample Data
folder included with JMP Genomics.
For detailed information about the files and data sets used or created by JMP Life Sciences software, see
Files and Data Sets
.
The output data sets generated by this process are listed in a
Results
window. Refer to the
Import a Designed Experiment from Text, CSV, or Excel Files
output documentation for detailed descriptions.