https://communities.sas.com/t5/SAS-Data-Science/How-do-I-collect-certain-sections-of-EDGAR-txt-data-using-SAS/m-p/607762#M10057 <P>That sort of message text may be easier to open the files and read for the information as I can't see anything in that example text that indicates anything resembling a codable approach to determining much of anything in it much less lawyer names, firms and addresses.</P> <P>&nbsp;</P> <P>You may be able to get a LIBNAME URL to point to those locations and find the name of specific files such as the text file on the "Complete submission text file" line of the web page and create something to FTP those files. But the internal contents are not very "nice"</P> <P>unless you are aware of a document that indicates how to find what you want from those text files.</P> Wed, 27 Nov 2019 16:08:36 GMT ballardw 2019-11-27T16:08:36Z https://communities.sas.com/t5/SAS-Data-Science/How-do-I-collect-certain-sections-of-EDGAR-txt-data-using-SAS/m-p/607740#M10056 <TABLE><TBODY><TR><TD><A href="http://www.sec.gov/Archives/edgar/data/1058664/0001012870-99-001562-index.htm" target="_blank" rel="noopener">http://www.sec.gov/Archives/edgar/data/1058664/0001012870-99-001562-index.htm</A></TD></TR><TR><TD><A href="http://www.sec.gov/Archives/edgar/data/1062781/0000919574-06-001758-index.htm" target="_self">http://www.sec.gov/Archives/edgar/data/1062781/0000919574-06-001758-index.htm</A></TD></TR><TR><TD><A href="http://www.sec.gov/Archives/edgar/data/1065736/0001047469-99-017816-index.htm" target="_self">http://www.sec.gov/Archives/edgar/data/1065736/0001047469-99-017816-index.htm</A></TD></TR><TR><TD><A href="http://www.sec.gov/Archives/edgar/data/1067491/0001012870-99-000409-index.htm" target="_self">http://www.sec.gov/Archives/edgar/data/1067491/0001012870-99-000409-index.htm</A></TD></TR><TR><TD><A href="http://www.sec.gov/Archives/edgar/data/1070294/0000892569-98-002605-index.htm" target="_self">http://www.sec.gov/Archives/edgar/data/1070294/0000892569-98-002605-index.htm</A></TD></TR><TR><TD><A href="http://www.sec.gov/Archives/edgar/data/1078276/0000950146-99-000491-index.htm" target="_self">http://www.sec.gov/Archives/edgar/data/1078276/0000950146-99-000491-index.htm</A></TD></TR><TR><TD><A href="http://www.sec.gov/Archives/edgar/data/1078749/0001047469-99-004249-index.htm" target="_self">http://www.sec.gov/Archives/edgar/data/1078749/0001047469-99-004249-index.htm</A></TD></TR><TR><TD><A href="http://www.sec.gov/Archives/edgar/data/1084577/0000891618-99-002267-index.htm" target="_self">http://www.sec.gov/Archives/edgar/data/1084577/0000891618-99-002267-index.htm</A></TD></TR><TR><TD><A href="http://www.sec.gov/Archives/edgar/data/1084587/0000950162-00-000098-index.htm" target="_self">http://www.sec.gov/Archives/edgar/data/1084587/0000950162-00-000098-index.htm</A></TD></TR><TR><TD><A href="http://www.sec.gov/Archives/edgar/data/1086329/0000891020-99-001194-index.htm" target="_self">http://www.sec.gov/Archives/edgar/data/1086329/0000891020-99-001194-index.htm</A></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Above are ten of the URL's I have on an excel spreadsheet.&nbsp;</P><P>Within these URL's are txt data.&nbsp;</P><P>For example,&nbsp;</P><P><A title="https://www.sec.gov/Archives/edgar/data/1058664/0001012870-99-001562.txt" href="https://www.sec.gov/Archives/edgar/data/1058664/0001012870-99-001562.txt" target="_self"><FONT>https://www.sec.gov/Archives/edgar/data/1058664/0001012870-99-001562.txt</FONT></A></P><P>&nbsp;</P><P>I would like to collect the following data from each file.&nbsp;</P><TABLE><TBODY><TR><TD>firm_lawfirm</TD><TD>firm_lawfirm_Address</TD><TD>firm_lawyer1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Must this be done manually? or is there a smarter way?&nbsp;</P><P>&nbsp;</P> Wed, 27 Nov 2019 15:39:13 GMT https://communities.sas.com/t5/SAS-Data-Science/How-do-I-collect-certain-sections-of-EDGAR-txt-data-using-SAS/m-p/607740#M10056 lovethyneighbor 2019-11-27T15:39:13Z https://communities.sas.com/t5/SAS-Data-Science/How-do-I-collect-certain-sections-of-EDGAR-txt-data-using-SAS/m-p/607762#M10057 <P>That sort of message text may be easier to open the files and read for the information as I can't see anything in that example text that indicates anything resembling a codable approach to determining much of anything in it much less lawyer names, firms and addresses.</P> <P>&nbsp;</P> <P>You may be able to get a LIBNAME URL to point to those locations and find the name of specific files such as the text file on the "Complete submission text file" line of the web page and create something to FTP those files. But the internal contents are not very "nice"</P> <P>unless you are aware of a document that indicates how to find what you want from those text files.</P> Wed, 27 Nov 2019 16:08:36 GMT https://communities.sas.com/t5/SAS-Data-Science/How-do-I-collect-certain-sections-of-EDGAR-txt-data-using-SAS/m-p/607762#M10057 ballardw 2019-11-27T16:08:36Z