cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
sonikm24
‎09-01-2015
  • 6 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

web crawler

by Calcite | Level 5 in SAS Programming
‎04-16-2014 10:24 PM
‎04-16-2014 10:24 PM
Hello,            I have using a web crawler to find multiple instances of keywords (in the code I am searching for "Notional") from sec files (see the code attached). I am using the prxnext function to do the job. 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 (see the attached sas code) But this code is not able to increase or decrease the output lines surrounding the keywords even by changing 10 to 15 or 5. Can anyone help with the issue? I have attached the code and a sample excel file. Thanks. Sonik Mandal ... View more

Re: web crawler for finding multiple instances of the same keyword

by Calcite | Level 5 in SAS Programming
‎04-10-2014 05:16 PM
‎04-10-2014 05:16 PM
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

web crawler for finding multiple instances of the same keyword

by Calcite | Level 5 in SAS Programming
‎04-04-2014 10:55 PM
‎04-04-2014 10:55 PM
Hello,            I have using a web crawler to find multiple instances of keywords (in the code I am searching for "Notional") from sec files (see the code attached). I am using the prxnext function to do the job. 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. Can anyone help with the issue? I have attached the code and a sample excel file. Thanks. Sonik Mandal ... View more

Re: web crawler macro

by Calcite | Level 5 in SAS Programming
‎04-02-2014 08:10 PM
‎04-02-2014 08:10 PM
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

Re: web crawler macro

by Calcite | Level 5 in SAS Programming
‎03-09-2014 10:30 PM
‎03-09-2014 10:30 PM
Hello Cynthia,                           Thanks for the reply and also for sending the example code. No, this program, I am using for data collection in my thesis work. This code is taken originally from a paper and one of the authors is from the school mentioned in the code. I am using the prxnext() function instead of the index function now. Trying to integrate that into the macro. If i face any problems, I will let you know in the forum. Thanks, Sonik Mandal ... View more

web crawler macro

by Calcite | Level 5 in SAS Programming
‎03-09-2014 01:11 PM
‎03-09-2014 01:11 PM
Hello,            I am using a web crawler program to find some specific keywords ("futures", "forwards", "notional" etc.) in the 10k reports from the sec edgar database. Once the code finds the keyword, I am printing 5 (or 10) lines around the keyword to get the derivative values. The code is working, and it is fetching data but not all the required data. What the current code is doing is looking at the keywords just once and then returning lines surrounding that. For e.g. if there are 4 or 5 instances of "Notional" in the 10k, it is just looking at the first notional keyword in 10k, and returning lines surrounding that. Then it is looking at the next keyword and next.      Rather than looking at all the instances of keywords, it is just looking at the first one it finds and moving on to the next one. I hope you understand the problem. I have attached the sas code with the mail. Can anyone help me with the issue? Sonik Mandal ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Quick links