Importing BEA quarterly file

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator

dman
Posts: 24
Joined: Mon Jul 18, 2016 10:50 am

Importing BEA quarterly file

Postby dman » Sat Oct 28, 2017 6:56 pm

Hello.
BEA just changed their data download format and now provides a bulk file like this:
https://bea.gov/national/Release/TXT/NipaDataQ.txt


File structure goes like this:
A001RC,1947Q1,"244,058"
A001RC,1947Q2,"247,362"
A001RC,1947Q3,"251,246"
A001RC,1947Q4,"261,545"
A001RC,1948Q1,"267,564"
A001RC,1948Q2,"274,376"
A001RC,1948Q3,"280,980"
A001RC,1948Q4,"282,127"
A001RC,1949Q1,"276,756"
A001RC,1949Q2,"273,021"
A001RC,1949Q3,"274,535"
A001RC,1949Q4,"272,117"
A001RC,1950Q1,"282,437"

Where A001RC is a series code, then quarter, then value.

Looking for suggestions to import it into Eviews so that it results in a series named A001RC (as well as all others in the file) in a dated file going from 1947Q1 to the latest quarter.

I tried a bunch of options in the import dialog and none seem to be capable of this. Any advice is appreciated.

Thanks!

dman
Posts: 24
Joined: Mon Jul 18, 2016 10:50 am

Re: Importing BEA quarterly file

Postby dman » Thu Aug 01, 2019 12:16 pm

Hello.
Just upgraded to Eviews11. Still no solution to this that I see?
Nevermind, I see the BEA API now.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 12 guests