|
Hi All,
Can someone give suggestions on the constructs/domains that are used to assess student leadership. Thank you in advance. Juanito New Email names for you! Get the Email name you've always wanted on the new @ymail and @rocketmail. Hurry before someone else does! http://mail.promotions.yahoo.com/newdomains/ph/ ====================To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD |
|
Hello everybody,
I would like know more about the possibilities of using MS Access data in SPSS. I have a lot of syntaxes in SPSS and until now my data were stored in SPSS-sav-files. Pretty soon my data wil be moved to MS Access and I'm looking for information, books, websites, tips to keep on using SPSS for tables and graphs. What is the best way: - start SPSS and read the data form Access and create the required output OR - let Access operate SPSS in order to get the required output. Thank you. Max ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD |
|
Hello Max,
Using odbc and sql you can read access data files as if they were spss data files. Converting is not necessary. I would never try to use access to operate spss (that sounds rather complicated). Frans ------------------------------------------- Frans Marcelissen email [hidden email] -----Oorspronkelijk bericht----- Van: SPSSX(r) Discussion [mailto:[hidden email]] Namens Max Bell Verzonden: maandag 10 november 2008 10:21 Aan: [hidden email] Onderwerp: Use MS Access data in SPSS Hello everybody, I would like know more about the possibilities of using MS Access data in SPSS. I have a lot of syntaxes in SPSS and until now my data were stored in SPSS-sav-files. Pretty soon my data wil be moved to MS Access and I'm looking for information, books, websites, tips to keep on using SPSS for tables and graphs. What is the best way: - start SPSS and read the data form Access and create the required output OR - let Access operate SPSS in order to get the required output. Thank you. Max ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD |
|
In reply to this post by Max Bell-2
>Date: Mon, 10 Nov 2008 10:20:32 +0100
>From: Max Bell <[hidden email]> >Subject: Use MS Access data in SPSS > >Hello everybody, >I would like know more about the possibilities of using MS Access data in SPSS. I have a lot of syntaxes in SPSS and until now my data were stored in SPSS-sav-files. Pretty soon my data wil be moved to MS Access and I'm looking for information, books, websites, tips to keep on using SPSS for tables and graphs. > >What is the best way: >- start SPSS and read the data form Access and create the required output OR >- let Access operate SPSS in order to get the required output. Hello Max, Your first suggestion is clearly preferable as it is easy to read ACCESS data with SPSS. However, I do not quite understand why you want to convert .sav files to .mdb files. I assume you must have your reasons. I use both ACCESS and SPSS v15. They work well together. * ACCESS is nice for live data, because it allows others to connect to the database and add data, or make limited updates, while I use SPSS to do analysis of the data. I would never allow any users to touch one of my SPSS datafiles. For example, our office uses a ACCESS database for a phonelog. A few times a year I run a script that reads the data to SPSS and makes a pile of tables and figures. * ACCESS is better for creating nice layout for Reports that present cases. That is, if you want to present a lot of the data you have as it is, but just sorted in a nice way with a few simple things added. I run for example a "Best Practices" database, and it is easier to make professional layout for reports that present lists of best practices with ACCESS than with SPSS. * ACCESS is seems to be faster (but less flexible) for joining tables using views (or SQL queries) than SPSS is for matching datafiles. So if you have many tables in ACCESS that relate to each other, use views in ACCESS to join them first to a single flat file, rather than importing them table by table to SPSS for matching. * For everything else I prefer SPSS only (or perhaps with a proper SQL database). One way to use ACCESS and SPSS together: 1) Create a syntax file with the help of the Database Connectivity Wisard. Paste and clean up a little bit. 2) Add to this syntax file variable labels, variable formats, and do some necessary recoding. Change the variable names so that they fit your old scripts. Time and date variables often need some fixing to get nice results. 3) Optionally: Save a copy of the outfile. If the database is alive, you do not even need to save your new datafile. I prefer to save a copy with a date in the filename, (it is nice to be able to reproduce tables for a particular date in the past). I do much of my analysis on the "live" datafile. The saved file is just for rerunning analyses to check if my new and "improved" recodings give same results as the old ones. Nevertheless, I always use a saved copy of the datafile used to make tables and figures for a publication for the sake of consistency. 4) Run your old scripts . Best, Eero ________________________________________ Eero Olli Advisor the Equality and Anti-discrimination Ombud [hidden email] +47 2405 5951 POB 8048 Dep, N-0031 Oslo, Norway ====================To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD |
|
There is a great coverage on this topic in Chapter 9 of the
Programming and Data Management for SPSS Statistics 17.0 book, which you can download in a PDF format from: http://www.spss.com/statistics/base/data_management_book.htm Cheers, Jason On Wed, Nov 12, 2008 at 5:17 AM, Eero Olli <[hidden email]> wrote: >>Date: Mon, 10 Nov 2008 10:20:32 +0100 >>From: Max Bell <[hidden email]> >>Subject: Use MS Access data in SPSS >> >>Hello everybody, >>I would like know more about the possibilities of using MS Access data > in SPSS. I have a lot of syntaxes in SPSS and until now my data were > stored in SPSS-sav-files. Pretty soon my data wil be moved to MS Access > and I'm looking for information, books, websites, tips to keep on using > SPSS for tables and graphs. >> >>What is the best way: >>- start SPSS and read the data form Access and create the required > output OR >>- let Access operate SPSS in order to get the required output. > > Hello Max, > > Your first suggestion is clearly preferable as it is easy to read ACCESS > data with SPSS. However, I do not quite understand why you want to > convert .sav files to .mdb files. I assume you must have your reasons. > > I use both ACCESS and SPSS v15. They work well together. > * ACCESS is nice for live data, because it allows others to connect to > the database and add data, or make limited updates, while I use SPSS to > do analysis of the data. I would never allow any users to touch one of > my SPSS datafiles. For example, our office uses a ACCESS database for > a phonelog. A few times a year I run a script that reads the data to > SPSS and makes a pile of tables and figures. > * ACCESS is better for creating nice layout for Reports that present > cases. That is, if you want to present a lot of the data you have as it > is, but just sorted in a nice way with a few simple things added. I run > for example a "Best Practices" database, and it is easier to make > professional layout for reports that present lists of best practices > with ACCESS than with SPSS. > * ACCESS is seems to be faster (but less flexible) for joining tables > using views (or SQL queries) than SPSS is for matching datafiles. So if > you have many tables in ACCESS that relate to each other, use views in > ACCESS to join them first to a single flat file, rather than importing > them table by table to SPSS for matching. > * For everything else I prefer SPSS only (or perhaps with a proper SQL > database). > > One way to use ACCESS and SPSS together: > 1) Create a syntax file with the help of the Database Connectivity > Wisard. Paste and clean up a little bit. > 2) Add to this syntax file variable labels, variable formats, and do > some necessary recoding. Change the variable names so that they fit your > old scripts. Time and date variables often need some fixing to get nice > results. > 3) Optionally: Save a copy of the outfile. If the database is alive, > you do not even need to save your new datafile. I prefer to save a copy > with a date in the filename, (it is nice to be able to reproduce tables > for a particular date in the past). I do much of my analysis on the > "live" datafile. The saved file is just for rerunning analyses to check > if my new and "improved" recodings give same results as the old ones. > Nevertheless, I always use a saved copy of the datafile used to make > tables and figures for a publication for the sake of consistency. > 4) Run your old scripts . > > Best, > Eero > > ________________________________________ > Eero Olli > Advisor > the Equality and Anti-discrimination Ombud > [hidden email] +47 2405 5951 > POB 8048 Dep, N-0031 Oslo, Norway > > > > > To manage your subscription to SPSSX-L, send a message to > [hidden email] (not to SPSSX-L), with no body text except the > command. To leave the list, send the command > SIGNOFF SPSSX-L > For a list of commands to manage subscriptions, send the command > INFO REFCARD > ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD |
| Free forum by Nabble | Edit this page |
