Thursday, December 4. 2008Import SPSS data files into SAS Enterprise Guide
I'd love to believe that our loyal SAS customers never have to touch a statistical package from another company. Even as I work away in my comfy SAS bubble here in Cary, NC, I occasionally catch wind of stories about SAS customers who need to use data that comes from other products, such as SPSS, Stata, and even our own JMP.
Since version 9.1.3, SAS has supported an easy method to import these data files using the IMPORT procedure. With just a few lines of code and the help of our SAS/ACCESS to PC Files product, you can write a SAS program that slurps that data into a SAS data set. (You can use the EXPORT procedure to convert SAS data sets to these third-party formats too -- just in case you ever need that.) To make it even easier for our SAS Enterprise Guide users, I built a set of simple tasks that you can use with SAS Enterprise Guide 4.1 -- no programming necessary. You can download the task here. (It's a ZIP file; use the README.txt instructions for simple installation.) When you install it and restart SAS Enterprise Guide, you'll see an additional three items in the Add-Ins menu: one for each of the supported file types: SPSS (.sav), JMP, and Stata (.dta) files. The tasks are simple to use: you pick the file to import, and the task copies the file to your SAS server (if your SAS session is on a remote host) and then runs the IMPORT procedure. The resulting SAS data is stored in your WORK library, and the data and SAS log are both added to your project. (Note these requirements: you need at least SAS 9.1.3 with SAS/ACCESS to PC Files installed on your SAS machine.) Try it out! And then please tell me how it goes by adding your comments back here on the blog. By the way, these tasks are "baked in" for SAS Enterprise Guide 4.2, our forthcoming release, along with many other new tasks and features that I'll blog about soon. Comments
Display comments as
(Linear | Threaded)
Any chance we can get this functionality w/o needing SAS/ACCESS? I work in marketing research and 100% of our data comes in SPSS even though I work exclusively in SAS (and primarily in EG). I would use the import from SPSS every day, but wouldn't need all of the other stuff that comes with SAS/ACCESS, which is why my (small) business won't purchase it. (Note : there is no additional plug-in needed in SPSS to import or export SAS data.)
Jeremy,
Alas, no. The ability to read and write SPSS files is currently bundled with the SAS/ACCESS to PC Files product, which also supports many other formats including Excel, MS Access, JMP, Stata and others listed here: http://support.sas.com/documentation/cdl/en/acpcref/59619/HTML/default/a003103610.htm Chris Hi,
I came across this page looking for information on converting sav and sps files to some usable form for JMP, since JMP doesn't recognize them in their original form. Can this be done? My PC does not have SPSS (hence my problem) or anything other stats software, only JMP. Thanks for your help. Jamie,
I don't know the answer, but this is a perfect question to post to the new JMP discussion forum on the SAS support site: http://support.sas.com/forums/forum.jspa?forumID=43 Chris The SPSS conversion addin seems good, but still limited in ability. For instance how will I get the formats loaded? (The value labels that are available in SPSS). There is no point in just loading the data and having to spend a lot of time formatting the value labels.
Thanks Vignesh use the following code to get the formats loaded (data value labels that are available in spss)
proc format lib=libraryname cntlout=newsasdatasetname ; run; the data value labels that are available in spss are stored in the cntlout=new sas data set name |
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 postsCustom tasks that do the job
31Jan2010 Who's who in your SAS metadata environment 27Jan2010 Numero Uno 21Jan2010 Predictive analytics vs. forecasting: what's the difference? 15Jan2010 Fun and fashion at SAS Global Forum 2010 08Jan2010 Why I review SAS Press books 08Jan2010 "You have Jail" 04Jan2010 SAS Enterprise Guide for Programmers: The Movie 21Dec2009 Greatest hits from 2009 16Dec2009 SAS Talks: You listening? 10Dec2009 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.
|
2009 is almost over, and us SAS employees are busy compiling information for our managers to answer the question, "Just what did you do this year, anyway?" I'm asking the same question of you, Dear Reader. What did you get from this blog in 2009? H
Tracked: Dec 16, 09:03
Andy wrote in the NOTE: blog that he's stumbled upon a few custom tasks to extend features in SAS Enterprise Guide. He wondered aloud whether there might be more "free" tasks out there, available for use by anyone who can find them and download them.
Tracked: Jan 31, 15:17