Choose Language Hide Translation Bar
Highlighted
TONYMA
Level III

how to delete miss data in table automatic?

dear: I have a problem that  everyday i update data and usually find some miss data in data table,so i want to delete them automaticly。

I worte JSL as below ,but it did not work。 where is wrong? 

dt = Open( "C:\Users\wty\Desktop\Big Class.jmp" ); dt=Data Table( "Big Class" ) << Missing Data Pattern( columns( :age ), Output Table( "Missing Data" )); dt=Data Table("Missing Data")<< Subset(selectd Rows() ); dt<<delete selectd rows

you are your god.
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
gzmorgan0
Super User

Re: how to delete miss data in table automatic?

Try this

	dt = Open( "C:\Users\wty\Desktop\Big Class.jmp" ); 
	dt = Data Table( "Big Class" ) ; //not required 
	idx = dt<< get rows where( Is Missing(:age ) );
	dt << delete rows( idx );

View solution in original post

1 REPLY 1
Highlighted
gzmorgan0
Super User

Re: how to delete miss data in table automatic?

Try this

	dt = Open( "C:\Users\wty\Desktop\Big Class.jmp" ); 
	dt = Data Table( "Big Class" ) ; //not required 
	idx = dt<< get rows where( Is Missing(:age ) );
	dt << delete rows( idx );

View solution in original post

Article Labels

    There are no labels assigned to this post.