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
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.
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!
Thank you very much for your response, most appreciated.
Please find attached the macro.
Regards.
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
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: