Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: SPSS to Stata - Variable with 14 digits not transformed correctly

From   Julian Emmler <>
Subject   st: SPSS to Stata - Variable with 14 digits not transformed correctly
Date   Fri, 2 Mar 2012 12:19:16 +0100

Dear Statalists,
 I'm new to this forum so I don't know yet the most accurate way to post my
question but I hope it will be understandable and I would be greatful for
every question for clarification. My Problem with Stata is concerned with
transforming household data for the South African labour market which is
only available in SPSS format to Stata. I did this with several datasets
also for the South African labour market and used the "usespss" command in
Stata which worked just fine. However with the last dataset I encountered a
 In the dataset, to identify a household, a 14 digit number called the
Unique Household Identifier is used. However, if I transform the data
from SPSS to Stata, the values of the Household identifier are not it's
real values any more but are shortened e.g. to 1.001e+13. Thus the Unique
household identifier is not unique anymore. I try several things, e.g.
transformin the vaiable to a double variable and increasing the number of
digits displayed. This helps in that regard, that the number is now
displayed correctly in the data browser, however the value didn't change.
After searching the internet, I've come to the conclusion that this probelm
has something to do with the length of the variable, i.e. that 14 digits is
too long to be handled by Stata. Another indicator for this is that with
earlier datasets I had no problem because the Unique Household Identifier
was 12 digits long. I wanted to ask now if you know any way to
transfer the SPSS data to Stata correctly or a way to manipulate the
data afterwards so i attains its true values. It would be very helpful for me,

kind regards,

*   For searches and help try:

© Copyright 1996–2017 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index