REPLICATED STACK

REPLICATED STACK (LET)

LET Subcommand

Convert a set of response variables and a single group-id variable to a single response variable and two group-id variables.

Many commands in Dataplot expect the data to be in the form of a single response variable and two group-id variables (specifically, the INTERLAB E691 command). However, many data files will contain this data in column form. That is, each column contains the response for one value of the first group-id variable. One of the columns will contain the value of the second group-id variable.

That is, the data is the form

X1 X2 X3 ... XK LABID

The REPLICATED STACK command will convert this to

        X1(1)   1   LAB(1)
          .     .     .
        X1(n)   1   LAB(n)
        X2(1)   2   LAB(1)
          .     .     .
        X2(n)   2   LAB(n)
               ...
        Xk(1)   k   LAB(1)
          .     .     .
        Xk(n)   k   LAB(n)
       

LET <y> <matid> <labid> REPLICATED STACK = <x1> ... <xk> <lab>
            <SUBSET/EXPCEPT/FOR qualification>
where <x1> ... <xk> is a set of one or more response variables;
            <lab> is the first group-id variable (often a lab-id);
            <y> is the variable to contain <x1> ... <xk> in a single response variable;
            <matid> is the variable that contain the value of the second group-id variable (i.e., the column number);
            <labid> is the variable that contain the value of the first group-id variable (i.e., the value of <lab>);
and where the <SUBSET/EXCEPT/FOR qualification> is optional.

LET Y MATID LABID = REPLICATED STACK Z1 Z2 Z3 Z4 Z5 LAB

None

None

STACK	= Convert column data to a single response variable and a group-id variable;
EXTEND	= Extends a variable by another variable.
LET	= Creates, transforms, etc. a variable.
E691 INTERLAB	= Peform an interlab analysis based on the E691 standard.

Data Management

2005/4

 SKIP 25
 READ GLUCOSE2.DAT LAB X1 TO X5
 .
 LET Y MATID LABID = REPLICATED STACK X1 X2 X3 X4 X5 LAB
 .
 E691 INTERLAB Y MATID LABID