BookmarkSubscribeRSS Feed
Calcite | Level 5 zz
Calcite | Level 5

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

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


Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.


Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 2 in conversation