Scripting Question - Data set with many months of data. Want to create using script a subset of the main data table with a "selected" month of data

dfusco923

Could someone please help me figure this out?  I think the problem as to do with improper input/formatting of "Month".

 

I have a data set with one of the columns being "Month".  "Month" has the following column properties:

*  Numeric

* Ordinal

* Format m/y

* Input Format m/y

I'm trying to establish a variable up front in the script for any given month in the case "05/2019"

 

MONTH = "05/2019";

 

ERROR MESSAGE:

MONTH = "05/2019";

/*:

Column "Month" requires numeric values{109} in access or evaluation of 'Bad Argument'

 

 

 

Later in the script I am trying to use the variable I tried to established above in the below script to cull out that particular month of data:

 

MyList = {"MONTH"};
CT_5<< Select Where( (Contains(MyList, :Month)))
CT_5 << Invert Row Selection;
CT_5 << Delete Rows();

 

Error Message:

Send Expects Scriptable Object{109} in access or evaluation of 'Send' , CT_5 << /*###*/Select Where( Contains( MyList, :Month ) ) /*###*/

　

In the following script, error marked by /*###*/

MyList = {MONTH};

CT_5 << /*###*/Select Where( Contains( MyList, :Month ) ) /*###*/;

CT_5 << Invert Row Selection;

CT_5 << Delete Rows();

 

txnelson

I am a little confused on exactly what you need.  However, I think the code below might be helpful and if not exacly what you want, at least get the conversation going

// Your Month column is a JMP Date/Time column.  It is numeric, based upon
// the number of seconds since Jan. 1, 1904.  Therefore, your MONTH variable
// needs to have the number of seconds set.  The easiest way to do this is
// to use the Informat() function.
MONTH = Informat( "05/2019", "m/y" );

// If you show the MONTH variable using a Fixed Decimal format, it will show
// the numeric value
Show( Format( MONTH, "Fixed Dec", 12 ) );

// Concerning the Select Where, I think what you really want to do, is to 
// determine the Month for each of rows and then select those rows where
// column Month is the 5th month.  That code would be
CT_5 << Select Where( Month( :Month ) == 5 );