Search found 11 matches

by notphilip
Thu Dec 01, 2011 5:28 pm
Forum: Data Manipulation
Topic: Help with importing cross section constant data
Replies: 9
Views: 5848

Re: Help with importing cross section constant data

You should open up the smaller dataset as a new workfile in EViews. Then copy from that smaller one to the larger one. When you do the copy you can use Paste-Special (rather than Paste) and set the copy stuff. Holy crap that worked perfectly! You are my eff'ing hero! You have no idea how many ways ...
by notphilip
Thu Dec 01, 2011 5:09 pm
Forum: Data Manipulation
Topic: Help with importing cross section constant data
Replies: 9
Views: 5848

Re: Help with importing cross section constant data

You might have to explicitly tell it how the dates are structured when you do the copy. Where/how do I specify it? I have tried the "reset current sample to (I)current sample (2) workfile range (3) To end of range" options, and it seemed to do the same thing every time. I feel there may b...
by notphilip
Wed Nov 30, 2011 10:51 pm
Forum: Data Manipulation
Topic: Help with importing cross section constant data
Replies: 9
Views: 5848

Re: Help with importing cross section constant data

If you just copy from the smaller dataset to the bigger one, EViews should automatically expand it (assuming it recognises the dates as being the same). Just to clarify, does this work in Eviews 6? And by copy, do you mean by opening the xls file via import? I still cannot determine why the program...
by notphilip
Mon Nov 28, 2011 10:28 am
Forum: Data Manipulation
Topic: Help with importing cross section constant data
Replies: 9
Views: 5848

Re: Help with importing cross section constant data

Hard to tell without seeing the files.
Yeah unfortunately, they are huge and some of the stats are under NDA. I'm glad to know that it is at least user error, and that the data expansion is a feature of eviews. Thanks.
by notphilip
Mon Nov 28, 2011 9:03 am
Forum: Data Manipulation
Topic: Help with importing cross section constant data
Replies: 9
Views: 5848

Re: Help with importing cross section constant data

If you just copy from the smaller dataset to the bigger one, EViews should automatically expand it (assuming it recognises the dates as being the same). What may be wrong if it is not recognizing the dates as the same? They are formatted exactly alike and the smaller sets are both in csv and xls fo...
by notphilip
Mon Nov 28, 2011 8:35 am
Forum: Data Manipulation
Topic: Help with importing cross section constant data
Replies: 9
Views: 5848

Help with importing cross section constant data

Hi all, So I have one massive dataset consisting of option valuations. Each entry has greeks, stats, and prices for a strike/expiry/day combination sold on a given day for all combinations available on that given day. This is thus a massive data set with about 800 entries per day over a year, or abo...
by notphilip
Sun Oct 02, 2011 9:59 am
Forum: Data Manipulation
Topic: Access database in Student Version
Replies: 7
Views: 5598

Re: Access database in Student Version

Ah, I found that saving it as an mdb allows easy importing. Thread resolved!
by notphilip
Sun Oct 02, 2011 9:46 am
Forum: Data Manipulation
Topic: Access database in Student Version
Replies: 7
Views: 5598

Re: Access database in Student Version

I have access to a regular, non-enterprise version on campus that I can save the workfile on. Then I think the student version will still allow me to manipulate it without being able to save changes.
by notphilip
Sun Oct 02, 2011 9:36 am
Forum: Data Manipulation
Topic: Access database in Student Version
Replies: 7
Views: 5598

Re: Access database in Student Version

My first set has seven series and 224933 entries per series. Another set has five series and 709006 entries per series.
by notphilip
Sun Oct 02, 2011 9:15 am
Forum: Data Manipulation
Topic: Access database in Student Version
Replies: 7
Views: 5598

Re: Access database in Student Version

So how can I convert this database so that I can open it with eviews? I was under the impression that e6 could open some type of file from access since it says "Simply drag-and-drop your existing Microsoft® Excel, Microsoft® Access, Stata®, SPSS, SAS® Portable, Rats, TSPTM, or PcGive Profession...
by notphilip
Sun Oct 02, 2011 8:27 am
Forum: Data Manipulation
Topic: Access database in Student Version
Replies: 7
Views: 5598

Access database in Student Version

Hi I recently purchased the student version of eviews 6. When I try to open my access database (.accdb) in eviews, it requests a format string. What is this string or what filetype should I use to easily get this data into a workfile? This is a huge dataset (709006 entries, each with about 12 column...

Go to advanced search