Conditional statements, action and deleting columns

sasjmper

Hello Everyone,

I am having a problem with a JSL script, and I have researched the documentation, books and user forums for an answer.

I wrote a script that contained a conditional statement in JSL, and one of the “results” is to perform an action like delete a row.  Can this be done in a conditional statement?

Let’s use this sample code:

NE3=3;

NE4=5;

/* These variables can take different values. */

If (NE3==NE4,

          NewNum = NE3,

           NewNum = index (NE3, NE4)

);

If (NewNum == 0,

                  Print (“No Deletion”), 

                Current data table () << delete column (NewNum)

);

As you can see or guess, I cannot delete columns.  More importantly, I used the first conditional statement because I wanted it to create a range or single value.

However, I am not sure what to do with 0 as a value, as JMP cannot delete something that does not exist (aka, column 0).  Any suggestions will be greatly appreciated!

Many thanks,

K

pmroz

This is a little tricky.  Delete columns takes either a single column name or index, or a list of column names or indices.  This program will do the trick.  Note the AS LIST function which converts a matrix into a list:

NE3 = 3;

NE4 = 5;

/* These variables can take different values. */

dt = current data table();

nc = ncols(dt);

if (ne3 > 0 & ne3 <= nc & ne4 > 0 & ne4 <= nc,

    If( NE3 == NE4,

        dt << delete column(ne3);

        ,

        new_list = as list(Index( NE3, NE4 ));

        dt << delete column(new_list);

    );

);