Добавлено: Сб Июл 07, 2018 16:57 Заголовок сообщения: Is there an easier way of bringing this file down to size???
I have an enormous file of bond data. It is about 250 MB after deleting columns of data I don't need. Originally it was 650 MB.
While I am impressed that EViews can handle the data import. I have a ways to go in getting things in the format I need.
I have four separate tables, that I can compile into one, that store CUSIP identifiers for the bonds I want to look at for my research. There are around 800 bonds. This would further reduce the file size significantly.
How do I create a worksheet that stores only the data for the bonds in my list. I tried using smpl filtering but there is a limit to the number of IF conditions. Is there an easier way of bringing this file down to size???
I didn't find the right solution from the internet.