Re-structuring data from different databases into a panel
Posted: Thu Sep 21, 2017 7:17 pm
Hello,
I've been trying to get this working, with no success. I've read this forum thread:
viewtopic.php?t=74
and still no help, because the data I'm working with is a bit special.
So here's what the data I have look like:
1. I have several EVIews (.edb) databases.
2. Each one, contains several variables in an undated/unstructured form.
3. One of the variables in each database is a character, called "customer". This contains the customer name. There's also a variable called "date", which contains information about the date, which is daily, in the format: "09/20/2017". Each database has data from one date/day.
So I'd like to import all these data and merge them, using the "customer" and "date" variables.
I've tried doing in many ways, but nothing works. Please help.
I've been trying to get this working, with no success. I've read this forum thread:
viewtopic.php?t=74
and still no help, because the data I'm working with is a bit special.
So here's what the data I have look like:
1. I have several EVIews (.edb) databases.
2. Each one, contains several variables in an undated/unstructured form.
3. One of the variables in each database is a character, called "customer". This contains the customer name. There's also a variable called "date", which contains information about the date, which is daily, in the format: "09/20/2017". Each database has data from one date/day.
So I'd like to import all these data and merge them, using the "customer" and "date" variables.
I've tried doing in many ways, but nothing works. Please help.