cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
TONYMA
Level III

how to use JSL to delete missing data?

dear all

now  if  you  want to  detele  missing data , generally  you must select "missing data pattern ' to detele.

if i want to detele  missing data automaticlly?  how i  can  write JSL?

you are your god.
1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: how to use JSL to delete missing data?

You just need to select the rows to be deleted, and then delete them....see script below

Names Default To Here( 1 );
dt = New Table( "sample",
	Add Rows( 20 ),
	New Column( "Height",
		Numeric,
		"Continuous",
		Format( "Fixed Dec", 5, 0 ),
		Set Values(
			[59, 61, ., 66, 52, 60, 61, ., 60, 61, 56, 65, ., 58, 59, 61, ., 65, 63, 62]
		)
	),
	New Column( "weight",
		Numeric,
		"Continuous",
		Format( "Fixed Dec", 5, 0 ),
		Set Values(
			[95, 123, 74, 145, 64, 84, 128, 79, 112, 107, 67, 98, 105, 95, 79, 81, 91, 142, 84,
			85]
		)
	)
);

dt << select where( Is Missing( :Height ) == 1 );

dt << delete rows;
Jim

View solution in original post

2 REPLIES 2
uday_guntupalli
Level VIII

Re: how to use JSL to delete missing data?

Use Is Missing()

Best
Uday
txnelson
Super User

Re: how to use JSL to delete missing data?

You just need to select the rows to be deleted, and then delete them....see script below

Names Default To Here( 1 );
dt = New Table( "sample",
	Add Rows( 20 ),
	New Column( "Height",
		Numeric,
		"Continuous",
		Format( "Fixed Dec", 5, 0 ),
		Set Values(
			[59, 61, ., 66, 52, 60, 61, ., 60, 61, 56, 65, ., 58, 59, 61, ., 65, 63, 62]
		)
	),
	New Column( "weight",
		Numeric,
		"Continuous",
		Format( "Fixed Dec", 5, 0 ),
		Set Values(
			[95, 123, 74, 145, 64, 84, 128, 79, 112, 107, 67, 98, 105, 95, 79, 81, 91, 142, 84,
			85]
		)
	)
);

dt << select where( Is Missing( :Height ) == 1 );

dt << delete rows;
Jim