Importing BEA quarterly file
Posted: 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:
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!
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!