I think we discussed it here and we are going to keep it as range format and use =: etc while analysing the data...so I am good now...thank you guys and sorry for the confusion.. ... View more

It is usually a very good idea to include the data that you start with. If you want code that has a chance of running then best is to provide example starting data in the form of a data step. Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the {i} icon or attached as text to show exactly what you have and that we can test code against. Replace any possibly sensitive values such as patient identifier with sequence number as you did for your question.   As shown in column G, Appearance of most recent occurrence of code A0001 (if two consecutive visits have same code A0001) and then within 6 months of that date, an appearance of Relevant code (which could be D0239 for example). What date is "that date"? The "most recent" the first or last of the dates with the A0001 code? Then do what with this information?   I find it even harder to follow the logic or results for Logic 2 and 3.   Please provide descriptions of the RULES involved in the logic such as "if any date has codes x that is (relationship) to a (rule for setting the comparison date). Instructions like "per column H" means we have to try to derive the rules involved. You know what you are attempting and leave out details because it is likely obvious to you. We however do not know anything about the history or your data, the contents or implied rules.   It might be a good idea to paste your current code into a code box opened with the forum's {I} or "running man" icon. That way we could see what changes to existing code might be possible. ... View more

you can rusbmit on your own machine or remote machine. when you run on your machine sas opens instances and run your job(s) parallel and then we can send data to your current sas work folder ... View more