I previously asked here about reading .RAW files in R. I have looked for more details on these files and have found this documentation:
And this:
I do not have experience with ASCII files but I have managed to open it using this code:
> l<-read.fwf("D://Data//1987//f990.87.raw",2189)
> head(l)
V1
1 SUNRISE BLUFF ESTATES INC 810365125094900510144783298712MT5944203NN0000NNN81036512512N 5629 0 0 5629 230808 0 2930 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 102250 109612 -7362 0 232005 185585 55795 0 0 241380 -9375 -16627 0 -26002 0 0 0 0 0 0 0 44728 24331 20397 0 0 0 0 0 0 0 0 0 3792 2076 1716 0 0 4300 0 4300 0 0 0 0 0 2054 1590 464 0 1022 0 1022 0 213 0 213 0 21250 21250 0 0 7470 7360 110 0 0 0 0 0 1574 0 1574 0 0 0 0 0 92244 92244 0 0 36653 36653 0 0 26080 81 25999 0 241380 185585 55795 0 0 0 230808 0 28357 53875 58 0 0 0 0 9558 7074 6989 0 0 0 0 1118796 0 1232548 1215149 13709 0 2222 0 1225220 0 1249175 1241151 -16627 -26002 1215149 0 8747 36850 0 0 327206 1364564 2635 10253 407 1186 0 0 0 0 0 0 338995 1412853 11789 48289 3390C 1692 22705 13.4220 18-OCT-89870
2 <NA>
3 NORTHEAST MISSOURI LIBRARY SERVICE 436017950094900230016683198712MO6344503NN0000NNN43601795012N 0 4793 161881 166675 539 0 6298 0 2116 0 2116 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 175630 169751 0 0 0 169751 5878 77129 1645 84653 0 0 0 12357 12357 0 0 79241 79241 0 0 0 0 0 0 0 0 0 0 6529 6529 0 0 0 250 250 0 0 0 0 0 0 2737 2737 0 0 1817 1817 0 0 1158 1158 0 0 29312 29312 0 0 2043 2043 0 0 0 0 0 0 1958 1958 0 0 0 0 0 0 0 0 0 0 0 0 0 0 32342 32342 0 0 169744 169744 0 0 0 0 539 0 105 64811 0 0 0 0 0 0 0 2476 0 0 0 0 17260 0 77129 84653 0 0 0 0 0 0 0 0 77129 84653 84653 0 1435 4557 0 0 1359 4819 6298 32143 0 0 161881 577828 0 0 0 0 170975 619348 169615 614528 1709C 1549 85294 55.069 18-OCT-89870
4 <NA>
Is there any easy way to structure this file? I found this post but that uses library(SAScii) but it seems to be too specialized to a particular case.
If you want to try, the data is avaialable here.
Char. lengthcolumn as the second argument ofread.fwf(i.e. you need to pass the vectorc(4, 35, 9, 14, etc)as thewidthsargument ofread.fwf). There are over 200 of these and you will probably need to copy them by hand. However, once you do this, you can read as many records as you like into a data frame.