Hi all!
I have a simple problem and I know it will be a simple answer however after alot of searching all day, I still do not have the answer. I have a dataset with 6 variables and 2 variables contain null values (var5 and var6). I would like to filter out the null values for each variable (var5 and var6), and if there is a null value for the row, then the row is deleted.
For example.
ID var1 var2 var3 var4 var5 var6
1001 23 Yes 560 22 No
1002 54 No 6
1003 42 No 652 33
1004 60 Yes
1005 32 YES 5
Final would look like this
ID var1 var2 var3 var4 var5 var6
1002 54 No 6
^Only left due to having complete values for Var5 and Var 6.
Thanks in adance!
The delete statement can be used conditionally.
data want;
set have;
if var5="" /*null value for character variable */
OR
var6=. /*null value for numeric variable */
then delete;
run;
IF cmiss(var5,var6) ne 0 then delete;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.