Hi All,
I want to Supress the blank field when I use the BY field.
eg:
TABLE FILE CAR
PRINT
CAR
COUNTRY
BY MODEL
END
if the MODEL values are blank then I want to Supress them .Any suggestion would be appreciated.

Regards,
Majid

Majid,
What do you want to suppress?

Majid,

If you do not have

SET BYDISPLAY = ON

in your fex, the BY field only prints once per occurance (or page if page overflow), so in any output it would look as if you had a blank field. If the BY field is 'really' a blank, then just select only those records in whick the field is greater than a blank space.

Hi Majid,

I agree with Lea, you can simply exclude those values within a where clause.

Regards.

Majid.