...park joy" and you'll decide that it's time to delete them. Deleting data sets that you no longer need can save space and memory during processing, and it's best practice to clean up. In this article I'll d...
Hi, I have a dataset with around 520 variable with many missing values. I want to deletevariables with >90% missing values (I dont want to impute). Is there any macro or anything else t...
...ay to tell sas to delete/remove all variables that have missing values across all observations does anyone know how to do that please be indebted . /* find string / value a...
...here are no missing values, e.g. I need to deletevariable B below. How can I delete all variables with missing values? Var A Var B Var C 1 2 3 1 2 3 1 2 3 1 2 3...
Hi, I have a large number of columns and rows. I want to delete a row of data if one specific variable is missing (FIRMID) which is a numerical variable I tried the following but it d...
I published a paper in the Southeast SAS Users' Group meeting in 2021 on the topic of missing value imputation, and I am sharing it with the SAS community.
I describe the purpose of missing...
Missing Value Imputation SESUG Paper 16-2021.pdf (1,888 KB)
...round 4000+ variables and 3000+ observations. The data is from 30 different centers, but I am only interested in the data from 3 centers. Some variables are the same for all centers, but variable...
Hi, I have to delete observations with more than 10 variables recorded as 0. I have used macros so far but it is not working and I'm not familiar with array. Each observation has 60 variable...
Hi, I want to delete rows that have missing values for a list of consecutive variables. For example, from a the a dataset like: id cat var1 var2 var3 var4 stop 42 a 1 0 0 1...
I want to delete the variables only if all of them (INBNPR,INBINK,INBFRK) are missing using where clause. In this case I want the same output as I got in the previous dataset qisfr15 but I end up w...
Hi all! I hope your Fridays are going well. As the title suggests, I had a question about missing cases and how to delete cases where one variable is missing more than 50% of the cases. &n...
