1. The MISSING= system option is used to display the missing values as a single space rather than as the default period (.)
options missing = ' ';
2. The CATS function concatenates the values. It also removes leading and trailing blanks.
cats(of _all_) - Concatenate all the variables
3. missing(cats(of _all_)) - Identifies all the rows in which missing values exist
for all the variables.
Because Name is your 'key', your code could be written more succinctly as:data readin; set outdata; where not missing( Name);run;But, if you got records with a Name, but no Scores, you could write it as:data readin; set outdata; where n( of Score1-Score3) > 0 ;run;Cheers, :)
But if i want to delete rows only when missing values exist in all the variables ;)
Anytime you change the Options, please do take care to change it back so that later code doesn't change its behavior.