- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: how to use JSL to delete missing data?
Created:
Oct 15, 2017 09:27 AM
| Last Modified: Oct 16, 2017 6:30 AM
(7277 views)
| Posted in reply to message from TONYMA 10-15-2017
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
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: how to use JSL to delete missing data?
Created:
Oct 15, 2017 09:17 AM
| Last Modified: Oct 16, 2017 6:30 AM
(6516 views)
| Posted in reply to message from TONYMA 10-15-2017
Use Is Missing()
Best
Uday
Uday
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: how to use JSL to delete missing data?
Created:
Oct 15, 2017 09:27 AM
| Last Modified: Oct 16, 2017 6:30 AM
(7278 views)
| Posted in reply to message from TONYMA 10-15-2017
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