I am a fairly new SAS VA 7.3 user and also new to analyzing social media. I am working with a large client with many individual locations and wanted to find a way to download Yelp reviews and load them into SAS VA. SAS VA allows for an automated download from FaceBook and Twitter but I don't see an options for Yelp. I created some reviews to load into SAS VA to display in a text Word Cloud with the sentiment option. I didn't really get the result I was hoping for, any other suggestions on how best to display this data would be much appreciated.
Hi Idenney, that sounds very interesting. I don't know if your client has a way to access the reviews on their own businesses. I would hope so. I'm not too familiar with the Yelp API, but it appears from the FAQ: https://www.yelp.com/developers/faq and ToS that they do not allow full review text access by third parties via API or "scraping" (a SAS or other program to efficiently retrieve this text via API or spiders/robots). Assuming you can legally and technically retrieve this text you'll need a unique document ID for the variable you want to make a document collection. For example, if you have a Review variable and a ReviewID variable, right click on Review and make it a Document Collection, then select ReviewID as the Document ID.
Thanks! I'm checking with my client to see if they have a business account set up for each of their business units. The weblink you provided will be helpful. Is your description of the document collection referring to SAS VA word cloud? I'm not sure I'm following you.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.