Hello @sonikm24,   could you please provide an example that is describing the problem? Your excel-file seems to contain no information and your dataset 'sonik' is missing. It would be best, if you could provide some sample dataset, so that we can work on the problem without having to crawl the websites.   From what I understand, you want to output certain rows of a dataset. For instance row 50, because some condition applies and then you also want row 49 and row 51, because they surround row 50?!   There are a number of ways, you could achieve that. Possibly a retain statement (with optional by-processing) could do the trick. Another option would be to use a hash and hash-iterator.   Cheers, Michael ... View more

Hello @Astounding,                                   I inserted the snippet of code that you mentioned in your above message to my sas code. I have attached the integrated code with the mail for your reference (and also a excel file to test). But when I am running the code, the full sec file is getting returned, and not the required code lines. Please let me know if I am doing any mistake adding your part of code to my code (I have just commented the data SiteVisitnew part on my code and added your code) Thanks. Sonik Mandal ... View more

Hello Cynthia,                         I have used a different function to find multiple instances of keywords (see the code attached). But I am having a problem when I am trying to output lines surrounding the keywords. I am trying to increase the output lines for every instance of the keyword in the sec file. E.g. if there are 5 instances of "Notional" in the sec file, i am trying to output lines surrounding each one of the instances of the keyword. In the code, I am using the following lines of code for that purpose:      if (0 < countC2 <= 10) then do;             output;             end; But this code is not able to increase or decrease the output lines surrounding the keywords even by changing 10 to 15 or 5. Please let me know the problem in the code. I have attached the code and a sample excel file. Thanks. Sonik Mandal ... View more