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]
Re: st: Problem with infix: record too long
From
Barbara Guimarães <[email protected]>
To
[email protected]
Subject
Re: st: Problem with infix: record too long
Date
Sun, 24 Apr 2011 17:36:14 -0300
Dear Nick, unfortunetly, I'm not being able to open the file with any
word processor (I believe that it is because of its size / this
dataset was provided by an government organization, so I already
received it in .txt format and don't have access to the primary data)
However, the output of the hexdump analyze was:
>> hexdump TS_QUEST_ALUNO.txt, analyze
Line-end characters
Line length (tab=1)
\r\n (Windows) 2,517,361
minimum 0
\r by itself (Mac) 686,626
maximum 20,971,542
\n by itself (Unix) 768,441
Space/separator characters Number
of lines 3,972,429
[blank] 112,067,613
EOL at EOF? no
[tab] 707,187
[comma] (,) 765,547
Length of first 5 lines
Control characters
Line1 120
binary 0 30,611,037
Line2 120
CTL excl. \r, \n, \t 19,330,367
Line 3 120
DEL 367,820
Line 4 120
Extended (128-159,255) 21,370,596 Line 5
120
ASCII printable
A-Z 149,642,323
a-z 16,234,081
File format BINARY
0-9 53,967,247
Special (!@#$ etc.) 28,963,365
Extended (160-254) 54,882,559
---------------
Total 495,399,531
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 Esc28 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^AE^B E^C E^D E^E 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^RE^S E^T E^U E^V E^W E^X E^Y E^Z 155 156 157 158 159 160 ¡ ¢
£ ¤ ¥ ¦ § ¨ ©ª « ¬ ® ¯ ° ± ² ³ ´ µ ¶ · ¸ ¹ º » ¼ ½ ¾ ¿ À Á Â Ã Ä Å Æ
Ç È É Ê Ë Ì ÍÎ Ï Ð Ñ Ò Ó Ô Õ Ö × Ø Ù Ú Û Ü Ý Þ ß à á â ã ä å æ ç è é ê
ë ì í î ï ð ñò ó ô õ ö ÷ ø ù ú û ü ý þ 255
Is there any way I could transform this dataset in a way Stata would
read it entirely?
thank you
Barbara
-infix- cannot read binary files.
.txt is just a file extension that is commonly assigned to ASCII
files; if the file is binary, calling it .txt won't make it so.
Showing us the first few lines of the file might give us a clue.
Nick
> 2011/4/24 Barbara Guimarães <[email protected]>:
>
>> I'm having trouble reading data with infix. I am using Stata 11.1 for Windows.
>>
>> I received the "record too long" error, and I subsequently read the
>> thread "Re:st:reading data with infix: record too long" (as of 2003
>> and 2008), then checked my data set with -hexdump, analyze- but I
>> don't know what to do now.
>>
>> The number of lines in my dataset is 3,972,429, but Stata is only
>> reading 2,513,116 lines. I have also tried to open the dataset using a
>> text editor to see if I could do something about it (my data set
>> format is .TXT), but its not opening due to its size.
>> I have alos tested reading the dataset wiht only one or two variables,
>> but in all cases Stata only brings part of the sata set and I receive
>> the "record too long" error.
>>
>> I do believe it is not a memory issue, because I had previously read
>> another dataset in Stata, which was as large as this one, with no
>> problems. The dataset I'm having trouble with reading is in Binary
>> format, and I don't know if this is the cause of the error or not (the
>> other dataset is ASCII format).
>>
>> What are the possibilities, if any, to integraly read this file in
>> Stata? I would need to merge both datasets afterwards, would it be
>> possible?
*
* 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/