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<
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 );