INDEX can only search forward -- PeterC's technique of using INDEX and REVERSE definitely works in this way. There is a new SAS 9 function, FIND, which is like INDEX but with more bells and whistles. In particular, it can search backwards.
Hi I am writing a program and I was wondering if I should use Enterprise Guide or SAS programming. I need to use substrings, can I use substrings using enterprise guide. Lets say for example I have a Date of Visit and I need only certain years and certain months within those years. Can I do this using Enterprise Guide.