Hi SAS Experts, i have a SAS dataset with 250 fields which mainly indicates flags (either has 1 or 0 or null). i have to pull data from that dataset where field name starts with a specific letter and ends with word "RESULT" (Ex: starts with letter "P" and ends with word "RESULT" - Process1_RESULT, Process2_RESULT ... and so on) and where none of the field has "1" in it. I was able to do this when i had less fields and i can manually type the field names and say where process1_result ne '1' ,  however sometimes i need to check this in 200 fields and you don't want to type all those 200 fields. Is there a better way to do this without having to type all the field names. All the fields are in character format.   Dataset structure: System_ID Date Final_Status Process1_Result Process2_Result Process3_Result Process4_Result 12345 31-Jul-17 Y 0 0 1 0 67891 25-Jul-17 N   0   0 55669 29-Jul-17 N 1 0 1     From the above table, i would only want to get row 2 where System_ID is 67891 since none of the flag fields has 1 in it. In the above example i have only 4 flag fields however, in my actual datasets there is around 250 flag fields where i have to check whether it has "1" in it or not.     Thanks in advance. ... View more