ZIP CODE BUSINESS PATTERNS 1997—EXERCISE OUTLINE
Variables covered in the Zip Code Business Patterns database include the following:
establishments, first quarter payroll, annual payroll, mid-March employment, and
establishments by employment-size class. In Zip Code Business Patterns all of these
variables are available for the total of all industries for each zip code. However, for
individual industries in each zip code (regardless of industrial detail) only total
establishments and establishments by employment-size-class are available.
Industries are available at the 4-digit SIC code level.
The geographic coverage is 5-digit zip codes.
COMPARISON TO THE PUBLICATION:
There is no Zip Code Business Patterns printed report.
(The CD software has already been installed, so insert the Zip Business Patterns CD.
Although software was installed, the data are on the CD and you will always need to
insert the CD to look at the data.)
The main Zip Code Business Patterns window will appear after you insert the CD.
Though if it does not, click on icon appearing on your desktop.
Click on LAUNCH THE SOFTWARE on the ZIP CODE BUSINESS PATTERNS
The SELECT A ZIP CODE window will appear. The instructions on the right hand side
of the window tell you to double click in succession on the “1”, “3” and “5”-digit zip
codes that are of interest. For this exercise, double click on the single digit zip of “8”—
New Mexico’s beginning zip code digit.
In the next window, i.e., the window with 3-DIGIT ZIP CODES, scroll down and
double click on 871.
Finally, in the next window, i.e., the window with 5-DIGIT ZIP CODES, double click on
87102, downtown Albuquerque.
The 1997 ZIP CODE BUSINESS PATTERNS MAJOR SECTOR SUMMARY window
will appear. Directly under the title of the window you will see the zip code that you are
viewing, 87102 in Albuquerque, NM. Directly under this you will see data for 4 items—
employees, establishments, 1st quarter payroll and annual payroll. These data items are
for the total of all industries contained in this zip code. The white window under these
data items presents the number of establishments and establishments by employment-size
class for the major industries (according to the SIC classification system) for Zip Code
87102. Size classes range from 1-4 employees to 1,000 employees or more. The
distribution of establishments by employment-size class is also shown for the total of all
industries in this zip code. Note that the count of total establishments in the white
window matches the count shown in the gray area directly above. Remember that you
cannot get employee counts or payroll data for individual industries.
Notice the box titled CHANGE ZIP CODE on the right side of the window under the
window title. Click on the CHANGE ZIP CODE box. The window showing 5-digit zip
codes beginning with 871 will appear. Double click on 87110, the Coronado/Winrock
shopping center area. The MAJOR SECTOR SUMMARY window now changes to
reflect the values for 87110. Let’s change back to zip code 87102 before going further.
Click on the CHANGE ZIP CODE box and then double click on 87102 and the MAJOR
SECTOR SUMMARY window will change again to reflect all the values for 87102.
Now, let’s take a look at more detailed industries. Click on Retail Trade, highlighting the
row. Move your cursor up to the top of the screen and click on the button labeled
DETAIL. The RETAIL TRADE SECTOR SUMMARY window now appears, showing
the number of establishments and establishments by employment-size class for all “3” or
“4”-digit retail trade industries in zip code 87102. Click on the CHANGE ZIP CODE
box near the top right side of the screen. The window showing 5-digit zip codes
beginning with 871 appears. Double click on 87110 and the RETAIL TRADE SECTOR
SUMMARY window will change to reflect to the detailed retail industry values for zip
code 87110. Change the zip code back to 87102. Click on the CHANGE ZIP CODE
box again and then double click on 87102.
Notice that you have two windows open—one for the MAJOR SECTOR SUMMARY
and another for the RETAIL TRADE SECTOR SUMMARY, both for zip code 87102.
An interesting point, if you change only the RETAIL TRADE SECTOR SUMMARY
window to 87110, then you will have a detailed sector summary window open for 87110
and a major sector summary window open for 87102. In any case, you can move the two
windows side by side to view values in both.
Look at another feature on this CD. In the RETAIL TRADE SECTOR SUMMARY
window click on Eating Places industry (SIC 5812), highlighting the row. Move your
cursor to the top of the screen and click on the button labeled COMPARE. A 5-DIGIT
ZIP CODE COMPARISON window now appears, showing you the number of eating
place (SIC 5812) establishments and their distribution by employment-size class for all 5-
digit zip codes beginning with 871. By the way, you now have three windows open—a
major sector summary, a detailed sector summary and a zip code comparison window.
Look at the narrow rectangular box labeled INDUSTRY that appears under the window
title, “1997 ZIP Code Business Patterns—ZIP Code Comparisons”. It shows SIC 5812,
Eating Places. Click the arrow for the INDUSTRY pull-down menu and then click on
SIC 5813 Drinking Places. The values in the ZIP CODE COMPARISON window
change to show the number of drinking place establishments and their distribution by
employment-size class for all 5-digit zip codes beginning with 871.
You can also copy the data appearing in a window to a file. In the ZIP CODE
COMPARISON window, move your cursor to the top of the screen and click the button
labeled COPY. The COPY window then appears. Note that there is a list of ten variables
(the total number of establishments and establishments by employment-size class,
ranging from 1-4 employees to 1,000 or more employees) in the top rectangular box titled
ITEMS AVAILABLE TO COPY. You can click on individual variables one at a time
(highlighting them) and then select only the variables of interest by clicking on the ADD
button or you can select all ten of the variables by clicking on the FILL button. The
variables that you select appear in the rectangular box in the middle of the screen titled
ITEMS TO BE COPIED. In this middle box, you can click on a variable that you do not
want (highlighting it) and then click the DROP button to eliminate a variable from your
list that was incorrectly selected. Alternatively, click the CLEAR button to eliminate all
of the selected variables. Notice the two radial dots at the bottom of the page in the box
titled GEOGRAPHIC AND INDUSTRY COVERAGE. You can copy the variables for
industry 5813 for either all of the 5-digit ZIP codes beginning with 871 or all of the 5-
digit ZIP codes beginning with 8. To the right of these radial dots is a check box,
indicating if you want the record layouts and technical documentation files. OK now
let’s copy the comparison file for SIC 5813. Click on the box labeled FILL so we will
copy all the variables, click the top radial dot, indicating we wish to copy only the 5-digit
ZIP codes beginning with 871 and click the box to select the file layout and technical
documentation. Click the box labeled OK and another window appears, allowing you to
name the file, determine its format and select its destination. Let’s leave the file in the
“C” root directory, name it ZIPCOMP with no extension and select ASCII Delimited as
the format option. Click the SAVE button. Your data file has now been copied along
with the layout and technical documentation file. The Word file with the technical
documentation and file layout provides the column headings for your data table. This is
essential if you import the data into spreadsheet software such as Excel. The
layout/technical documentation file also contains the employment and payroll data for
industry totals for each of the zip codes covered in the array. (Note the sample files
posted on this web site as Microsoft Excel files. There are samples of the Record Layout,
a sample of a ZIP Code list, and a sample of the data columns without record layout
Let’s look briefly at the COPY feature in the MAJOR SECTOR SUMMARY window
and RETAIL TRADE SECTOR SUMMARY window. Click on the COPY button in the
RETAIL TRADE SECTOR SUMMARY window. The COPY window again appears.
Note that the GEOGRAPHIC AND INDUSTRY COVERAGE box at the bottom of the
page allows you to select either the radial dot for ZIP code 87102 or the ZIP codes in the
range from 87100 to 87109. This is considerably different than the geographic coverage
shown in the ZIP CODE COMPARISON window. Click the CANCEL button in the
COPY window. Click the COPY button in the MAJOR SECTOR SUMMARY window.
The COPY window again appears. Note that the GEOGRAPHIC AND INDUSTRY
COVERAGE box at the bottom of the page allows you to select either the radial dot for
ZIP code 87102 or all 5-digit ZIP codes beginning with 871. Again this is a very
different choice. Click the CANCEL button in the COPY window.
Look at a couple other features. Open the SECTOR SUMMARY window. Click on the
HELP button at the top of the screen. You now get the table of contents. In particular,
examine the SOFTWARE TIPS. This short narrative covers the key features of the CD.
The GLOSSARY gives you definitions of the variables appearing in the Zip Code
Business Patterns database. The OVERVIEW and ABSTRACT are also useful
Let’s go back to a feature we saw earlier but skipped over. Open the ZIP CODE
BUSINESS PATTERNS MAIN window. Click on the LAUNCH SOFTWARE button.
The SELECT A ZIP CODE window appears, showing all the 1-digit ZIP codes. Click
on the SEARCH button. The ZIP CODE SEARCH window appears. In the narrow
rectangular box over the top of the FIND MATCHES button type in ALBUQUERQUE
in upper case. It is important to use all upper case letters. (This, by the way, is opposite
of the instructions in the Software Tips documentation.) Click the FIND MATCHES
button. A list of all the Albuquerque ZIP codes appears in the box to the right. Highlight
87108 by clicking on it. Click the OK button. The SELECT A ZIP CODE window
appears again. Click OK again. The MAJOR SECTOR SUMMARY window for ZIP
code 87108 appears.
An additional point, you cannot capture, through the COPY command, all the ZIP codes
at once for New Mexico and you cannot capture all the ZIP codes at once for a city, if the
city has more than one sequence of 3-digit ZIP codes.
An additional point, PO Box ZIP codes are in the database.