Process Description

Import a Designed Experiment from Text, CSV, or Excel Files

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.

What do I need?

Two types of files are needed to run this input engine:

•

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-channelexpression 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 Genomics software, see Files and Data Sets.

Output/Results

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.