|
|
|
||||
|
|
|||||
For each PUMA, a SAS logical expression is given which allows you to select the data for the given PUMA. This logical expression can be used in an IF statement in a DATA step, or in a WHERE statement in a PROC step, as shown in the examples below. These examples use PUMA 100 (which includes Del Norte County, Lassen County, Modoc County, and Siskiyou County, as shown below). These examples can be generalized to any of the PUMAs by replacing the logical expression "(puma = 100)" with the logical expression for the desired PUMA.
Example 1. Using an IF statement in a DATA step to create a temporary SAS data file composed just of those people living in PUMA 100 (Del Norte County, Lassen County, Modoc County, and Siskiyou County).
DATA puma100;
SET "c:\census\ca90pump"(KEEP = age pwgt1 puma);
IF (puma = 100);
RUN;
Example 2. Using a WHERE statement in a PROC step to obtain the mean age of all those people living in PUMA 100 (Del Norte County, Lassen County, Modoc County, and Siskiyou County).
PROC MEANS DATA="c:\census\ca90pump";
WHERE (puma = 100);
VAR age;
WEIGHT pwgt1;
RUN;
The following PUMAs contain more than one county, therefore when you select one of these PUMAs, you are selecting all of the counties listed for the PUMA below. For each PUMA, the SAS logical expression is given which allows you to select the data for that PUMA. This logical expression can be used in a DATA step (e.g. example 1 above) or in a PROC step (e.g. example 2 above).
(PUMA = 100)
Del Norte County
Lassen County
Modoc County
Siskiyou County
(PUMA = 400)
Lake County
Mendocino County
(PUMA = 500)
Colusa County
Glenn County
Tehama County
Trinity County
(PUMA = 700)
Nevada County
Plumas County
Sierra County
(PUMA = 800)
Sutter County
Yuba County
(PUMA = 2600)
Alpine County
Amador County
Calaveras County
Inyo County
Mariposa County
Mono County
Tuolumne County
(PUMA = 2700)
Madera County
San Benito County
All the other counties in California are either identical to a PUMA or span two or more PUMAs. Each of these counties is shown below, followed the SAS logical expression which can be used to specify the county. This SAS logical expression can be used in a DATA step (e.g. example 1 above) or in a PROC step (e.g. example 2 above) to specify the county.
Alameda County
(2000 LE puma LE 2109)
Butte County
(puma=600)
Contra Costa County
(1700 LE puma LE 1805)
El Dorado County
(puma=1200)
Fresno County
(4000 LE puma LE 4100)
Humboldt County
(puma=200)
Imperial County
(puma=3700)
Kern County
(4900 LE puma LE 5002)
Kings County
(puma=3100)
Los Angeles County
(5200 LE puma LE 6600)
Marin County
(1501 LE puma LE 1502)
Merced County
(puma=3000)
Monterrey County
(3800 LE puma LE 3902)
Napa County
(puma=900)
Orange County
(4200 LE puma LE 4808)
Placer County
(puma=1100)
Riverside County
(6800 LE puma LE 6905)
Sacramento County
(2801 LE puma LE 2906)
San Bernardino County
(7000 LE puma LE 7206)
San Diego County
(3301 LE puma LE 3313)
San Francisco County (and city)
(1901 LE puma LE 1906)
San Joaquin County
(2301 LE puma LE 2304)
San Luis Obispo County
(5101 LE puma LE 5102)
San Mateo County
(2201 LE puma LE 2206)
Santa Barbara County
(3201 LE puma LE 3202)
Santa Clara County
(3401 LE puma LE 3411)
Santa Cruz County
(if puma=3600)
Shasta Country
(puma=300)
Solano County
(1601 LE puma LE 1603)
Sonoma County
(1300 LE puma LE 1400)
Stanislaus County
(2400 LE puma LE 2500)
Tulare County
(puma=3500)
Ventura County
(6701 LE puma LE 6705)
Yolo County
(puma=1000)
For more information, contact ATS Consulting by sending email to ATSstat@ucla.edu.
Originally revised: 21 Jan 97
UCLA Researchers are invited to our Statistical Consulting Services
We recommend others to our list of Other Resources for Statistical Computing Help
These pages are Copyrighted (c) by UCLA Academic Technology Services