In order to display data that does not exist or is missing, try using a filter in Report Designer. Before you can apply a filter, please have a visualization with the data you want to use. For your example, you will need to have variables for both customer and invoice date. In the right hand panel, click on Filters and select Add Filter.
Next, you will click on the data item that you want to see missing data for. In this example, you would want to click Date and choose the variable that represents customer’s invoice dates. Then, in Column Templates choose ‘Invoice_Date Missing’ and drag it over to fill the condition. After completing this step, your visualization should update showing the missing invoice dates for your list of customers. Please notify me if you have any more questions regarding this issue.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.