cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Choose Language Hide Translation Bar
View Original Published Thread

how to use JSL to delete missing data?

TONYMA
Level III

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