@Aexor wrote: Hi I have a datasets having numerous variables and want to compare what are the variables having missing values for a subject.   id name number results rank 1  Nan         .          3          A 2  Ben      10          .              want results like with new variable "Comment"   id name number results rank   Comment 1  Nan         .          3          A    Number variable is missing 2  Ben      10          .                 Results and rank variable is missing     Please help I wouldn't bother to try much of an actual narrative sentence because you have potential several different rules to use. I might start with something like: data want; set have; array _nums_ _numeric_; array _chars_ _character_; length comment $200; /* the length of the comment variable has to be long enough to contain the names of ALL the variables in your data set + one space to separate them PLUS any miscellaneous text */ comment='Vars with missing values are: '; do i=1 to dim(_nums_); if missing(_nums_[i]) then comment=catx(' ',comment,vname(_nums_[i])); end; do i=1 to dim(_chars_); if missing(_chars_[i]) then comment=catx(' ',comment,vname(_chars_[i])); end; drop i; The VNAME function can return the name of an Array referenced variable. The _numeric_ and _character_ are special words to provide access to those types of variables. DO NOT define COMMENT prior to the Array statement or it would be included in the checks for the character variables. ... View more

I do not use PROC SEQDESIGN myself, but I notice in the doc that the syntax supports STOP=ACCEPT STOP=REJECT Is that useful? ... View more