Another JMP Syntax Challenge..........::(

Tom_Watson

I'm trying to properly format an IF statement and can't get it to work after umpteen iterations.  Appreciate any help!

I have a data table with a column called "Process Step Description".....data type character

I have another column in the table called "Module Failures" that is data type numeric/continuous; I create it successfully using the script segment below

I want to set the value of the cell in the "Module Failures" column based upon the value in the "Process Step Description" cell, as follows:

Process Step Description..................Module Failures

Outgoing Quality Check.................... 0

Unit Fails............................................1

 

I have the following commands in my script; as far as I can tell everything functions properly except for the IF statement itself

dt<<New Column("Module Failures");
column ("Module Failures") << data type(Numeric, Format("Fixed Dec", 1,0));
column ("Module Failures") << Modeling Type(Continuous);

If (Process Step Description == "Unit Fails", ("Module Failures" = 1), ("Module Failures" =0) );

 

It could be something to do with the quotes as I always get confused by the single and double quote rules but I tried so many permutations and nothing seems to work

 

Thank you in advance

txnelson

The issue you are having is that you are not scoping the column references properly.  When you reference a column in JSL, the column name is proceeded by a ":" to indicate this is a column reference.  While you can use the Column() function in open code to reference a column, typically this is used when referencing a column through a memory variable

myColumn = "Process Step Description";
column( myColumn ) << ……..

Below are 3 different ways to accomplish what you need.  I suggest that you study the code below, and read the Scripting Guide to gain a full understanding about the scoping of columns and memory variables

Names Default To Here( 1 );
dt = New Table( "Example",
	Add Rows( 10 ),
	New Column( "Proceess Step Description",
		Character,
		"Nominal",
		Set Values(
			{"Unit Fails", "Outgoing Quality Check", "Unit Fails", "Unit Fails",
			"Outgoing Quality Check", "Outgoing Quality Check", "Unit Fails",
			"Outgoing Quality Check", "Unit Fails", "Outgoing Quality Check"}
		)
	)
);

dt << New Column( "Module Failures" );
:Module Failures <<
data type( Numeric, Format( "Fixed Dec", 1, 0 ) );
:Module Failures << Modeling Type( Continuous );

For Each Row(
	If( :Proceess Step Description == "Unit Fails",
		:Module Failures = 1,
		:Module Failures = 0
	)
);

// Or you can define your new column as a formula column
dt << New Column( "Module Failures 2",
	data type( Numeric ),
	Format( "Fixed Dec", 1, 0 ),
	Modeling Type( Continuous ), 
	Formula(
		If( :Proceess Step Description == "Unit Fails",
			 1,
			 0
		)
	)
);

// or If the reference variable changes you may want to 
// use the As Column()
zippy="Process Step Description";
dt << New Column( "Module Failures 3",
	data type( Numeric ),
	Format( "Fixed Dec", 1, 0 ),
	Modeling Type( Continuous ), 
	Formula(
		If( as column(dt, zippy) == "Unit Fails",
			1,
			0
		)
	)
);