> "tiramisu" <kungmarten@gmail.com> wrote in message news:e8beff91-dcf9-4f6e-882c-b311504790ad@d45g2000hsc.googlegroups.com... > Thank you for your responses! This is what i want (example table > below) > > a b c > 1 test see > 2 test see > 3 hide @hide complete row > 4 test see > 5 test see > 6 hide @hide complete row > 7 test see > > when reading from this data set, i want all programs to skip the rows > that has '@hide complete row' (or whatever you should use) per > default. That is, i want the table to contain all information, but > when reading, skip the rows (3,6) that has "hidden" information. I > want this to work per default, or possibly adding an option, but NOT > editing any where clause in the programs. Also, to create a view is > too time consuming, since the view has to compute 200 - 300 million > rows. > > Hope this information shed any light on what I wish to accomplish!

To the best of my knowledge, the only way to "hide" observations is from all programs, viewers, etc. is to mark them as deleted. Observations marked for deletion using for example PROC FSEDIT are not physically deleted until the dataset is run through a DATA step. Unfortunately, there is no way (within the system) to unmark deleted observations.

The usual way to more or less accomplish what you want is to put a flag variable on the dataset, and have your programs accept or reject an observation depending on the value of the flag. Or to use a view that displays only the acceptable observations. Or both.