Search found 3 matches

by JimJohnson
Thu Mar 29, 2012 3:02 pm
Forum: Data Manipulation
Topic: Multiple Conditional Summing and exporting to Excel
Replies: 10
Views: 9654

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?
by JimJohnson
Thu Mar 29, 2012 2:10 pm
Forum: Data Manipulation
Topic: Multiple Conditional Summing and exporting to Excel
Replies: 10
Views: 9654

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...
by JimJohnson
Thu Mar 29, 2012 1:43 pm
Forum: Data Manipulation
Topic: Multiple Conditional Summing and exporting to Excel
Replies: 10
Views: 9654

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...

Go to advanced search