I have a dataset which has about 35 column. Many of the cells have missing values. Since MINITAB recognizes the missing values, I can perform the statistical work I need to do and don't need to worry about the missing values. However, I would like to be able to obtain the subset of observations which MINITAB used for its calculations. I would like to be able to create a worksheet with only the rows from my dataset which do NOT contain any missing values.
I cannot seem to find any way to do this (except manually, YUCK). Does anyone have any ideas? suggestions? Here is an greatly simplified version of my problem: C1 C2 C3 C4 1 1 2 1 2 2 2 * * 3 3 3 3 4 2 4 0 1 * 5 5 1 * 1 8 6 2 2 3 7 I am looking for a command, or set of commands which will provide me with the subset of the above data consisting of: C1 C2 C3 C4 1 1 2 1 2 2 3 3 4 2 3 2 2 3 7 Many thanks, in advance ================================================================= Instructions for joining and leaving this list and remarks about the problem of INAPPROPRIATE MESSAGES are available at http://jse.stat.ncsu.edu/ =================================================================