NetNews Usenet Archive 1992 #26

home *** CD-ROM | disk | FTP | other *** search

/ NetNews Usenet Archive 1992 #26 / NN_1992_26.iso / spool / sci / econ / 8468 < prev next >

Wrap

Internet Message Format | 1992-11-06 | 27.0 KB

Path: sparky!uunet!charon.amdahl.com!pacbell.com!decwrl!sun-barr!ames!haven.umd.edu!umd5!BEEKMAN From: BEEKMAN@econ.umd.edu Newsgroups: sci.econ Subject: EconData on Internet FAQ Message-ID: <BEEKMAN.30@econ.umd.edu> Date: 5 Nov 92 23:07:55 GMT Sender: news@umd5.umd.edu Organization: University of Maryland Lines: 639 First, thank you to all of those people that have responded so positively to my postings about EconData. We're certainly glad that more and more people are making use of the data. It makes it worthwhile. Hopefully, with enough interest we can someday get funding to do this and make some useful improvements, but until then .... Let me also apologize to some of the people who I have not had a chance to respond to. I'm sorry about this but the volume of mail has been heavy lately and more importantly my PC mailer doesn't seem to understand some of the addresses that it gets from people. I don't know what's wrong, but a few of the letters haven't gotten out (they get returned - address unknown). Please, we welcome the mail, but it might help if you include your email address in the body of the next. In any event, a number of people have asked me a few questions that we didn' t really address in the User's Guide, so let me answer them now. First, the numeric Internet address for info.umd.edu is 128.8.10.29. I hope this works for everyone. If not, let me know. Second, people have asked how they can get access to a site from which they can FTP. Sorry, but I really wouldn't know. However, I do have a few suggestions for you: try to post your questions of this type to alt. internet.* or alt.bbs.internet. The other (expensive) option is to dial-in to the INFO machine. Instructions for connecting via modem are listed in the user guide. Finally, we've already decided that we should post the Guide.doc and Contents.doc from time to time on sci.econ to reach the widest possible audience. It's my hope that we'll be able to update this often enough to keep it current. Again if you any suggestions, please feel free to write. -Kevin Beekman PS. I've included the Guide.doc and Contents.doc below for your convenience. Guide to EconData A Source of Economic Time Series Data from the University of Maryland 1992 July 22 This Guide tells how to use the EconData service of the University of Maryland. Several hundred thousand economic time series, produced by the U.S. Government and distributed by the government in a variety of formats and media, have been put into a standard, highly efficient, easy-to-use form for personal computers and made publicly available through this service. These series include various national accounts, labor information, price indices, current business indicators and industrial production, information on states and regions, and international data. A more complete list of the series covered can be found in the file CONTENTS.DOC. These series are all in the form of banks for the G regression and model building program and its public domain version, PDG. The DOS version of PDG and the banks can be downloaded from the University's computer systems by anyone connected to Internet or, more slowly, by telephone. The data have been put in this form by the INFORUM research group in the Economics Department. The dissemination by computer network is made possible by the Computer Science Center. HOW TO GET THE DATA EconData may accessed in three ways: 1. Through Internet using an ftp (file transfer protocol) for "anonymous" login 2. Through Internet using a Telnet package to use the "info" interface (intended to make the downloading process easier). 3. By modem and telephone at 1200 or 2400 baud. The first two are far faster than the third, so we begin by describing them. Internet with the anonymous login. Internet, is a computer network linking most of the major research universities in the United States and many other countries. If you have obtained this document by way of Internet, you must know what is in this section. If, however, you obtained it by mail or by dial-up modem or through the University of Maryland's interactive INFO system, you will find the method described here vastly faster. Exactly how one connects with Internet is different at each site and must be learned from the local network administrator. All the rest of how to use EconData is the same everywhere. Generally, a user at a PC connected to a local network that connects to Internet has a command to make the connection with "ftp" -- a File Transfer Protocol. Let us say that this command has the name "ftpcall", though it will almost certainly be something else. You would then type: ftpcall info.umd.edu That command connects you to the "info" machine at the University of Maryland. You will see on your screen: user name: ftp> You then type: user anonymous You are then asked for a password. It will be your identification while connected, so your name would be a good choice. After giving the password, you again get the "ftp>" prompt. Reply with binary cd /info/EconData/Instructions Do not forget the capital letters in "EconData" and "Instructions". Then, the first time you are connected, do: get readme.doc get gbanks.doc get guide.doc get contents.doc cd ../Tools get pkz110.exe (if you do not already have PKZip version 1.1 or higher) get unzip.exe get unzip.doc get dezip20.com get pdgarc.exe get pdgsup.exe bye Those instructions will obtain the essential tools you need and a demonstration bank. After studying the "contents.doc" file, you can come back for particular banks. Let us suppose you decide that you want nipaq.zip, the quarterly national accounts. It is in the Data/USNational/Accounts directory, so you again repeat the above procedure as through the line "binary" and then do: cd /info/EconData/Data get nipaq.zip bye You can then follow the example below for using nipaq.zip Internet via Telnet with the INFO interface. A telnet program is one which provides terminal emulation over the Internet to a user, who can either be connected directly with a PC or via a mini or mainframe computer. As with FTP there are many versions of Telnet software and specific questions about its use should be directed to your system administrator. While the speed of transfer may of may not be affected by using Telnet rather than FTP, a connection made with Telnet has an advantage in that it offers the users full screen menus. These menus significantly improve the user friendliness of the INFO bulletin board and EconData, especially for first time users. For the purposes of this explanation, we will assume that your Telnet program is simply called telnet (as it often is). The command to issue Telnet should be something like this: telnet info.umd.edu When connected you should be given a login prompt, such as: login: you should reply: info This login connects you to a more user-friendly interface which allows you to view the documentation files before the downloading. Learn what the various commands available to you do by using the arrow keys to select the command and then tapping the '?' key. You first want to "View" EconData. Then you want to "X-fer" the files listed above. When you choose "X-fer", you will be asked to choose the type of transfer protocol. You will probably want to choose either the FTP or TFTP protocols, the choice of which will depend upon on your particular Telnet program. Telephone and modem connection. If not connected to internet, you can use your modem for a dial-up call to download some of the files. (Some data files are so large that this method of downloading may require more than the maximum 90 minute connection allowed by the system.) Follow these steps: 1. Start your communications program. Set the terminal emulation as vt100 if possible, otherwise note how it is set. Dial 301-403-4333 with the following communications parameters: baud 2400 if possible, otherwise 1200 or 300; 8 data bits, no parity, 1 stop bit. If you have a 9600 baud modem the number is 301- 403-4444 with the same settings as above. 2. After the terminal is connected, tap the 'Enter' or 'Return' key every second until the annex prompt appears. 3. At the "annex" prompt, type telnet info.umd.edu 4. At the "login" prompt, type info 5. To the question about terminal type, answer "vt100" or the other type which you set your communication program to emulate. 6. Learn what the various commands available to you do by using the arrow keys to select the command and then tapping the '?' key. You first want to "View" EconData. Then you want to "X-fer" the files listed above. You will want to use the Kermit protocol. 7. To leave the system, select Quit on the menu. That will take you back to the "annex" prompt. Reply "ha" to this prompt to "hangup". THE FIRST FILES YOU NEED The very first time you connect, you should transfer the following files: In the Instructions subdirectory: README.DOC Brief notes on recent changes in EconData CONTENTS.DOC A description of the subdirectories of EconData and the files contained in those subdirectories GUIDE.DOC The current version of this document. If the date at the top is the same as the date of the file, you presumably do not need the file, since you are looking at it. This document, explaining how to use these economic time series. The same material is available as a file for WordPerfect 5.1 as GUIDE.WP. In the Tools subdirectory: PDGARC.EXE The public domain version of the G regression package, necessary for using the data files. PDGSUP.EXE The supplementary programs for the G regression package, used for making tables and manipulating data. PKZ110.EXE The PKZip archival package. If the files you want end in ".zip", you need this program or some other compatible program to de-archive them. PKZip is shareware, and a modest registration is required for legal use beyond an initial trial period. We started off with DWC because it was public domain and out-performed the well-known PKArc. However, PKZip gives significantly greater compression, so we have gradually switching to it.) PKZip and PKUNZip are the packages that we used and tested to create the archive you see here. However, we have also made available two public domain programs that were designed to strictly de-archive Zipped files. We have made these available to you if you want to save on license fee, but to you, but we have not fully tested them. If you are interested, you might be able to use the following programs instead of PKZip: DEZIP20.COM UNZIP.EXE UNZIP.DOC DE-ARCHIVING Except for a few ASCII files ending in the ".doc" extension, all files on EconData have been archived with PKZIP and have the ".zip" extension. They must be de-archived before they can be used. For PKZIP, the process is slightly different. At the DOS prompt, just type PKZ110 and the one file will explode into a number of files, one of which is PKUNZIP.EXE and others are documentation and registration information. To de-archive the file xxxx.zip, just type pkunzip xxxx The commands for the public domain alternatives to pkunzip are very similar. You should refer to the accompanying documentation. PUBLIC DOMAIN G All of the time-series are in the form of banks for G and PDG. PDG is contained in the file PDGARC.EXE, and important supplementary programs are in PDGSUP.EXE. These are "must" files for the initial download. Once you have downloaded these files and you are back on your own computer, create a pdg subdirectory by typing: c: cd \ md pdg cd pdg Now move or copy to this directory the PDGARC.EXE, and PDGSUP.EXE files. De-archive PDG by typing: pdgarc pdgsup You should now backup the PDGARC.EXE, PDGSUP.EXE files to diskette. You may then delete PDGARC.EXE and PDGSUP.EXE from your hard disk to save space. Now, edit your autoexec.bat file to include c:\pdg in the path. Also, your config.sys file should have the lines FILES = 20 BUFFERS = 20 The "20's" may be replaced with larger numbers. Probably your config.sys file is already fine; if not, modify it and reboot. Now it is time to try out PDG. Do: cd \pdg pdg demo You will get a demonstration of PDG's functions. USING PDG WITH THE ECONOMIC TIME-SERIES DATA Once PDG is in the path, you can access it from any subdirectory. Now you simply need to download a time-series of interest from the Data subdirectory in Econdata. For illustration purposes, we will assume that you have downloaded the quarterly National Income and Product Accounts time-series, NIPAQ.ZIP. On you own computer, you need to set up a subdirectory for this data. This is done by typing: cd \ md nipaq cd nipaq Now copy or move the NIPAQ.ZIP file to this directory, and type: pkunzip nipaq You may then delete NIPAQ.ZIP. Note that if you are using one of the public domain alternatives to PKUNZIP, then you would replace that programs name for "pkunzip" in the above example. Each time-series has its own G configuration file, G.CFG, specific to that series. Provided that each series is kept in a different subdirectory, then when you start PDG, the G.CFG file will automatically assign this bank. You start PDG by typing: pdg Answer the opening question with a 'Enter', and then, at the : prompt, do: look and you may now explore the quarterly NIPA accounts. Of course, it is possible to have all of the time-series data in one subdirectory; but then you must specify which bank you would like to look at once you are in PDG. You do this at any : prompt by typing: hbk nipaq If you are using PDG in another directory, you can assign this bank by the G or PDG command: hbk \nipaq\nipaq These steps should get you started. The "demo" will introduce you to the basic functions of PDG; the "help" files are extensive and may be printed out. There are also interactive lessons in the material you have downloaded. The book "The Craft of Economic Modeling" by Clopper Almon (Ginn Press) gives many examples of the use of G. AVAILABLE DATA Read the file CONTENTS.DOC for a list of currently available data. COMMON QUESTIONS Q. Do I have to download a whole huge file every time it is updated? A. No, just download a small file with the updates and run a simple program to update the old large file from the small new one. Suppose you have downloaded nipaq, the quarterly national accounts, and a new quarter rolls around. You will then soon find a file in the Data directory named newnipaq.zip. Download it to the same directory with your nipaq bank. Then do splice nipaq newnipaq revnipaq SPLICE is a program in the pdgsup.exe file which you have installed into the pdg directory. This command will create a new compressed bank named revnipaq. Start PDG and assign it with the command hbk revnipaq Then examine a few series to insure that everything has worked properly. Then exit PDG, delete nipaq.cin and nipaq.cbk and do ren revnipaq.* nipaq.* Your nipaq bank is now updated. Q. Can I download an individual series? A. No. Only whole banks can be moved. But whole banks now move faster than individual series did a few years ago. Q. How large are the banks and how long does it take to download one? A. A typical bank is 200 - 400K bytes, though some reach 2 or 3 megabytes. We experience a file transfer rate of about 5 or 6 K bytes per second in downloading via Internet from systems at other universities. (The local rate is some 45 K per second). Thus, the complete annual national accounts, 5,600 series, each back to 1929 or whenever it begins, occupies 425 K bytes and would require about 75 to 90 seconds. Since downloading a 1.44 Megabyte diskette of data requires only about 3 minutes, there is little reason to mail diskettes among sites connected to Internet. Download by dial-up telephone is much slower. The theoretical maximum rate is .24 K per second, so a file will take 20 to 25 times as long by dial-up as it does via Internet. Q. How current are the data? A. Banks which we can update from the Commerce Department's Economic Bulletin Board (EBB) are updated within a few days of release of new data. These include the quarterly National Income and Product Accounts, the Business Conditions Indicators, the Blue Pages of the Survey of Current Business, and the Indexes of Industrial Production. The Federal Reserve cooperates by lending us a Flow of Funds tape when it appears, so this bank is also very up-to-date. Other data we have to purchase. In particular, the Bureau of Labor Statistics has explicitly refused any cooperation other than selling us the tapes. Consequently, these files are updated only when we have a particular need to do so. That is at least once a year but seldom monthly. Q. What is the advantage of EconData over EBB? A. The Commerce EBB is primarily composed of "documents," often press releases, not banks. Almost every file is in a different format. There is no standard way to get the data into an analytical program. Nor is there any standard way to update a previous file with new information. On EconData, every bank is in the format of a G data bank. Updating is easy. To update our banks from the EBB, we have had to write C-programs -- a different one for every EBB file -- to put the EBB material into a standard form. Writing these programs was a tiresome bother. We have put them in the "Tools" directory of EconData, in case we should not be quick enough for you in getting the file ready some month. We have urged the EBB staff to at least offer our banks to their users. They have declined to do so because they accept only files from U.S. Government agencies. We then urged agencies to use these banks to submit data to the EBB. The Federal Reserve submits the industrial production indexes in the form of an ASCII file for input into PDG. The staff of other agencies, though expressing personal admiration of the programs, have been apprehensive that making the data so easy to use might constitute competition with private industry. Q. How hard are the data to use, once I get them? A. If you are using PDG or G as your main analysis program, you have only to type a three-letter command plus the bank name to assign the bank. Then the "look" command allows you to search for the series you want, graph it or display it numerically. A brief command, followed by the names of the variables you want, will write the series to ascii files or 1-2-3 worksheet files. Nearly any program can read them in this form. Q. What else do PDG and G do? A. PDG will do algebraic and functional (such as logarithmic) transformations of series and convert a series from monthly to quarterly or from quarterly to annual periodicity -- and vice versa, approximately. You can bring in your own data and make banks that have series selected from your own data and one or more of the EconData banks. PDG will graph data in a variety of ways -- lines (up to seven) with user-controlled line size, style, and marking, multiple-scale graphs, bar graphs, stacked bars, parallel bars, scatter graphs, scatter graphs with connected points, semi-logarithmic graphs, and so on. It allows on-screen annotation of graphs and can "remember" the annotations that were made on screen so that when the same graph is repeated with updated data, the annotation will automatically appear. It will do screen dump prints to most printers. (Full G also supports PostScript printers, TIFF files, and HP- compatible printers with downloaded fonts.) A companion program makes tables that can include growth rates and annual averages of monthly or quarterly data. PDG does ordinary least squares regression, regression with "soft" or "stochastic" constraints, and distributed lags via soft constraints. Full G, for $95, adds Hildreth-Lu correction for autocorrelation, ARIMA methods, seemingly unrelated regression and stacked regression with constraints across equations, non-linear regression, automatic Chow tests, and pooled time-series and cross-section regression. With its sister program Build, it can build simultaneous equation models with hundreds of equations. Both G and PDG have extensive on-line documentation. There are versions of both programs in French, Italian, Spanish, Russian, and Chinese. The Italian version is being officially used in data dissemination. Q. What is the form of the data banks? How do they pack so much data into so little space? Can they be used without PDG or G? A. The precise form is described, byte-by-byte, in the gbanks.doc file in the Instructions directory of EconData. While one cannot simply look at the banks with the DOS "type" command or a text editor, there would be no problem for authors of other data handling programs to read the G banks. Basically, for each series, the frequency, starting date, and number of decimal places are recorded. The decimal point is then shifted to the right to give a sequence of integers, and the first differences of these integers are taken. If the differences are all between -32K and +32K, then the series can be stored with perfect accuracy as an initial value and then these differences, stored as 2-byte integers. Otherwise, the storage defaults to 4-byte floating point. G and PDG can use the series in this form; they reconstitute each series as needed. For transmission, the resulting banks have been further compressed by putting them through PKZIP, data compression and archiving programs. PKZIP are available in the Tools directory of EconData, along with some public domain programs which seem to be very good at unzipping ZIP files. Q. How is EconData supported? A. The INFORUM research group has developed many of these data banks for its own use in building the most comprehensive interindustry models of the U.S. economy. It has a PC with a 9-track tape drive, the essential piece of hardware to bridge the gap between the PC world and the 9-track tape world which most government data suppliers still live in. Since INFORUM is not in the business of selling data, it has been willing to make these banks available to other academic researchers through Internet. Several other groups have asked INFORUM to put particular bodies of data into this form and have agreed to let the result be placed on EconData. Other groups at the University of Maryland have also contributed interest and support. Further contributions -- particularly if already in G-bank form -- would be most welcome. Contents of EconData The following G data banks are available in EconData: A. USNational: U.S. national data are placed under four subdirectories, namely, Accounts, Labor, Price, and BusInd. Files in "Accounts": NIPAA.ZIP - Annual National Income and Product Accounts NIPASA.ZIP - Annual NIPA Supplementary Tables NIPAQ.ZIP - Quarterly National Income and Product Accounts NIPASQ.ZIP - Quarterly NIPA Supplementary Tables FDI.ZIP - Foreign Direct Investment in the U.S. BOP.ZIP - Balance of Payments of U.S.A. FOFLEV.ZIP - Flow of Fund Accounts FOFNSA.ZIP - Flow of Fund Accounts FOFSA.ZIP - Flow of Fund Accounts Files in "Labor": EHENSA.ZIP - Monthly National Employment, Hours, Earnings and Diffusion Indices; Not Seasonally Adjusted EHESA.ZIP - Monthly National Employment, Hours, Earnings and Diffusion Indices; Seasonally Adjusted Files in "Price": PPI.ZIP - Producer Price Indexes PPIR.ZIP - Producer Price Indexes, Revised CPIW.ZIP - Consumer Price Indexes, Wage Earners CPIU.ZIP - Consumer Price Indexes, Urban Workers XMPI.ZIP - Export/Import Price Indexes Files in "BusInd": BCI.ZIP - Business Conditions Indicators SCB.ZIP - Blue Pages of the Survey of Current Business IPISA.ZIP - Industrial Production Indexes, Seasonally Adjusted IPINSA.ZIP - Industrial Production Indexes, Not Seasonally Adjusted KWHSA.ZIP - Kilowatt Hours, Seasonally Adjusted KWHNSA.ZIP - Kilowatt Hours, Not Seasonally Adjusted MFG.ZIP - Manufacturing retrospective B. StateLocal: Employ - State and Area Employment, Hours, Earnings. (from establishments survey) This is a directory which contains several archives organized by region. File names are of the type: ???.ZIP where ??? corresponds to a particular region. UNLFC.ZIP - Labor force, Unemployment, etc. (from households survey) GSP.ZIP - Gross State Products SPI.ZIP - State Personal Income C. International: 1.) the World Bank data (password available to researchers affiliated with the ICPSR - Inter-university Consortium for Political and Social Research): WDT.ZIP - World Debt Tables WTB.ZIP - World Tables of Social & Economic Indicators 2.) International Monetary Fund data (password available to researchers affiliated with the ICPSR - Inter-university Consortium for Political and Social Research): GFS.ZIP - Government Financial Statistics DOT.ZIP - Direction of Trade data IBOP.ZIP - International Balance of Payments 3.) Penn World Tables PWT.ZIP - Penn World Tables NOTE: There may also be available updates to many of these banks. If so, these banks will bear the same names as the banks which they update, but prefix with "NEW". For instance, the update bank for BCI will be name NEWBCI.