topic Sort data set on the basis of missing value in SAS Enterprise Guide

Sort data set on the basis of missing value

deleted_user — Tue, 10 Feb 2009 12:20:36 GMT

i want to sort the data set in such a way that first row contain minimum no of missing value and last row contain maximum missing value.

please help ..how it is possible...

Re: Sort data set on the basis of missing value

deleted_user — Tue, 10 Feb 2009 13:52:29 GMT

please explain what is "maximum missing value" ?

Re: Sort data set on the basis of missing value

RichardH_sas — Wed, 11 Feb 2009 13:53:55 GMT

Hi Arvind,

If you're talking about sorting based on, across all variables, the total number of missing values in each row, try using the CMISS function. It's new to SAS 9.2, and if you supply all the columns in your data set as arguments, it will tell you how many of them have missing values. It's similar to the NMISS function, but CMISS can take arguments of character or numeric variables (or any combination!). Whatever number CMISS returns is what you'd sort on.

FYI, PROC SQL and hence the query builder do not support variable lists. So, sadly, you can't use the syntax "cmiss(of _all_)" in the Query builder expression editor. You could write your own DATA step code where that would be allowed.