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 Steve, EViews Jason, EViews Moderator, EViews Pamela

dman
Posts: 6
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!

Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 7 guests