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

[zz]

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!

[Reeza]

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/5976...