Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: SPSS to Stata using DBMS/Copy


From   Dan Blanchette <dan_blanchette@unc.edu>
To   statalist@hsphsun2.harvard.edu
Subject   st: SPSS to Stata using DBMS/Copy
Date   Tue, 3 Aug 2004 17:54:31 -0400 (EDT)

Is there a Stata tool to convert the string variables created by DBMS/Copy
that contain the value label information back to value labels after
transferring data from SPSS to Stata?

When I have an SPSS datafile that contains variables with value labels
and I use DBMS/Copy to create a Stata datafile, DBMS/Copy asks if I want
string variables created for each variable that has a value label.  The
downside to this is that it nearly doubles the number of variables in
my dataset and it more than doubles the size of the datafile.

I wrote a Stata program to convert these variables back to value labels
because -encode- does not necessarily generate the same numeric values
as the original numeric variables.  I spent quite a bit of time Googling
around for such a tool and didn't find one.  Stat/Transfer seems to just
make value labels in the Stata datafile, which is great.  I don't have
SPSS available to me.

I'm wondering how or if people deal with this problem and if my program
would be of interest to others.

Thanks,

Dan Blanchette
Applications Analyst Programmer
Carolina Population Center UNC-CH
Dan_Blanchette@unc.edu


*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index