topic Re: How to filter the missing data from the dataset "Employees" in the course SAS Visual A in New SAS User

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

trytolearnsas — Thu, 10 Oct 2024 08:44:46 GMT

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?

Re: How to filter the missing data from the dataset "Employees" in the course SAS Visual A

antonbcristina — Thu, 10 Oct 2024 15:05:16 GMT

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".

Re: How to filter the missing data from the dataset "Employees" in the course SAS Visual A

trytolearnsas — Fri, 11 Oct 2024 05:34:39 GMT

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.

Re: How to filter the missing data from the dataset "Employees" in the course SAS Visual A

antonbcristina — Fri, 11 Oct 2024 19:52:36 GMT

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!

Re: How to filter the missing data from the dataset "Employees" in the course SAS Visual A

trytolearnsas — Mon, 14 Oct 2024 08:46:34 GMT

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

Re: How to filter the missing data from the dataset "Employees" in the course SAS Visual A

trytolearnsas — Mon, 14 Oct 2024 09:37:41 GMT

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.

Re: How to filter the missing data from the dataset "Employees" in the course SAS Visual A

trytolearnsas — Mon, 14 Oct 2024 09:50:27 GMT

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.

Re: How to filter the missing data from the dataset "Employees" in the course SAS Visual A

antonbcristina — Tue, 15 Oct 2024 13:51:04 GMT

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.

Re: How to filter the missing data from the dataset "Employees" in the course SAS Visual A

antonbcristina — Tue, 15 Oct 2024 13:53:39 GMT

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?