How to filter the missing data from the dataset "Employees" in the course SAS Visual Analytics 1 for

[trytolearnsas]

Hello, 

Ihave an inquiry to you. I am doing the course SAS Visual Analytics 1 basics. I am doing the practise and have notice that I have missing value within the first exercise. The first image is how it should be and the second image is how it's look with me. I already tried to sorted the data items "Manager at lvl 1." (see image 2)  which I get 18 observations and still does not work in the graph (see image 3). Ontbreek = missing value.

The question is how can I filter these missing value out?

   

[antonbcristina]

Hi @trytolearnsas, you can filter the values from the  Filters pane on the right (second last icon):

In this case, you'll want to uncheck the box at the bottom for "Include missing values".

[trytolearnsas]

Hi @antonbcristina 

Thank you for your fast reply and your help. I have used the filter.  When I am not check the box "include missing value" nothing is going to change (see picture 1). I expect then then the missing value will be gone.  Eventually I have to adjust the line of value's to get the missing value gone (see picture 2). Does this work like this?

Second question, the course did not mention anything about filter the data. I assume the missing value is filter out in preparing the data and load it in the canvas. Is this true and when yes, how can I filter the missing data before loading in the canvas?

Thanks in advance.

I am looking forward hearing from you.

  

[antonbcristina · Accepted solution]

Hi @trytolearnsas, my mistake the filter should be on the classification variable Manager at 1. level.  Please try removing the missing values using this filter

Alternatively, you could click on the Data source menu icon, and select Apply data filter (second last option):

Here you'll be able to build an expression to pre-filter the data for the whole report:

You'll notice this filter only removes one observation, however that observation is what's causing the issue. This isn't an employee at all!

[trytolearnsas]

Hi @antonbcristina, your solution did work, thank you for your effort and help 🙂 

[trytolearnsas]

Another question which is a fellowing about this topic. I use the data filter sets. I have noticed that I need to prepare everytime. How can I prepare it once before I loaded in a new report/canvas? Is there option for this?

Thanks in advance.

[antonbcristina]

The data would need to be pre-processed before you use it in Visual Analytics for reporting. This can be done with SAS Studio, using SAS code or tasks. 

[trytolearnsas]

hi @antonbcristina Another question, how come that the category “Department” only contains “Sales while I filtered “Sales” and “Purchasing”? See pictures.

I am sorry for all the questions, I would like to understand it better.

Thank in advance.

[antonbcristina]

This might just be a feature of the data. Where is this filtering taking place or what is it that you're trying to achieve?