https://communities.sas.com/t5/SAS-Programming/AUTOMATING-LOGIN-AND-DOWNLOAD-PROCESS-USING-SAS/m-p/916039#M360891 <P>Hi Everyone, Hope you all have been better. I'm trying to find a way to use sas to automatically login to a website and then go to a particualr tab to download all the data into excel files. Unfortunately it doesn't offer any api and it's not open to the internet. Any information you can provide is appreciated. Thankyou!.</P> Wed, 14 Feb 2024 12:15:45 GMT Pandu2 2024-02-14T12:15:45Z https://communities.sas.com/t5/SAS-Programming/AUTOMATING-LOGIN-AND-DOWNLOAD-PROCESS-USING-SAS/m-p/916039#M360891 <P>Hi Everyone, Hope you all have been better. I'm trying to find a way to use sas to automatically login to a website and then go to a particualr tab to download all the data into excel files. Unfortunately it doesn't offer any api and it's not open to the internet. Any information you can provide is appreciated. Thankyou!.</P> Wed, 14 Feb 2024 12:15:45 GMT https://communities.sas.com/t5/SAS-Programming/AUTOMATING-LOGIN-AND-DOWNLOAD-PROCESS-USING-SAS/m-p/916039#M360891 Pandu2 2024-02-14T12:15:45Z https://communities.sas.com/t5/SAS-Programming/AUTOMATING-LOGIN-AND-DOWNLOAD-PROCESS-USING-SAS/m-p/916059#M360901 <P>Depending on the login style, the task might not be possible with just SAS code. If there is no API and the login is anything but Basic Auth (user/pw), it can get tricky.</P> <P>&nbsp;</P> <P>However, PROC HTTP can do a lot of things. Check out <A href="https://communities.sas.com/t5/Ask-the-Expert/How-Do-You-Use-SAS-to-Access-Data-and-APIs-From-the-Web-Q-amp-A/ta-p/699613" target="_self">the webinar and resources here</A>.</P> <P>&nbsp;</P> Wed, 14 Feb 2024 14:04:04 GMT https://communities.sas.com/t5/SAS-Programming/AUTOMATING-LOGIN-AND-DOWNLOAD-PROCESS-USING-SAS/m-p/916059#M360901 ChrisHemedinger 2024-02-14T14:04:04Z