Notes about the Example Tables

For all examples, the following global statement is in effect:

libname sql 'SAS-data-library';

The tables that are used in this document contain geographic and demographic data. The data is intended to be used for the PROC SQL code examples only; it is not necessarily up-to-date or accurate.

Note: You can find instructions for downloading these data sets at http://ftp.sas.com/samples/A56936. These data sets are valid for SAS 9 as well as previous versions of SAS.

The COUNTRIES table contains data that pertains to countries. The Area column contains a country's area in square miles. The UNDate column contains the year a country entered the United Nations, if applicable.

COUNTRIES (Partial Output)

The WORLDCITYCOORDS table contains latitude and longitude data for world cities. Cities in the Western hemisphere have negative longitude coordinates. Cities in the Southern hemisphere have negative latitude coordinates. Coordinates are rounded to the nearest degree.

WORLDCITYCOORDS (Partial Output)

The USCITYCOORDS table contains the coordinates for cities in the United States. Because all cities in this table are in the Western hemisphere, all of the longitude coordinates are negative. Coordinates are rounded to the nearest degree.

USCITYCOORDS (Partial Output)