Search found 3 matches
- Thu Mar 29, 2012 3:02 pm
- Forum: Data Manipulation
- Topic: Multiple Conditional Summing and exporting to Excel
- Replies: 10
- Views: 9655
Re: Multiple Conditional Summing and exporting to Excel
Could I not load one workfile, do the conditional summing for that workfile, save the resulting file, delete the workfile and load in the next file, all through the programming language?
- Thu Mar 29, 2012 2:10 pm
- Forum: Data Manipulation
- Topic: Multiple Conditional Summing and exporting to Excel
- Replies: 10
- Views: 9655
Re: Multiple Conditional Summing and exporting to Excel
The data are .dbf files, but I can easily put them into Eviews workfiles. There is a separate database for each period, that is, one for 2000 q1, another for 2000 q2, etc. Each database contains roughly two million records with, as said, about 10 or so fields with different characteristics. Location...
- Thu Mar 29, 2012 1:43 pm
- Forum: Data Manipulation
- Topic: Multiple Conditional Summing and exporting to Excel
- Replies: 10
- Views: 9655
Multiple Conditional Summing and exporting to Excel
I have a series of databases of vehicles (2 million records each for each period 2000 quater 1 to 2011 quater 4) with roughly 10 characteristic fields (e.g., location, class, fuel, license type, fuel efficiency, etc.). Using the programming language, I want to sum all vehicles that are in location 1...
