Report on empty field(s) for all observations for a dataset

zz — Tue, 28 Mar 2017 20:37:58 GMT

I created a report in a dataset on a number of datasets (report name 'study_datasets'). The report 'study_datasets' includes fields 'ds_name', 'field_name', etc. I needed to also create a column indicating whether a field (field_name) is empty or not for all observations in any particular dataset (dataset_name).

For instance, the report 'study_datasets' has the following two variables:

DS_Name Field_Name

AE AESPID

AE AESERN

After running the program, the dataset will have an additonal

DS_Name Field_Name Field_Empty

AE AESPID Yes

AE AESERN No

Anyone has done something like this? Could you share your code, please?

Thank you very much in advance for your input, or sharing!

Re: Report on empty field(s) for all observations for a dataset

Reeza — Tue, 28 Mar 2017 21:18:38 GMT

Yes this has been done before, multiple times 🙂

This has several solutions but is a bit garbled from the conversion to this forum versus their old software.

https://communities.sas.com/t5/SAS-in-Health-Care-Related/Empty-vars/m-p/5393/highlight/true#M464

This is the better solutions IMO

https://communities.sas.com/t5/SAS-Procedures/How-do-I-list-all-unused-columns-in-a-dataset/m-p/59769/highlight/true#M16869

topic Re: Report on empty field(s) for all observations for a dataset in SAS Programming

Report on empty field(s) for all observations for a dataset

Re: Report on empty field(s) for all observations for a dataset