Import the txt file that is web php response

[SASdevAnneMarie]

Hello Experts,

You know that in web, there is the request (the client's request -> server) and the response (server -> client's browser). The response from http://XXXXXX is a file stream type txt (generated with php).

So physical file doesn't exist, while clicking on  http://XXXXXX

I'm wondering if there is possible to import this kind of file ? 

Thank you for helping !

[japelin · Accepted solution]

If you use SAS 9.4(M3 and later), you can use proc http.

Try this code.

filename webdoc 'c:/temp/want.txt' encoding='utf-8';  
proc http  
 method="get"  
 url="https://www.google.com/"  
 out=webdoc;  
run;  
  
data test;  
 infile webdoc;  
 attrib buf length=$4096;  
 input buf $4096.;  
 put buf=;  
run;  

you can get 'c:/temp/want.txt' as a text file, and 'WORK.TEST' as a dataset.

[SASdevAnneMarie]

Thank you, Kawakami !
That works !