extraction of data

[sanjus]

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

[Kurt_Bremser]

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.

[sanjus]

sorry for the link 

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

thanks in advance

[Kurt_Bremser]

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.

[sanjus]

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