https://communities.sas.com/t5/SAS-Programming/Web-scraping-using-sas/m-p/917717#M361506 Hi Everyone,<BR /><BR />Is it possible in sas to do web scraping accurately, Go to a website and enter the zip code as shown in picture 1 and extract the city and other city information from picture 2 and store into a dataset. And again go to "edit and search again" in picture 2 and search for new zip code ?<BR />Can I do it for more than 1000+ zips ? Sat, 24 Feb 2024 06:00:20 GMT shivagujjaru 2024-02-24T06:00:20Z https://communities.sas.com/t5/SAS-Programming/Web-scraping-using-sas/m-p/917717#M361506 Hi Everyone,<BR /><BR />Is it possible in sas to do web scraping accurately, Go to a website and enter the zip code as shown in picture 1 and extract the city and other city information from picture 2 and store into a dataset. And again go to "edit and search again" in picture 2 and search for new zip code ?<BR />Can I do it for more than 1000+ zips ? Sat, 24 Feb 2024 06:00:20 GMT https://communities.sas.com/t5/SAS-Programming/Web-scraping-using-sas/m-p/917717#M361506 shivagujjaru 2024-02-24T06:00:20Z https://communities.sas.com/t5/SAS-Programming/Web-scraping-using-sas/m-p/917743#M361518 <P>I don't dare to download and open your attachment ...</P> <P>, but it occurs to me you need PROC HTTP.</P> <P>&nbsp;</P> <P>Just put all 1000+ zip-codes you want in a data set column and call PROC HTTP once per zip-code (you can easily do that with a macro loop or with call execute).</P> <P>&nbsp;</P> <UL class="lia-list-style-type-square"> <LI>SAS® 9.4 and SAS® Viya® 3.5 Programming Documentation<BR />Base SAS Procedures Guide<BR />HTTP Procedure<BR />Using the FORM and QUERY Options with PROC HTTP<BR /><A href="https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/proc/p1wdzhcr5sytabn1frd37t7bpwuq.htm" target="_blank">https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/proc/p1wdzhcr5sytabn1frd37t7bpwuq.htm</A></LI> <LI>How to scrape data from a web page using SAS?<BR />By Chris Hemedinger on The SAS Dummy December 4, 2017<BR /><A href="https://blogs.sas.com/content/sasdummy/2017/12/04/scrape-web-page-data/" target="_blank">https://blogs.sas.com/content/sasdummy/2017/12/04/scrape-web-page-data/</A></LI> </UL> <P>Koen</P> Sat, 24 Feb 2024 23:09:42 GMT https://communities.sas.com/t5/SAS-Programming/Web-scraping-using-sas/m-p/917743#M361518 sbxkoenk 2024-02-24T23:09:42Z