I forgot to mention I am using EG 4.3 so I don't think Hash Tables are an option. Astounding thank you, that sounds like a great method. I am doing something wrong though. The code runs fine but it doesn't delete any observations on my test set (where it should delete 80). I really haven't used formats much. What am I doing wrong? data delete_list; infile "myTextFile" input start $; retain fmtname "$form label "delete me"; run; * I get a 3 column dataset with the same number of observations and my codes in the first column, $form in the second, and delete me in the third); proc format cntlin=delete_list; data IGIV2_filtered (drop=i); set IGIV1_all; array Diag{12} diag1-diag12; do i = 1 to 12; if put(diagCode{i}, $form.) = "delete me" then delete; end; run; What am I doing wrong? Thanks again!
... View more