Bookmark and Share

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


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

st: How to read a very old SPSS file?


From   <[email protected]>
To   <[email protected]>
Subject   st: How to read a very old SPSS file?
Date   Fri, 4 Feb 2011 22:48:59 -0000

I have a file which was originally written in SPSS binary data file format in around 1980 onto magnetic tape from which the file image has been taken. The original file was in EBCDIC format written by an IBM computer or clone thereof. I have also converted the file to ASCII format using UltraEdit's built-in converter.   I don't have access to any version of SPSS nowadays.  This is the only copy remaining of a historic data set.

I want to read these data into Stata (of course!). Tips please. 

Tried so far (using the ascii format version of the file):

* Stat/Transfer version 10 conversion failed: "Processing SPSS dataset dictionary was stopped because of the error (3)"
* SPSS version 6 (c. 1989): a former colleague tried reading with this and it failed 

In case it's useful, here is a hexdump from the file, derived using Stata's -hexdump- command:

======================================================
. hexdump iserdump1_ue.txt , analyze

 Line-end characters                        Line length (tab=1)
   \r\n         (Windows)              2      minimum        0
   \r by itself (Mac)                599      maximum   21,074
   \n by itself (Unix)             1,077
 Space/separator characters                 Number of lines    1,679
   [blank]                         2,964      EOL at EOF?       no
   [tab]                           1,749
   [comma] (,)                     1,260    Length of first 5 lines
 Control characters                           Line 1      615
   binary 0                    2,574,907      Line 2        3
   CTL excl. \r, \n, \t          252,933      Line 3      973
   DEL                               947      Line 4      525
   Extended (128-159,255)        106,948      Line 5      989
 ASCII printable
   A-Z                            99,890
   a-z                            21,142    File format   BINARY
   0-9                             8,824
   Special (!@#$ etc.)           142,054
   Extended (160-254)            231,999
                         ---------------
 Total                         3,447,297

 Observed were:
    \0 ^A ^B ^C ^D ^E ^F ^G ^H \t \n ^K ^L \r ^N ^O ^P ^Q ^R ^S ^T ^U ^V ^W
    ^X ^Y ^Z Esc 28 29 30 31 blank ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5
    6 7 8 9 : ; < = > ? @ A B C D E F G H I J K L M N O P Q R S T U V W X Y
    Z [ \ ] ^ _ ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | }
    ~ DEL 128 E^A E^B E^C E^D E^F E^G E^H E^I E^J E^K E^L E^M E^N E^O E^P
    E^Q E^R E^S E^T E^U E^V E^W E^X E^Y E^Z 155 156 157 158 160 ¡ ¢ £ ¤ ¥ ¦
    § ¨ © ª « ¬ ­ ® ¯ ° ± ² ³ ´ µ ¶ . ¸ ¹ º » ¼ ½ ¾ ¿ À Á Â Ã Ä Å Æ Ç È É Ê
    Ë Ì Í Î Ï Ð Ñ Ò Ó Ô Ö × Ù Ú Û Ü Ý Þ ß à á â ã ä æ ç è é ê ë ì í î ï ð ñ
    ò ó ô õ ö ÷ ø ù ú û ü ý þ 255

======================================================

Thanks 
Stephen
-------------------------------------
Stephen P. Jenkins  <[email protected]> 
Department of Social Policy and STICERD/CASE 
London School of Economics and Political Science 
Houghton Street 
London WC2A 2AE, U.K.
Tel. +44 (0)20 7955 6527
Survival Analysis using Stata:
http://www.iser.essex.ac.uk/survival-analysis
Downloadable papers and software: http://ideas.repec.org/e/pje7.html


Please access the attached hyperlink for an important electronic communications disclaimer: http://lse.ac.uk/emailDisclaimer

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/


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