topic Re: MacSAS Macro to read JSON formatted tweets in SAS Programming

Macro to Scrap Twitter - SAS Macro to read JSON formatted tweets

crimbo — Fri, 23 Sep 2016 14:23:50 GMT

I have a macro to scrap tweets on Twitter and return details of the tweet in columns. The macro is using PROC HTTP. When i run the macro i get the following error messages:

ERROR: Host name resolution failed

Does this mean i am failing to access the Twitter page through their API?

Does SAS University Edition able to write and read JSON files?

Regards.

Re: Macro to Scrap Twitter - SAS Macro to read JSON formatted tweets

RW9 — Fri, 23 Sep 2016 15:15:25 GMT

You would need to provide some code, how are you connecting, are you providing correct login details etc. Proc http requires correct signin details, and connection. You might want to set it up in conjunction with your IT group, and make sure passwords and such like are encrypted.

SAS UE is principally a learning edition, it doesn't have full functionality either, and as its installed on Linu image rather than your local machine this could also be a problem.

As for Json, there is no out of the box reader as far as I am aware. However, it is plain text, so should be pretty easy to read in and parse, however as you are using a learning edition of SAS it sounds like your learning, so maybe not the best task to start with.

And the phrase is "scrape" the data, although I would quite happily scrap social media!

Re: MacSAS Macro to read JSON formatted tweets

crimbo — Sun, 25 Sep 2016 15:12:30 GMT

Thank you very much for your response, most appreciated.

Please find attached the macro.

Regards.

SAS Macro to read JSON formatted tweets

crimbo — Sun, 25 Sep 2016 21:25:54 GMT

Further to my last post, i managed to find a solution with a simple code in R. Once again thank you very much for your input