working with data from SQL database

[BT454]

Hi all,
I'm working with some data from a sql server. I use the pageload command to query the sql database, and successfully import the data into eviews. It correctly imports the data by column. The database i'm pulling from is a relational database, and I would like to manipulate this data into time series. The three columns it imports are the date, region_id (identifier for a geography), and the actual value of the series. Is there a way to somehow merge this data together to create a time series for each region_id?
I've attached a workfile with sample data.
Thanks!
Bob

sql_sample.WF1

(53.85 KiB) Downloaded 408 times

[EViews Gareth]

If you want a pooled workfile:

Code: Select all

series date = @dateval(manualweeklystorage_endingdate, "YYYY-MM-DD") pageunstack(namepat=*?) region_id date @ *

If you want a panel workfile:

Code: Select all

series date = @dateval(manualweeklystorage_endingdate, "YYYY-MM-DD") pagestruct region_id @date(date)

[BT454]

Thank you for you reply!
Is there a way I can take the output from the pagestruct command and create a time series for each region ID, showing the value, by date?

[EViews Gareth]

Isn't that the pooled form?

[BT454]

You are correct! My fault. thanks again!