Tuesday, May 5. 2009Running SAS PROCs on your Facebook Friends
Question: What do you get when you cross your Facebook friends with SAS analytics?
Answer: Insight, probably more about yourself than anything else. You can tell a lot about yourself by looking at your friends. And I'll bet that so can Facebook and those who advertise on it.  Data from social media sites is ripe for analysis, and Facebook data is more structured than most. I've developed an application that turns your Facebook friends data into a SAS program so that you can run reports and analytics on them. Some reports are easy to understand, such as the above chart that buckets my friends into "life stages" based on graduation years. Or you can leverage the heavy duty analytics, such as this correspondence analysis from PROC CORRESP (hover your mouse over the image for a more technical explanation).  I developed the application as an example task for SAS Enterprise Guide 4.2 for a book that I'm working on. I'm a ways away from being done with the book, but we are so keen on Twitter, Facebook, and social media in general right now that I decided to share it early. If you aren't using SAS Enterprise Guide 4.2, you're not completely out of luck. You can also run the application on its own to create the program, and then run the program in SAS 9.2 however you want. The program produces:
You can download the task/program from here. Instructions for deployment and use are in the README.txt file in the ZIP archive. Note: you'll need Microsoft .NET 3.5, a Facebook account (of course), and you'll need to allow my registered application ("ImportToSAS") to access your account information. Don't worry; none of your Facebook information is gathered/stored anywhere except for in the resulting program file. Manifest of technologies includes: Facebook Toolkit for .NET (to connect to Facebook and gather data), XML Libname engine along with XML Mapper (to get the "friends" data into data sets), the SGPLOT procedure (to produce bar charts), ODS tagsets.htmlpanel (to control report layout for side-by-side charts), ODS Graphics in SAS/STAT (for correspondence plot), and custom task APIs for running within SAS Enterprise Guide. Comments
Display comments as
(Linear | Threaded)
Hello Chris,
Nice! Any chance of getting source code for this? Thanks. Richard,
Yes, I'll work on a version of the source code that I can share out. I developed this as an example, so the source code will come in handy to show what you can do with custom tasks in EG. Chris Nice example of how to use SAS to perform basic social networking analytics.
Ralph Winters Hi Chris,
I really like this application. Is it possible to adapt the code to extract information from a fan page? Pauline Very interesting tools to enlarge sas capabilities on the web . I'd tried it . Nice...
Hi Chris,
Very cool sample. I am looking for some documentation on developing custom task add-ins for the new 4.2 version of Enterprise Guide. I've already built custom task add-ins for the 4.1 version and a small .Net library which provides an abstraction layer (a facade) when consuming SAS "services" from .Net code and now I'm considering migrating those for the 4.2. Still now I only found 2 samples on the web (SAS.Tasks.Examples.GKPI.dll and yours) and I see that all are requiring the "SAS.Tasks.Toolkit.dll" assembly. Can you please provide a link to some place where I cand download the required tools (SAS Task Toolkit, for ex) and other samples for creating EG 4.2 add-ins ? Regards, Catalin Manoliu |
ABOUT CHRIS Chris Hemedinger is a senior software manager in SAS R&D. He's part of the team that builds SAS Enterprise Guide and SAS Add-In for Microsoft Office. He's also co-author of the popular SAS for Dummies book and moderator of the SAS Enterprise Guide discussion forum.
QuicksearchSyndicate This BlogOther SAS BlogsBI and Chicken Pot PieConversations and Connections Data Flux Community of Experts Closing the Intelligence Gap In Other Words In the Final Analysis JMP Blog Key Happenings at support.sas.com The New Lending System The Text Frontier SAS Global Forum Blog sascom Voices Blog A Shot in the Arm All SAS Blogs Recent postsUsing the X and SYSTASK commands from SAS Enterprise Guide
19Nov2009 Learn about ODS Statistical Graphics 06Nov2009 Hooo-ray for Hollywood 03Nov2009 Where to find ODS Statistical Graphics in SAS Enterprise Guide 23Oct2009 Welcome sasCommunity visitors! 21Oct2009 Do me a favor: stop doing me favors 20Oct2009 You can use it for evil, too 16Oct2009 The CIO perspective from MWSUG 13Oct2009 SAS 9.2 and SAS Enterprise Guide 4.2 on Windows 7 01Oct2009 SAS 9.2 support for Windows Server 2008 30Sep2009 BOOKS & VIDEOS SAS for Dummies -- If you want to learn to be productive using the latest SAS tools and technologies in your daily work, but don't necessarily want to learn SAS programming, then this book was written for you!  Efficient Data Access with SAS Enterprise Guide (YouTube) -- Shows the best way to access data in a DBMS from SAS Enterprise Guide, using M&Ms as a prop.  Exciting combinations: SAS and Microsoft Office (YouTube) -- A metaphor for the exciting features you get when you add the SAS Add-In for Microsoft Office to your desktop.
The blog content appearing on this site does not necessarily represent the opinions of SAS. Your use of this blog is governed by the Terms of Use.
|
I've just returned from the Los Angeles Basin SAS Users Group (LABSUG), where I both presented a talk and learned from others. (The meeting was in Pasadena, but I did get a chance to tour the area, as you can see from my picture.) The title of my tal
Tracked: Nov 03, 15:19