lilysecret

Select Rows by Criteria and Delete JMP JSL

Sep 14th, 2022 (edited)
422
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.82 KB | None | 0 0
  1. //open the file and assign an easy handle (dt) to the current data tables
  2. Names Default to Here(1);
  3.  
  4. dt = current data table();
  5.  
  6. //select rows based on ID number and delete them
  7. Current Data Table() << Row Selection(
  8. Select where(
  9. :"Respondent ID - RCL"n == 53666296 |
  10. :"Respondent ID - RCL"n == 53600883 |
  11. :"Respondent ID - RCL"n == 53601444 |
  12. :"Respondent ID - RCL"n == 53668132 |
  13. :"Respondent ID - RCL"n == 53603576 |
  14. :"Respondent ID - RCL"n == 53673565 |
  15. :"Respondent ID - RCL"n == 53610794 |
  16. :"Respondent ID - RCL"n == 53665615 |
  17. :"Respondent ID - RCL"n == 53614508 |
  18. :"Respondent ID - RCL"n == 53677457 |
  19. :"Respondent ID - RCL"n == 53600299 |
  20. :"Respondent ID - RCL"n == 53666008 |
  21. :"Respondent ID - RCL"n == 53600294 |
  22. :"Respondent ID - RCL"n == 53666998
  23. ));
  24.  
  25. dt << delete rows;
  26.  
Tags: JMP JSL
Advertisement
Add Comment
Please, Sign In to add comment