REMOVE

REMOVE (LET)

Let Subcommand

Remove rows of a variable based on the values in another variable.

With this command, we define a variable that contains values to be deleted from another variable.

Although this can be accomplished with the RETAIN command and SUBSET clauses, the REMOVE command may be more convenient if the list of values to delete is long and not contiguous.

LET <y> = REMOVE <x> <xlist>
where <x> is a response variable;
            <xlist> is a variable containing values to remove from <x>;
            and <y> is a variable that contains the results after removing the specified values.

LET Y = REMOVE X XDELETE

None

None

GATHER	=	Extract rows from a variable based on an index variable.
SUBSET	=	Specifies a subset to be included in a plot, analysis, or LET command.
RETAIN	=	Retain specified rows or a subset of a variable.

Data Transformation

2025/12

 
let x = data   0.75750 -0.90033 2.52521 0.41734 -1.13290 0.58353 ...
        0.47807 -0.64190 -1.09908 1.86310 0.86764 0.71655 -1.06700 ...
        -1.13660 0.51409 0.84443 0.77619 -0.83486 1.44312 0.02013
let xdelete = data -0.90033 1.86310 0.51409 -1.13290
.
let y = remove x xdelete
print y
    

 
 ---------------
               Y
 ---------------
         0.75750
         2.52521
         0.41734
         0.58353
         0.47807
        -0.64190
        -1.09908
         0.86764
         0.71655
        -1.06700
        -1.13660
         0.84443
         0.77619
        -0.83486
         1.44312
         0.02013