SAS Users
Providing technical tips and support information, written for and by SAS users.![How to filter variables by percentage of missing values or duplicate values in SAS](https://blogs.sas.com/content/sgf/files/2019/12/filtervar_00-702x336.jpg)
This article discusses how to use SAS to filter variables in a dataset based on the percentage of missing values or duplicate values. The missing value statistics can be implemented by either DATA step programming on your own or reusing the existing powerful PROC FREQ.
![How many people does it take to publish a book?](https://blogs.sas.com/content/sgf/files/2019/12/SAS-Tree-Final-copy-702x336.jpg)
The next time you pick up a book, you might want to pause and think about the work that has gone into producing it – and not just from the authors.
![Machine Learning with SASPy: Exploring and Preparing your data - Part 3](https://blogs.sas.com/content/sgf/files/2019/11/normalizedData.png)
Parts 1 and 2 of this blog post discussed exploring and preparing your data using SASPy. To recap, Part 1 discussed how to explore data using the SASPy interface with Python. Part 2 continued with an explanation of how to prepare your data to use it with a machine-learning model.
![Adding SAS® procedures to the SASPy interface to Python](https://blogs.sas.com/content/sgf/files/2019/12/stdizeProc2-600x336.png)
Bringing the power of SAS to your Python scripts can be a game changer. An easy way to do that is by using SASPy, a Python interface to SAS allowing Python developers to use SAS® procedures within Python. However, not all SAS procedures are included in the SASPy library. So,
![Old reliable: DATA step tips and tricks](https://blogs.sas.com/content/sgf/files/2017/05/ProblemSolvers_Graphic-400x336.jpg)
The DATA step remains a popular way to create and manipulate SAS data sets. Whether you are reshaping a data set entirely or simply assigning values to a new variable, there are numerous tips and tricks that you can use to save time and keystrokes.
![How to compare SAS data tables for common/uncommon columns](https://blogs.sas.com/content/sgf/files/2019/12/data-tables-comparison-matrix-details-Figure-3-702x336.jpg)
SAS' Leonid Batkhan shows you how to compare SAS data sets that include common and uncommon columns. You'll learn how to check mark commonalities and color-code differences in data tables side-by-side columns and add a comments field to see greater detail.