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!
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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.