Blank cases in csdb file

[eromjon]

Experienced a bizarre situation. I have a csdb file with blank cases. Even the ids are blank. File is attached. Any help how to get rid of these blank cases?

[Gregory Martin]

The first thing to do is ensure that your data entry applications are fixed to prevent this from happening.

You can get rid of them by passing them through a batch application:

PROC PHC2020LISTING_QUEST

    if key(PHC2020LISTING_DICT) = "" then
        skip case;
    endif;

Or if you needed to do it in the field from a menu program:

forcase PHC2020LISTING_DICT where key(PHC2020LISTING_DICT) = "" do
    delcase(PHC2020LISTING_DICT);
endfor;

[eromjon]

Thanks Greg.

Grateful if you could enlighten me on how do I ensure that my data entry application can prevent this to happen. Thanks

[Gregory Martin]

There's no general advice on how to prevent your application from creating blank cases. You would have to look at your application to determine why blank cases are added. With my advice, I only meant that it is important to remove your cases, but it is also important to stop them from happening in the future.

[SelmaAdam]

I also had the same problem but now it's sorted .Thanks.