Filtering data and validating data in excel

Unfortunately, I've found that these filters aren't always pulling the correct data. Apples and Avocados), then when I filter on "Apples" I actually see the relevant entries for "Avocados".

I've checked the source data and it's all correct, it's just that when I filter for "Apples" (e.g.

You will know how to explore and validate data, prepare data by subsetting rows and computing new columns, analyze and report on data, export data and results to other formats, use SQL in SAS to query and join tables.

Prerequisites: Learners should have experience using computer software.

This course is for users who want to learn how to write SAS programs to access, explore, prepare, and analyze data.

It is the entry point to learning SAS programming for data science, machine learning, and artificial intelligence. By the end of this course, you will know how to use SAS Studio to write and submit SAS programs that access SAS, Microsoft Excel, and text data.

To reference a specific table column you can use the following method.

The downside to this way is that if the list is visible to the user and not protected, they can edit or delete the list, probably by accident, but it can happen.

Departments[Name] Now we need to go back and setup our Data Validation using the table reference.

Microsoft doesn't allow direct reference to a table and its columns from the Data Validation.

You can also take it a step further and reference a specific column inside the table.

The benefit of something like this, is that when you add new rows to the table, any formula using the table reference will update to include the new rows automatically.

Leave a Reply