export statsby tables to a dbase

[mark]

Hi
Using EV9 enterprise
Issue - looping over a sample size of 300 projects to generate summary stats by each projects - I'd like to export vectors in each table to a common dbase.
I can export to csv files using the code below, however, given each project has varying attributes - the number of columns/rows vary across projects
I'm after the vectors in each project table and want to send them to a single dbase.
I've managed to store vectors to csv files and tables to the dbase, but I'm stumped as far as saving vectors in each table to dbase

here's the code:

transaction_amount.statby(nomean, sum, nostd, nocount) time business_function_code
freeze(p{%1}) transaction_amount.statby(nomean, sum, nostd, nocount) time business_function_code
'save the tables as csv files
p{%1}BF.save( t=csv, n="NAN") h:\planning and policy\CPS\LB_DUMP\p{%1}BF
'stores the TABLES to the dbase
store cps_sample::p{%1}BF

any ideas - thanks

[EViews Gareth]

That should work. I assume that the database is an EViews database?

[mark]

works for the stats summary tables

I want to save the fields and data elements from each table(s) to the dbase (not the tables)

Each table varies in dimension - the number and names of fields vary table to table (300 or so)

The complete set of field names is common to all ables but the the number and title of field names vary across all tables.

Ideas?
thanks

[EViews Gareth]

Probably better of not using statsby, but rather calling the individual by functions (such as meansby). Those will return results in series objects, which can be stored to the database, or you can shrink them down to vectors.

[mark]

thanks - big help
mark