Home > Data Services > Catalog . Restricted Data . Census . ACS

Search Data Services

Meta Search
search across all the following databases:

Data Catalog
Data and documentation

KnowledgeBase
Common questions and answers.

Resources
Entire collection of data resources.


Latest Data News

RSS Feed icon

Breaking News: Protect the 2020 Census

The Fastest Growing US Cities Are Mostly In the West

Another rule from NIH: Demographers might get to ignore this one

Research on Health Disparities: Incarceration Matters

Changing Race From One Census to the Next

column

Purpose: To allow a user to pull off selected columns of data. This should be used to view the contents of selected columns rather than used as an extraction tool, as the program does not allow one to simultaneously pull off columns 6-7, 11-13, 49-50, and 51-57.

One can get the same results with awk and/or cut in UNIX. However, these UNIX utilities will only work with data that have short record lengths.

To run, enter column x y < z

where:

Notes:

  1. To limit the amount of output printed to the screen, use with the more utility:

    column 12 13 < data | more

  2. If data are compressed, the data can be piped in from a decompression program: zcat data.Z | column 12 13
  3. To send output to a file named doc,

    column 50 54 < data > doc

  4. To get the contents of selected columns (e.g., 79 through 80) for the first 20 records or the last 15 records, combine column with head/tail .

    head -20 data | column 79 80 > doc

    tail -15 data | column 79 80 >> doc