DATA Step, Macro, Functions and more

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

Reply
Contributor zz
Contributor
Posts: 28

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

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!

Super User
Posts: 17,912

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

Yes this has been done before, multiple times Smiley Happy

 

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

Ask a Question
Discussion stats
  • 1 reply
  • 109 views
  • 0 likes
  • 2 in conversation