Generally, when we import data from external sources such as Excel/CSV files, it loads additional rows that are totally blank. Sometimes empty values in the database also affect the desired output so it’s necessary to check missing cases and perform operations accordingly
Input: The sample dataset looks like below have four variables – 1 character and 3 numeric. It would be used further in the example to demonstrate how to remove empty rows.
Create a SAS dataset
The below defined code is a sample dataset to perform delete empty operation.
- Method I: Removes complete row where all variables having blank/missing values
OPTIONS missing =
- The MISSING= system option is used to display the missing values as a single space rather than as the default period (.) options missing = ‘ ‘;
- The CATS function concatenates the values. It also removes leading and trailing blanks. cats(of _all_) – Concatenate all the variables
- missing(cats(of _all_)) – Identifies all the rows in which missing values exist in all the variables.
- Method II: Removes only that rows where any of the variable has missing/blank values
_numeric_) > 0
In this case, we are using the OR operator to check if any of the variables have missing values. It returns 4 observations. Check out the output below –
- How to import data into SAS?
- Introduction to SAS programming
- How to import External Data from Excel or Text file into SAS Programming?
- How to Create or Modify a Variable in SAS Programming?
- Contains and Between-And operators in SAS Programming
- How to drop variables from a dataset in SAS Programming?
- Where Statement in SAS Programming
- If-Then-Else statement in SAS Programming
- IS MISSING and IS NOT MISSING Operators in SAS Programming
- Like Operator in SAS Programming
- SAS | How to specify a list of Variables?
- SAS | How to read character of varying length using COLON Modifier
- SAS | How to read character using Ampersand(&)
- SAS | Date Formats and Informats
- SAS | COALESCE Function with Examples
- SAS : How to Display Current Date?
- SAS | COMPRESS Function with Examples
- Binding rows and columns of a Data Frame in R - bind_rows() and bind_cols() Function
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to email@example.com. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.