Page 1 of 1

Importing database from BLS

Posted: Thu Jan 20, 2011 3:31 pm
by soungl
How can I import END files from the Census of Employment and Wages by Bureau of Labor Statistics? The END files are available on the following link:

ftp://ftp.bls.gov/pub/special.requests/ ... /national/

I don't see the END file type in File/Open/Databases.

Thank you.

Re: Importing database from BLS

Posted: Thu Jan 20, 2011 5:51 pm
by EViews Glenn
EViews doesn't read them directly, but it looks as though it should be easy to import into Excel or Access. EViews should be able to read the data from there....

http://www.bls.gov/cew/helpers.htm

Re: Importing database from BLS

Posted: Thu Jan 20, 2011 6:28 pm
by EViews Chris
It's actually pretty straightfoward using the SAS helper files provided by the BLS:

1) Download the zip file containing the '.end' file and extract the '.end' file from the zip
2) Download the 'makesas.zip' file from http://www.bls.gov/cew/helpers.htm and extract the appropriate SAS program file eg. 'cewend.sas'
3) Edit the SAS program file (in a text editor like Windows notepad) so the infile statement at the top of the file points to the location of the '.end' file you downloaded in step (1)
4) Drag and drop the 'cewend.sas' file on to EViews.

That's about all there is to it. EViews will get the necessary information for reading the file from the SAS program file.