@dsky227 wrote: I have a data set with two text variables (tvar1 & tvar2) and one numeric variable (nvar) I want to create these tables                                   tvar2 is missing    tvar2 is not missing tvar1 is missing                xx                           xx tvar1 is not missing         xx                             xx                    tvar1 is missing     tvar2 is not missing nvar (values) I can't figure it out.   If I run     proc format;       value missing_ind .='missing' other='not missing'; run;   then what do I do?   Your format is only defined for NUMERIC values. You would need to make a similar format for character variables. proc format; value $missing_ind ' '='missing' other='not missing' ; run; The format can have the similar name because the $ means it is only for Character variables. ... View more