Thanks!  One more question, if I have a long list of columns that are not numbered, but are together in the data, is there a way to use the "--" functionality somehow?  For example I would like to compress the following code, where the columns BI through Roof are together in the data:   proc sql; select distinct Variable into: varlist separated by ' ' from factor.vehfactor_RAD7MM where CustomerGroup in ('ABM','AFF','RV') and Variable not in ('SymbolLiab','SymbolPhy','AgeSymDed','VehHisCodeNew','IRM' ,'NewBusDisc','SRMCode_v41','SR_Group', 'TerritoryNew' ) and not (BI = . and PD = . and MED = . and UMBI = . and UMPD = . and COMP = . and COLL = . and PERS = . and FTBI = . and RENT = . and TOW = . and CUST = . and AAE = . and ADD = . and DimDed = . and RVVL = . and RVMX = . and PPMX = . and RVEE = . and RVConsign = . and Pest = . and Roof = . ) ; quit;     ... View more

Thanks!  Do you know how to check if they are missing or not missing, instead of being equal to value X? ... View more

I'm curious about either.  Also I would like to know how to check if many columns are missing or not missing, both for character and numeric.  I know this is a lot, but the case I'm most interested in at the moment is checking something like this, for numeric variables, where if at least one field is not missing, then do X   if not( Column1 = . and Column2 = . ... and Column100 = .)   then do X ... View more