nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Log showing error, but manual execution does not flag error

Hegedus

Hi,

I have a simple script to do six bivariates and arrange them in rows. The graphs appear to be correct, but the log is showing an error. When I do the manual fit via the dialog box the plots get generated (without the arrange in rows), but without any error being flagged. I am writing this script to distribute so I would like to resolve this error. Where should I start looking?

Thanks in advance

Andy

Name Unresolved: By in access or evaluation of 'By' , By( :device_ID ) /*###*/Exception in platform launch in access or evaluation of 'Fit Group' , Fit Group(/*###*/Bivariate( Y( :Charge_Transfer_%0 ), X( :cycle_num ) ),

Bivariate( Y( :TvB_%0 ), X( :cycle_num ) ),

Bivariate( Y( :TvD_%0 ), X( :cycle_num ) ),

Bivariate( Y( :Name( "a*_%0" ) ), X( :cycle_num ) ),

Bivariate( Y( :Name( "b*_%0" ) ), X( :cycle_num ) ),

Bivariate( Y( :Name( "L*_%0" ) ), X( :cycle_num ) ),

<<{Arrange in Rows( 6 )},

By( :device_ID )

)

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

Fit Group(

Bivariate( Y( :Charge_Transfer_%0 ), X( :cycle_num ) ),

Bivariate( Y( :TvB_%0 ), X( :cycle_num ) ),

Bivariate( Y( :TvD_%0 ), X( :cycle_num ) ),

Bivariate( Y( :Name( "a*_%0" ) ), X( :cycle_num ) ),

Bivariate( Y( :Name( "b*_%0" ) ), X( :cycle_num ) ),

Bivariate( Y( :Name( "L*_%0" ) ), X( :cycle_num ) ),

<<{Arrange in Rows( 6 )},

By( :device_ID ) /*###*/

)

dt<<currentdatatable();
dt<<clear row states;


New Window( "Fitness - Bivariate",
	V List Box(
		Fit Group(
			Bivariate( Y( :name("Charge_Transfer_%0" )), X( :cycle_num ) ),
			Bivariate( Y( :name("TvB_%0" )), X( :cycle_num ) ),
			Bivariate( Y( :name("TvD_%0" )), X( :cycle_num ) ),
			Bivariate( Y( :Name( "a*_%0" ) ), X( :cycle_num ) ),
			Bivariate( Y( :Name( "b*_%0" ) ), X( :cycle_num ) ),
			Bivariate( Y( :Name( "L*_%0" ) ), X( :cycle_num ) ),
			<<{Arrange in Rows( 6 )},
			By( :name("device_ID") )
		),
		
	)
);

Accepted answers

Craige_Hales

Appears to be a bug in JMP 12, fixed in 13. It looks like JMP's FitGroup attempts to evaluate the by statement, in addition to actually using it to make by groups. You can work around the problem like this:

dt=open("C:\Program Files\SAS\JMPPRO\12\Samples\Data/big class.jmp");
by=0; // work around JMP 12 issue
New Window( "Big Class - Bivariate",
  V List Box(
    dt<<Fit Group(
      Bivariate( Y( :height ), X( :age ) ),
      Bivariate( Y( :weight ), X( :age ) ),
      <<{Arrange in Rows( 2 )},
      By( :name( "sex" ) )
    )
  )
);

Now JMP can evaluate the variable "by" (and ignore the zero result) without producing messages in the log.

Edit: make it clear this problem is in FitGroup.

All comments

Hegedus

Any help folks?

If I run the script the graphs get made but it is still throwing errors?

mikedriscoll

I ran a modified version of your script, modified to match my data, and I couldn't get it to throw that error even if I deleted the column. It seems to be flagging as if it can't find the column. The fact that it is working almost seems like a JMP version issue, some cosmetic bug that was cleaned up in a later verison. What JMP version are you using?

Craige_Hales

Try this

dt=open("$sample_data/big class.jmp");
New Window( "Big Class - Bivariate",
  V List Box(
    dt<<Fit Group(
      Bivariate( Y( :height ), X( :age ) ),
      Bivariate( Y( :weight ), X( :age ) ),
      <<{Arrange in Rows( 2 )},
      By( :name( "sex" ) )
    )
  )
);

which is probably only different in sending the fit group message to an explicit dt.

Hegedus

I am having real trouble with this.

I need to embed this in a longer script. I think it is now have a related but larger issue. The script makes serveral data tables and it is now trying to execute this the wrong data table even if a speficially set the the data table. Notice that the Fitness- Bivariate fit is being attached to the ....SPU.Data table even though I speciffically set the other data table. If I bring the desired data table to the for and highlight the script for the new window and execute. It will give the correct plots but STILL throw the errors. If executed in the script it doesn't even do that but rather gives me a "Not Found in access or evaluation of BiVariate, Bad Arguement.

I am using JMP 12.2.0 on both Mac and Windows.

HELP!

Wrong Data Table.png

datatable(OpticalData);
	
New Window( "Fitness - Bivariate",
	V List Box(
		Fit Group(
			Bivariate( Y( :name("Charge_Transfer_%0" )), X( :cycle_num ) ),
			Bivariate( Y( :name("TvB_%0" )), X( :cycle_num ) ),
			Bivariate( Y( :name("TvD_%0" )), X( :cycle_num ) ),
			Bivariate( Y( :Name( "a*_%0" ) ), X( :cycle_num ) ),
			Bivariate( Y( :Name( "b*_%0" ) ), X( :cycle_num ) ),
			Bivariate( Y( :Name( "L*_%0" ) ), X( :cycle_num ) ),
			<<{Arrange in Rows( 6 )},
			By( :name("device_id") )
		),
		
	)
);

OpticalData<<select where(:outlier !="---");
OpticalData<<exclude;
OpticalData<< markers("x");
OpticalData<<clear select;

cwillden

It would probably be a lot easier to resolve this if you post a sanitized version of your data set we can test use for troubleshooting. If you're worried about IP, just replace the values in your response column with random numbers or something.

Craige_Hales

pretty sure you want this

dt<<Fit Group

and not this

dt<<Bivariate

FitGroup is a lot like a platform and needs to know what table to use to make the by groups. FitGroup then runs the contained bivariate platforms, once for each by group. The by groups are actually subset tables, and using dt<<Bivariate makes the platforms run on the entire table, not the subset that FitGroup prepared.

I have not tried this with multiple open data tables, so there may be still another issue.

Hegedus

Attached is a data table with a table script.

Generally the plots look ok, the conern is the log is showing lots of errors. I do not like releasing code to production that is producing errors.

Andy

Error Test.jmp

Craige_Hales

dt=open("C:\Program Files\SAS\JMPPRO\12\Samples\Data/big class.jmp");
by=0; // work around JMP 12 issue
New Window( "Big Class - Bivariate",
  V List Box(
    dt<<Fit Group(
      Bivariate( Y( :height ), X( :age ) ),
      Bivariate( Y( :weight ), X( :age ) ),
      <<{Arrange in Rows( 2 )},
      By( :name( "sex" ) )
    )
  )
);

Now JMP can evaluate the variable "by" (and ignore the zero result) without producing messages in the log.

Edit: make it clear this problem is in FitGroup.