topic Re: Import the txt file that is web php response in SAS Programming

Import the txt file that is web php response

SASdevAnneMarie — Mon, 15 Mar 2021 12:24:08 GMT

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 !

Re: Import the txt file that is web php response

japelin — Tue, 16 Mar 2021 03:22:53 GMT

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.

Re: Import the txt file that is web php response

SASdevAnneMarie — Tue, 16 Mar 2021 08:42:42 GMT

Thank you, Kawakami !
That works !