topic Re: extraction of data in SAS Data Science

extraction of data

sanjus — Mon, 18 Feb 2019 09:36:22 GMT

Hi,

I want to extract data from this website " https://trends.google.com/trends/explore?q=wells%20fargo%20fake%20account&geo=US "

It's a google trend website.

can anyone help me with this. I am very much new to this.

Note: not through downloading the csv file.

Thanks in Advance

Re: extraction of data

Kurt_Bremser — Mon, 18 Feb 2019 09:31:37 GMT

Your link does not work, I get a "Oops" message".

The link is resolved to "https://trends.google.com/trends/explore?q=citi%20bank%20fake%20accounts&geo=US%22%C2%A0" by the browser.

Re: extraction of data

sanjus — Mon, 18 Feb 2019 09:34:58 GMT

sorry for the link

please try this link "https://trends.google.com/trends/explore?q=wells%20fargo%20fake%20account&geo=US"

thanks in advance

Re: extraction of data

Kurt_Bremser — Mon, 18 Feb 2019 11:26:55 GMT

Try this code:

filename http_out temp;

proc http
  url="https://trends.google.com/trends/explore?q=wells%20fargo%20fake%20account&geo=US"
  method="get"
  out=http_out
;
run;

data response;
infile http_out truncover;
input line $100.;
run;

and look if SAS retrieves the web page. If yes, look at the resulting dataset (you may have to increase the size of line and the lrecl of the infile) to see if your data is in there.

If you are able to find the part that creates the CSV download URL, you might be off best to use that and read the csv file.

Re: extraction of data

sanjus — Mon, 18 Feb 2019 12:47:41 GMT

getting error :

This is the log:

filename http_out temp;

2531

2532 proc http

2533 url="https://trends.google.com/trends/explore?q=wells%20fargo%20fake%20account&geo=US"

WARNING: Apparent symbolic reference GEO not resolved.

2534 method="get"

2535 out=http_out

2536 ;

2537 run;

ERROR: Windows SSL error -2146893048 (0x80090308) occurred at line 2389, the error message is

"The token supplied to the function is invalid "

ERROR: Secure communications error status 807ff008 description "Windows SSL error -2146893048

(0x80090308) occurred at line 2389, the error message is "The token supplied to the

function is invalid ""

ERROR: Encryption run-time execution error

ERROR: Windows SSL error -2146893048 (0x80090308) occurred at line 2389, the error message is

"The token supplied to the function is invalid "

ERROR: Secure communications error status 807ff008 description "Windows SSL error -2146893048

(0x80090308) occurred at line 2389, the error message is "The token supplied to the

function is invalid ""

ERROR: Encryption run-time execution error

ERROR: Call to tcpSockContinueSSL failed.

NOTE: PROCEDURE HTTP used (Total process time):

real time 0.23 seconds

cpu time 0.06 seconds