03-28-2017 04:37 PM
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:
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!
03-28-2017 05:18 PM
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.
This is the better solutions IMO