Web scraping using sas

[shivagujjaru]

Hi Everyone,

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 ?
Can I do it for more than 1000+ zips ?

[sbxkoenk]

I don't dare to download and open your attachment ...

, but it occurs to me you need PROC HTTP.

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).

• SAS® 9.4 and SAS® Viya® 3.5 Programming Documentation
  Base SAS Procedures Guide
  HTTP Procedure
  Using the FORM and QUERY Options with PROC HTTP
  https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/proc/p1wdzhcr5sytabn1frd37t7bpwuq.htm
• How to scrape data from a web page using SAS?
  By Chris Hemedinger on The SAS Dummy December 4, 2017
  https://blogs.sas.com/content/sasdummy/2017/12/04/scrape-web-page-data/

Koen