Hi everyone! I have a SAS dataset with more than 1000 variables distributed like this: ID Auto Auto_2 Auto_3 City City_2 Sport Sport_2 Sport_3 Sport_4 ... and so on (many different variables repeated different times). I need to: 1) keep only those rows that have missing values in all the variables ending with "_number", (or, equally, drop those rows that have values in any of the variables ending with "_number"). For example:? ID Auto Auto_2 Auto_3 City City_2 01 Fiat Ford Milan ---> Drop row 02 Fiat Milan Rome ---> Drop row 03 Fiat Ford Ford Milan Rome ---> Drop row 04 Fiat Milan ---> KEEP ROW If it can help, if Variable_n is missing, then Variable_(n+1) is missing too. 2) keep only the columns without the "_number". In the previous example only ID Auto City must be kept. The problem in both cases is the same: I can't write all the variables in a drop/keep statement or in a IF condition because they're too many. Is there a smart way to manage variables like these? Maybe something like lists...? I don't know. Thanks a lot Irene
... View more