==> Contents <== Contents: /pub/sasfmats Rev: 06Jun07-12:50 =============================================================================== ./(see heading).......... Contents.................The file you are looking at. Headlines................First 25 lines from each format module in this directory. Typically, contains the meta data indicating what the format does -- what the arguments are and what the results are. Good place to browse when looking for something. Readme...................Overview file with general information about the directory. ==> Headlines <== ==> Contents <== Contents: /pub/sasfmats Rev: 06Jun07-12:50 =============================================================================== ./(see heading).......... Contents.................The file you are looking at. Headlines................First 25 lines from each format module in this directory. Typically, contains the meta data indicating what the format does -- what the arguments are and what the results are. Good place to browse when looking for something. Readme...................Overview file with general information about the ==> Readme <== Each member of this directory contains SAS source code that defines a custom SAS format code. Non-SAS programmers should be aware, however, that there is considerable value to these modules as text tables to lookup up geographic codes and names. For example, you can browse the member Sfipcnty.sas to see the FIPS state+county codes and corresponding names for all 3000+ U.S. counties. And if you are a SAS programmer and you have a dataset with a FIPS county code in it and you would like to create a new variable with the name of the county you can code: length cntyname $40; cntyname=put(fipco,$fipcnty.); This assumes that your SAS session has access to the compiled SAS format code. If you are running on the oseda platform with one of our standard SAS scripts you automatically have all of these formats readily available to you. Otherwise (e.g. if you have downloaded a format module for use on your own system) you can simply run the SAS FORMAT procedure and then point to the file where this format module is stored. For example, to "compile" the $fipcnty ==> Saaa.sas <== /* NAME: $aaa DESCRIPTION: Names for Mo Area Agency on Aging regions PGMR: jgb DATE CREATED: 2/8/2006 ARGUMENT: aaa code (2-char leading 0's) VALUE RETURNED: Agency name and city SAMPLE ENTRY(S): '01'='Southwest Office on Aging, Springfield' GEOGRAPHIC AREA COVERED: Missouri. SOURCE USED TO GENERATE: www.dhss.mo.gov/SeniorServices/AAARegion.pdf on 2-8-06 ==> Salphasc.sas <== *---These two formats are used in the mable2k conversion module to recode Size codes and then provide the new code with labels. SC2Alph is a table convert code and alphasc is a value label code for the resulting alpha codes. This code was copied from http://mcdc2.missouri.edu/pub/data/mable2k/Tools/genmable2k_01.sas 5/03, jgb. ---; proc format library=library; value $SC2Alph '00'=' ' 01-04='A' 05-08='B' 09-11='C' 12-13='D' 14-15='E' 16-17='F' 18='G' 19-20='H' 21-23='I'; value $alphasc a,A='Less than 200' b,B='200-999' c,C='1000-2499' d,D='2500-9999' e,E='10,000-24,999' f,F='25,000-99,999' g,G='100,000-249,999' h,H='250,000-999,999' i,I='1,000,000+' ' '='Not in a place'; run; ==> Sbealcind.sas <== /* NAME: $bealcind DESCRIPTION: BEA lince code for industry. PGMR: jgb DATE CREATED: 5/8/2006 ARGUMENT: Industry line code as used on jtw files, REIS DVD. VALUE RETURNED: Name of industry grouping. SAMPLE ENTRY(S): 5="Wholesale Trade + Retail Trade" SOURCE USED TO GENERATE: county_commuters_avgwage.csv file in beareis/jtw CODES UPDATED AS OF: 2005 ==> Sbeale03_.sas <== /* GENERATED BY GENFMAT MACRO ON 03/24/07 */ PROC FORMAT DDNAME=LIBRARY ; VALUE $beale03_ '1'='County in metro area with 1 million pop+ ' '2'='County in metro area of 250,000 to 1 million pop ' '3'='County in metro area of fewer than 250,000 pop ' '4'='Nonmetro county with urban pop of 20,000+, adjacent to a metro area ' '5'='Nonmetro county with urban pop of 20,000+, not adjacent to a metro area ' '6'='Nonmetro county with urban pop of 2,500-19,999, adjacent to a metro area ' '7'='Nonmetro county with urban pop of 2,500-19,999, not adjacent to a metro area ' '8'='Nonmetro county completely rural or less than 2,500 urban pop, adj. to metro area ' '9'='Nonmetro county completely rural or less than 2,500 urban pop, not adj. to metro area ' ; ==> Sbeareg.sas <== /* NAME:$beareg DESCRIPTION: BEA 1 and 2-digit Region codes (NOT to be confused with Census regions) PGMR: JGB DATE CREATED: 8/13/2004 ARGUMENT: BEA region code, 1 or 2-digit, i.e. "1" or "91". VALUE RETURNED: Name of region (without the word "Region") SAMPLE ENTRY(S): '5','95'='Southeast' SOURCE USED TO GENERATE: BEA REIS tech doc file. ==> Sblcd103.sas <== /* GENERATED BY GENFMAT MACRO ON 10/17/95 */ PROC FORMAT DDNAME=LIBRARY ; VALUE $blcd103_ '010010201.00101A'-'010010211.00399C'='02' '010030101.00101 '-'010030116.00599 '='01' '010059501.00101 '-'010059509.00399E'='02' '010079513.00101 '-'010079513.00199 '='03' '010079513.00201 '-'010079513.00202 '='06' '010079513.00203 '-'010079513.00204 '='03' '010079513.00205 '-'010079513.00209 '='06' '010079513.00210 '-'010079513.00215 '='03' '010079513.00216 '-'010079513.00267 '='06' '010079513.00299A'-'010079513.00299C'='03' '010079513.00299D'-'010079513.00299V'='06' '010079513.00301 '-'010079513.00305 '='03' ==> Sca04lc.sas <== /* NAME:$ca04lc (new for 2005 DESCRIPTION: TITLES FOR BEA Personal Income Summary LINE CODES. PGMR: jgb DATE CREATED: 5/24/2005 12:41PM ARGUMENT: 4-CHARACTER BEA PERSONAL INCOME LINE CODE. VALUE RETURNED: TITLE ASSOCIATED WITH THE LINE CODE SAMPLE ENTRY(S): '0011'=" Nonfarm personal income 1/ " SOURCE USED TO GENERATE: TECHNICAL DOC. FROM BEA (ca04line.prn file, 2005cd) CODES UPDATED AS OF: 5/24/2005 12:42PM ==> Sca05lc.sas <== /* NAME:$ca05lc (was $bealcin) DESCRIPTION: TITLES FOR BEA PERSONAL INCOME LINE CODES as used on the ca05n AND ca05 files - 4-digt NAICS-based industry codes used in 2001 & later, 3-digit sic-based used earlier. PGMR: Blodgett DATE CREATED: 5/26/2005 8:09AM ARGUMENT: 3- and 4-CHARACTER BEA PERSONAL INCOME (NAICS & SIC versions combined) LINE CODE. VALUE RETURNED: TITLE ASSOCIATED WITH THE LINE CODE SAMPLE ENTRY(S): '010','0010'='TOTAL PERSONAL INCOME' SOURCE USED TO GENERATE: ca05nline.prn file in the ca05 and ca05n directories of 2002 vintage cd. ==> Sca05lc_.sas <== /* NAME:$ca05lc_ DESCRIPTION: TITLES FOR BEA PERSONAL INCOME LINE CODES as used on the ca05n AND ca05 files - 4-digt NAICS-based industry codes used in 2001 & later, 3-digit sic-based used earlier. With footnote refs and other prefix like: "" removed. Variation of $cao5lc PGMR: Blodgett DATE CREATED: 5/9/2007 2:43PM ARGUMENT: 3- and 4-CHARACTER BEA PERSONAL INCOME (NAICS & SIC versions combined) LINE CODE. VALUE RETURNED: TITLE ASSOCIATED WITH THE LINE CODE SAMPLE ENTRY(S): '010','0010'='TOTAL PERSONAL INCOME' ==> Sca06lc.sas <== /* NAME:$ca06lc (new for 2005 DESCRIPTION: TITLES FOR BEA Compensation by NAICS industry LINE CODES. PGMR: jgb DATE CREATED: 5/26/2005 8:05AM ARGUMENT: 4-CHARACTER BEA compensation by sic or NAICS LINE CODE (tables ca06/ca06n). VALUE RETURNED: TITLE ASSOCIATED WITH THE LINE CODE SAMPLE ENTRY(S): "0005","Total wage and salary disbursements " SOURCE USED TO GENERATE: TECHNICAL DOC. FROM BEA (ca06line.prn file, 2005cd) CODES UPDATED AS OF: 5/24/2005 12:42PM ==> Sca25lc.sas <== /* NAME:$ca25lc (was $BEALCEN) DESCRIPTION: TITLES FOR BEA EMPLoYMNT LINE Codes, including both the 3- and 4-digit verssions used for the ca25 and ca25n files on the REIS data products. PGMR: jgb DATE CREATED: 8/11/2004 1:53PM ARGUMENT: 3- and 4-CHARACTER BEA EMPLOYMENT LINE CODE. VALUE RETURNED: TITLE ASSOCIATED WITH THE LINE CODE SAMPLE ENTRY(S): '0010'='Total Employment' '010'='Total Employment' ==> Sca25lc_.sas <== /* NAME:$ca25lc_ (was $BEALCEN) DESCRIPTION: TITLES FOR BEA EMPLoYMNT LINE Codes, including both the 3- and 4-digit versions used for the ca25 and ca25n files on the REIS data products. VARIATION of $ca25lc that does not return footnote refs. jgb, 5-07 PGMR: jgb DATE CREATED: 8/11/2004 1:53PM ARGUMENT: 3- and 4-CHARACTER BEA EMPLOYMENT LINE CODE. VALUE RETURNED: TITLE ASSOCIATED WITH THE LINE CODE (with footnote refs removed!!) SAMPLE ENTRY(S): '0010'='Total Employment' '010'='Total Employment' ==> Sca30lc.sas <== /* NAME:$ca30lc (was $BEALCP) DESCRIPTION: TITLES FOR BEA COUNTY PROFILE LINE CODES. PGMR: jgb DATE CREATED: 11/1/95 ARGUMENT: 3-CHARACTER BEA PERSONAL INCOME LINE CODE. VALUE RETURNED: TITLE ASSOCIATED WITH THE LINE CODE SAMPLE ENTRY(S): '010'='TOTAL PERSONAL INCOME' SOURCE USED TO GENERATE: TECHNICAL DOC. FROM BEA (ca30line.prn file, 2003 data year) CODES UPDATED AS OF: 5/26/2005 8:33AM ==> Sca35lc.sas <== /* NAME:$ca35lc (was $BEALCT) DESCRIPTION: FORMAT CODE FOR BEA TRANSFER PAYMENTS LINE CODES. PGMR: jgb DATE CREATED: 9-89 mod 7-00, jgb ARGUMENT: LINE CODE NUMBER (CHARACTER, OF LENGTH 3) VALUE RETURNED: DESCRIPTION OF LINE CODE SAMPLE ENTRY(S): '010' = 'TOTAL TRANSFER PAYMENTS' SOURCE USED TO GENERATE: BEA RECORD LAYOUT USAGE NOTES: USED BY MACRO BEATRF FOR LABELS ==> Sca45lc.sas <== /* NAME:$ca45lc (was $BEALCF) DESCRIPTION: TITLES FOR BEA FARM INCOME LINE CODES. PGMR: NMK DATE CREATED: 04-01-96 ARGUMENT: 3-CHARACTER BEA FARM INCOME LINE CODE. VALUE RETURNED: TITLE ASSOCIATED WITH THE LINE CODE SAMPLE ENTRY(S): "010"="Cash receipts from marketings ($000) " SOURCE USED TO GENERATE: TECHNICAL DOC. FROM BEA (ca45line.prn on 2002 cd) CODES UPDATED AS OF: 5/26/2005 7:56AM ==> Scbsa.sas <== /* Edited by jgb. 8-5-06. Problem with entry for new micrp SA, Fernley, NV. Hand entering. This was generated from setup in georeof/Tools/cbsas05.sas */ /* GENERATED (mostly) BY GENFMAT MACRO ON 08/04/06 */ PROC FORMAT DDNAME=LIBRARY ; VALUE $cbsa '10020'='Abbeville, LA Micropolitan Statistical Area ' '10100'='Aberdeen, SD Micropolitan Statistical Area ' '10140'='Aberdeen, WA Micropolitan Statistical Area ' '10180'='Abilene, TX Metropolitan Statistical Area ' '10220'='Ada, OK Micropolitan Statistical Area ' '10260'='Adjuntas, PR Micropolitan Statistical Area ' '10300'='Adrian, MI Micropolitan Statistical Area ' '10380'='Aguadilla-Isabela-San Sebastián, PR Metropolitan Statistical Area ' '10420'='Akron, OH Metropolitan Statistical Area ' '10460'='Alamogordo, NM Micropolitan Statistical Area ' ==> Sccsvca.sas <== /* GENERATED BY GENFMAT MACRO ON 04/11/2005 */ /* Care Connection (Warrensburg) Service Area codes */ PROC FORMAT DDNAME=library ; VALUE $ccsvca '01'='Brunswick' '02'='Butler' '03'='Carroll' '04'='Clinton' '05'='Cole Camp' '06'='Concordia' '07'='Deepwater' '08'='El Dorado Springs' '09'='Higginsville' '10'='Holden' '11'='Lexington' ==> Sceed.sas <== /* NAME: $ceed DESCRIPTION: Names for community enterprise and entrepreneuial districts PGMR: jgb DATE CREATED: 2/1/2006 ARGUMENT: ceed 1-digit code VALUE RETURNED: Name of the district. SAMPLE ENTRY(S): GEOGRAPHIC AREA COVERED: Missorui SOURCE USED TO GENERATE: Tracy. ==> Scenstat.sas <== /* NAME:$CENSTAT DESCRIPTION: CENSUS STATE TO FIPS STATE PGMR: BLODGETT DATE CREATED: 1988 ARGUMENT: 2-CHARACTER CENSUS STATE CODE VALUE RETURNED: 2-CHARACTER FIPS STATE CODE SAMPLE ENTRY(S): "43"="29" GEOGRAPHIC AREA COVERED: U.S. SOURCE USED TO GENERATE: ? (IT WAS DONE USING %GENFMAT BUT CANNOT RECALL WHAT FILE WAS USED AS INPUT) ==> Scharite.sas <== /* Received from Julie Hoang, California SDC, April, 2002 as part of sf2 profiles software packages. These are the values of the chariter (characteristic iteration) codes used on the 2000 census files (sf2, at least and probably sf4. These are dramatically different than the codes used in previous censuses. The $charitr code has the values used in past years. There will no doubt be some confusion because the names are similar. This is $charite with an "e", not an "r". Values effective: 2000. Revised version received from JH, 4-18-02 with corrections to entries 450 and above. Additions for ancestry codes (500 thru 585) added from Roy Williams, MISER, 4-30-03. John Blodgett, Missouri Census Data Center */ VALUE $charite '001'='Total Population' '002'='White alone' '003'='White alone or in combination with one or more other races' '004'='Black or African American alone' ==> Scharitr.sas <== /* NAME:$CHARITR DESCRIPTION: STF902, STF904 CHARITER VALUES THESE ARE THE VALUES OF THE CHARITER VARIABLE ON THESE FILES (THE "B TABLE" FILES). USE TO ASSOCIATE SPECIFIC RACE /ANCESTRY GROUPS WITH THE CODES ON THE FILE. PGMR: JGB DATE CREATED: 12/93 ARGUMENT: 3-CHAR CODE WITH LEADING O'S. VALUE RETURNED: NAME OF GROUP. SAMPLE ENTRY(S): '000'='ALL PERSONS' '001'='WHITE' ... SOURCE USED TO GENERATE: STF4 TECH DOC, 1990. DATA DICT. P 2. ==> Scmsa.sas <== /* NAME:$CMSA DESCRIPTION: CONSOLIDATED METROPOLITAN STAT. AREA NAMES PGMR: JGB DATE CREATED: 1988 ARGUMENT: 4-CHARACTER CMSA CODE. VALUE RETURNED: CMSA TITLE (NAME) SAMPLE ENTRY(S): "7620"="SEATTLE-TACOMA, WA" GEOGRAPHIC AREA COVERED: U.S. SOURCE USED TO GENERATE: COSTAT2 APPENDIX. ==> Scmsa94_.sas <== /* GENERATED BY GENFMAT MACRO ON 10/20/95 */ PROC FORMAT DDNAME=LIBRARY ; VALUE $cmsa94_ '1122'='Boston-Worcester-Lawrence, MA-NH-ME-C(C)' '1602'='Chicago-Gary-Kenosha, IL-IN-WI (C) ' '1642'='Cincinnati-Hamilton, OH-KY-IN (C) ' '1692'='Cleveland-Akron, OH (C) ' '1922'='Dallas-Fort Worth, TX (C) ' '2082'='Denver-Boulder-Greeley, CO (C) ' '2162'='Detroit-Ann Arbor-Flint, MI (C) ' '3362'='Houston-Galveston-Brazoria, TX (C) ' '4472'='Los Angeles-Riverside-Orange County, (C)' '4992'='Miami-Fort Lauderdale, FL (C) ' '5082'='Milwaukee-Racine, WI (C) ' '5602'='New York-Northern New Jersey-Long Isl(C)' ==> Scmsatwo.sas <== /* NAME:$CMSATWO DESCRIPTION: CONSOLIDATED METROPOLITAN STAT. AREA NAMES PGMR: JGB DATE CREATED: 1989 ARGUMENT: 2-CHARACTER CMSA CODE. VALUE RETURNED: CMSA TITLE (NAME) SAMPLE ENTRY(S): "91"="SEATTLE-TACOMA, WA" GEOGRAPHIC AREA COVERED: U.S. SOURCE USED TO GENERATE: CCDB 83 APPENDIX A. ==> Scnam2fp.sas <== /* NAME: $cnam2fp DESCRIPTION: Convert state-county names (edited) to FIPS codes PGMR: jgb DATE CREATED: 1.20.99 ARGUMENT: State postal abbrev., space, County name (edited) VALUE RETURNED: 5-digit FIPS county code (including state) SAMPLE ENTRY(S): "AL AUTAUGA"="01001" , "MO ST CHARLES"="29183" GEOGRAPHIC AREA COVERED: Entire US + territories. SOURCE USED TO GENERATE: GICS90 + a few manual entires for post-1990 mods ==> Scntyaaa.sas <== /* GENERATED BY GENFMAT MACRO ON 09/18/2002 */ PROC FORMAT DDNAME=library ; VALUE $cntyaaa '29001'='05' '29003'='04' '29005'='04' '29007'='06' '29009'='01' '29011'='10' '29013'='03' '29015'='03' '29017'='02' '29019'='06' '29021'='04' '29023'='02' ==> Scntymet.sas <== /* Important Note!! This module is NOT CURRENT -- see the Scomet.sas member for current version with current codes. This module of historic interest only! NAME:$CNTYMET DESCRIPTION: COUNTY TO METRO CODE CONVERTER PGMR: JGB DATE CREATED: 4-92 ARGUMENT: 5-CHARACTER FIPS COUNTY CODE (||'P' TO RETURN PMSA CODE) VALUE RETURNED: 5-CHARACTER CODE: 1ST 4 CHARS ARE A METRO CODE, LAST CHARACTER IS A METRO TYPE CODE. VALUES ARE: M=MSA, P=PMSA, N=NECMA, 'C'=CMSA. ==> Scntyrpc.sas <== /* NAME:$CNTYRPC DESCRIPTION: MAPS FIPS STATE/COUNTY CODE TO MO. REGIONAL PLANNING COUNCILS(RPC) CODES. REV. AS OF 4/92 PGMR:JGB DATE CREATED: 5/92 SAMPLE ENTRY(S): '29107'='16' Lafayette county is in RPC 16 (Now called Pioneer Trails COG) GEOGRAPHIC AREA COVERED: MO. NUMBER OF ENTRIES: 115 USAGE NOTES: SEE ALSO $CNTYRPN WHICH RETURNS THE RPC NAME FOR A COUNTY, AND $RPCNAME WHICH RETURNS THE NAME OF THE RPC GIVEN THE ==> Scntyrpn.sas <== /* NAME:$CNTYRPN DESCRIPTION: ASSOCIATES MO. REGIONAL PLANNING COMMISSION NAMES WITH COUNTY5 FIPS CODES. PGMR: DN DATE CREATED: 9/06/89 ARGUMENT: COUNTY5-TYPE FIELD (5 CHARACTER FIPS COUNTY CODE ). ) VALUE RETURNED: NAME OF MO. REGIONAL PLANNING COMMISSION (RPC). SAMPLE ENTRY(S): '29003'='MO-KAN REGIONAL COUNCIL' GEOGRAPHIC AREA COVERED: MO. SOURCE USED TO GENERATE: EJC MAPS DS ==> Scntyrpx.sas <== /* NAME:$CNTYRPX DESCRIPTION: MAPS FIPS STATE/COUNTY CODE TO MO. REGIONAL PLANNING COMMISSION (RPC) NUMBER (01-20, OLD VESS. PRE- 4/92. PGMR:JGB,GDB DATE CREATED: 5/92 SAMPLE ENTRY(S): '29189'='03' (EAST WEST GATEWAY RPC CODE) GEOGRAPHIC AREA COVERED: MO. NUMBER OF ENTRIES: 115 USAGE NOTES: SEE ALSO $CNTYRPN WHICH RETURNS THE RPC NAME FOR A COUNTY, AND $RPCNAME WHICH RETURNS THE NAME OF THE RPC GIVEN THE ==> Scntyuer.sas <== /* NAME:$CNTYUER DESCRIPTION: MAPS FIPS STATE/COUNTY CODE TO UNIVERSITY EXTENSION REGION (UER) NUMBER (01-20). PGMR:WLE DATE CREATED: 3/92 SAMPLE ENTRY(S): '189'='918' GEOGRAPHIC AREA COVERED: MO. NUMBER OF ENTRIES: 115 USAGE NOTES: SEE ALSO $UERNAME WHICH RETURNS THE UNIVERSITY EXTENSION REGION NAME GIVEN THE UER CODE AS THE ARG. ==> Scntyumx.sas <== /* NAME:$cntyumx Alias: $cntyuer DESCRIPTION: MAPS FIPS STATE/COUNTY CODE TO U of Mo EXTENSION region PGMR:WLE /JGB DATE CREATED: 7/97 SAMPLE ENTRY(S): '189'='918' GEOGRAPHIC AREA COVERED: MO. NUMBER OF ENTRIES: 115 USAGE NOTES: SEE ALSO $UMXNAME WHICH RETURNS THE UNIVERSITY EXTENSION REGION NAME GIVEN THE UMX CODE AS THE ARG. ==> Scomet.sas <== /* NAME: $comet DESCRIPTION: FIPS county code to metro area code lookup table. PGMR: jgb DATE CREATED: 7-97 Date revised: 10-2000 ARGUMENT: 5-digit FIPS code or 5-digit FIPS||"P" to return PMSA code. VALUE RETURNED: MSACMSA or PMSA (with "P" added to arg) or NECMA (in New England only) followed by 1-char metro type code (M, C, P or N), or blank if non-metro county. SAMPLE ENTRY(S): '29183 '='7040M' '17037 '='1602C' '12011P'='2608P' '09009 '='5483N' ==> Scomet94_.sas <== /* GENERATED BY GENFMAT MACRO ON 10/21/95 */ /* edited 9-17-96 to change metro type codes to "N" (from "M") for all entries for New England states. jgb */ PROC FORMAT DDNAME=LIBRARY ; VALUE $comet94_ '01001 '='5240M' '01003 '='5160M' '01009 '='1000M' '01015 '='0450M' '01033 '='2650M' '01045 '='2180M' '01051 '='5240M' '01055 '='2880M' '01069 '='2180M' '01073 '='1000M' ==> Scomet95.sas <== x cd /mscdc/sasfmats/Tools; %let pgm=comet95; filename pgm "&pgm..sas"; *--create the revised format codes $comet95_ and $metro95_ using the 94 codes with additions/changes (per Wm Frey, U of Mi). jgb, 5-96--; libname library clear; libname library '/mscdc/sasctlgs'; *<--save in library.formats catalog; *--create custom format codes to assign and name the metro areas--; proc format library=library; value $comet95_ '04005', '49025'='2620M' '08077'='2995M' other=[$comet94_]; value $metro95_ '2620'='Flagstaff,AZ-UT' '2995'='Grand Junction, CO' '3290'='Hickory-Morganton-Lenoir, NC' '5602'='New York CMSA + New Haven et al NECMA' other=[$metro94_]; ==> Scounty.sas <== /* NAME:$county DESCRIPTION: U.S. county and state names PGMR: J. Blodgett DATE CREATED: Over time, beginning circa 1995. Last rev. 2-2000 to add entries to return state name when county portion of the arg is '000'. Broomfiled, CO entry added 4/06. ARGUMENT: 5-CHARACTER FIPS County code. VALUE RETURNED: County name, in mixed case followed by state abbreviation, or, name of state (if last 3 digits are '000' or blank) SAMPLE ENTRY(S): "01001"="Autauga, AL" "72","72000"="Puerto Rico" ==> Scousub.sas <== /* NAME:$cousub DESCRIPTION: Provides names of county subdivisions (aka MCDS, towns, townships, census county divs) for all such entities reported on SF3, 2000 Census. PGMR: JGB DATE CREATED: 9-15-04 ARGUMENT: 5-digit FIPS county code || 5-digit FIPS county subdivision code. VALUE RETURNED: Name of the subdivisin as reported in the Areaname field on SF3, followed by a comma and the name of the county, including the state postal abbreviation. ==> Scsa.sas <== /* GENERATED BY GENFMAT MACRO ON 10/20/2004 to reflect values as defi /* GENERATED BY GENFMAT MACRO ON 06/17/2005 */ /* GENERATED BY GENFMAT MACRO ON 08/04/06 */ PROC FORMAT DDNAME=LIBRARY ; VALUE $csa '102'='Albany-Corvallis-Lebanon, OR Combined Statistical Area ' '104'='Albany-Schenectady-Amsterdam, NY Combined Statistical Area ' '112'='Ames-Boone, IA Combined Statistical Area ' '118'='Appleton-Oshkosh-Neenah, WI Combined Statistical Area ' '120'='Asheville-Brevard, NC Combined Statistical Area ' '122'='Atlanta-Sandy Springs-Gainesville, GA-AL Combined Statistical Area ' '132'='Baton Rouge-Pierre Part, LA Combined Statistical Area ' '138'='Beckley-Oak Hill, WV Combined Statistical Area ' '140'='Bend-Prineville, OR Combined Statistical Area ' '142'='Birmingham-Hoover-Cullman, AL Combined Statistical Area ' ==> Scz90nam.sas <== *---We have a format defined as $cz90nam which takes a 5-character 1990 Commuting Zone code and returns the name. It was not created by our standard methods so we do not have the source code but we do have the compiled format in the sasctlgs.formats catalog. jgb, 4-01. ---*; ==> Sdedrgn.sas <== /* GENERATED BY GENFMAT MACRO ON 09/08/2001 */ PROC FORMAT DDNAME=library ; VALUE $dedrgn '110'='St. Louis MSA ' '203'='Kansas City MSA ' '213'='Springfield - Branson ' '302'='Central ' '401'='Bootheel ' '404'='Lake Ozark Rolla ' '405'='Lower East Central-Cape ' '406'='North Central ' '407'='Northeast ' '408'='Northwest ' '411'='South Central ' '412'='Southwest ' ==> Sdesedst.sas <== /* GENERATED BY GENFMAT MACRO ON 12/14/99 */ PROC FORMAT DDNAME=LIBRARY ; VALUE $desedst '001090'='ADAIR CO. R-I ' '001091'='KIRKSVILLE R-III ' '001092'='ADAIR CO. R-II ' '002089'='NORTH ANDREW CO. R-VI ' '002090'='AVENUE CITY R-IX ' '002097'='SAVANNAH R-III ' '003031'='TARKIO R-I ' '003032'='ROCK PORT R-II ' '003033'='FAIRFAX R-III ' '004106'='COMMUNITY R-VI ' '004109'='VAN-FAR R-I ' '004110'='MEXICO 59 ' ==> Sdesesch.sas <== /* GENERATED BY GENFMAT MACRO ON 12/14/99 */ /* Pleasant Hill Elementary Added, 1-30-02 */ /* 048066 Ft. Osage building=7000 'Alternative Programs' added 2-8-02 */ PROC FORMAT DDNAME=LIBRARY ; VALUE $desesch '0010901050'='ADAIR CO. HIGH ' '0010904020'='ADAIR CO. ELEM. ' '0010911050'='KIRKSVILLE SR. HIGH ' '0010911100'='KIRKSVILLE AREA TECH. CTR. ' '0010913000'='KIRKSVILLE JR. HIGH ' '0010914030'='K-2 ELEM. ' '0010914050'='RAY MILLER ELEM. ' ==> Sdiscofp.sas <== /* NAME: $discofp DESCRIPTION: Converts Missouri DESE county codes (3-char with leading zeros) to 5-character FIPS county codes. PGMR: JGB DATE CREATED: 10/99 ARGUMENT: 3-CHAR DESE County code WITH LEADING O'S. VALUE RETURNED: 5-character FIPS county code. SAMPLE ENTRY(S): '002'='29003' SOURCE USED TO GENERATE: gics90 to generate county codes. Verified against Excel spreadsheet provided by Keith J. ==> Sdivisio.sas <== /* NAME:$DIVISIO DESCRIPTION: U.S. CENSUS DIVISIONS PGMR: (UIC) DATE CREATED: CIRCA 1984 Updated; 4-99 to use mixed case and get rid of truncation. ARGUMENT: 1 CHARACTER CENSUS DIVISION CODE VALUE RETURNED: NAME OF DIVISION SAMPLE ENTRY(S): "1"="NEW ENGLAND" "7"="WEST SOUTH CENTR" GEOGRAPHIC AREA COVERED: U.S. ==> Seeorace.sas <== /* NAME:$EEORACE DESCRIPTION: LABELS RACE CODE ON EEO80 PGMR: JWS DATE CREATED: ? CIRCA 1985 ARGUMENT: 2-CHARACTER EEO RACE CODE. VALUE RETURNED: RACE CATEGORY LABEL SAMPLE ENTRY(S): "01"="RACE TOTAL" "03"="WHITE NON-HISPANIC" GEOGRAPHIC AREA COVERED: N.A. SOURCE USED TO GENERATE: EEO TECHNICAL DOC. ==> Sf2race.sas <== /* NAME:$F2RACE DESCRIPTION: STF2(1980) RACE/ORIGIN CODES PGMR: JWS DATE CREATED: CIRCA 1983 ARGUMENT: 2-CHAR RACE/ORIGIN CODE AS USED ON 1980 STF2 FILES. VALUE RETURNED: RACE/ORIGIN DESCRIPTION OR "N. A." (OTHER) SAMPLE ENTRY(S): "00"="RACE TOTAL" "20"="MEXICAN" GEOGRAPHIC AREA COVERED: N.A. SOURCE USED TO GENERATE: STF2 TECHNICAL DOCUMENT ==> Sf92race.sas <== /* NAME:$F92RACE DESCRIPTION: RETURNS A DESCRIPTION FOR CODES CONTAINED IN THE 1990 STF2 CHARITER VARIABLE (RACE CATEGORY). PGMR: JWS DATE CREATED: 11-4-92 ARGUMENT: 3-CHARACTER RACE CATEGORY CODE. VALUE RETURNED: TEXT DESCRIPTION OF RACE CATEGORY CA. 54 CHARS MAX. SAMPLE ENTRY(S):'000'='ALL PERSONS' '007'='ASIAN OR PACIFIC ISLANDER' GEOGRAPHIC AREA COVERED: N.A. ==> Sfipcnty.sas <== /* NAME:$FIPCNTY DESCRIPTION: COUNTY NAMES PGMR: (UIC- jgb/nmk) DATE CREATED: CIRCA 1986 UPDATED 2/94: CHANGED "@"S TO "'"S. 11/95: Adding entries in Alaska, LaPaz,NM Cibola, NV. ARGUMENT: 5-CHARACTER FIPS STATE || COUNTY CODE VALUE RETURNED: NAME OF COUNTY (WITHOUT STATE) SAMPLE ENTRY(S): "01001"="AUTAUGA" "29189"="ST. LOUIS" ==> Sfipstab.sas <== /* NAME:$FIPSTAB DESCRIPTION: STATE POSTAL ABBREVIATIONS PGMR: (UIC-jgb) DATE CREATED: ? Rev. 1-13-96 ARGUMENT: 2-CHARACTER FIPS STATE CODE or territory code (new-1/96) VALUE RETURNED: 2-CHARACTER POSTAL ABBREVIATION SAMPLE ENTRY(S): "01"="AL" "29"="MO" "72"="PR" GEOGRAPHIC AREA COVERED: 50 U.S. STATES & D.C. SOURCE USED TO GENERATE: 1990 GICS states file. ==> Sfmcd.sas <== /* NAME:$FMCD DESCRIPTION:Names of FIPS MCD codes PGMR: Blodgett DATE CREATED: 5-94 ARGUMENT: State||FIPS MCD code (Var. COUSUBFP on 1990 STF files). VALUE RETURNED: Name of county subdivision. Last word stripped off except where value was 'city'. SAMPLE ENTRY(S): 'ss02791'='Atlas ' 'ss02795'='Bangor city' GEOGRAPHIC AREA COVERED: United States. SOURCE USED TO GENERATE: 1990 PUBGRF files. See SASFMATS(FMCDPLAC) ==> Sfmcdcnv.sas <== IMPORTANT NOTE: We created a reverse of this conversion as format code $fmcdcnv in job /mscdc/ciesin/mable/mable06.sas. We used the gics90.cousubs dataset as source. THAT format code has: arg: 7-char fips state || fips mcd, result: 3-char. census MCD code. (other=' ' used). jgb 3-2-96-----------------------------------------------------*/ ==> Sfplace.sas <== /* GENERATED BY GENFMAT MACRO ON 06/16/2001 */ VALUE $fplace '2999999','1799999','2099999'='(Unincorporated Areas)' /* added 9/6/2005 4:07PM */ '0100124'='Abbeville city' '0100460'='Adamsville city' '0100484'='Addison town' '0100676'='Akron town' '0100820'='Alabaster city' '0100988'='Albertville city' '0101132'='Alexander City city' '0101180'='Alexandria CDP' '0101228'='Aliceville city' '0101396'='Allgood town' '0101660'='Altoona town' '0101708'='Andalusia city' ==> Sfplccnv.sas <== /* IMPORTANT NOTE: We created a reverse of this conversion format code in job /mscdc/ciesin/mable/mable06.sas. That format code is $fplccnv. It takes a 7-char arg of state||placefp and returns a ********* 4-character census place code. Has other=' ' spec and will return '9999' if last 5 digits of arg are '99999'. jgb 3-2-96----*; ==> Sgeocomp.sas <== /* Census 2000 Geographic Component Codes--full descriptions (too long for profiles in some cases.) Bracket with a PROC FORMAT LIBRARY=LIBRARY statement & a RUN statement to add to your permanent format library */ VALUE $GeoComp '00'='Not a geographic component' '01'='Urban' '02'='Urban in central place of urban area' '03'='Urban not in central place of urban area' '04'='Urban in urbanized area' '05'='Urban in urbanized area of 5,000,000 or more population' '06'='Urban in urbanized area of 2,500,000 to 4,999,999 population' ==> Sgeocomp2k.sas <== 00 Not a geographic component 01 Urban 02 Urban —in central place of urban area 03 Urban —not in central place of urban area 04 Urban —in urbanized area 05 Urban —in urbanized area of 5,000,000 or more population 06 Urban —in urbanized area of 2,500,000 to 4,999,999 population 07 Urban —in urbanized area of 1,000,000 to 2,499,999 population 08 Urban —in urbanized area of 500,000 to 999,999 population 09 Urban —in urbanized area of 250,000 to 499,999 population 10 Urban —in urbanized area of 100,000 to 249,999 population 11 Urban —in urbanized area of 50,000 to 99,999 population 12 Urban —in urbanized area —in central place of urbanized area 13 Urban —in urbanized area of 5,000,000 or more population —in central place of urbanized area ==> Sglvl.sas <== /* NAME:$GLVL DESCRIPTION: GEOGRAPHIC LEVEL OF SUMMARY RECORDS PGMR: BLODGETT DATE CREATED: 6-23-89 ARGUMENT: 2-DIGIT GEOGRAPHIC LEVEL CODE (SUMRYLVL FROM STFS) VALUE RETURNED: 2-DIGIT CODE WITH GEOGRAPHIC LEVEL TITLE SAMPLE ENTRY(S): "14" = "14 TRACT(BNA)/PLACE/MCD/COUNTY/STATE" GEOGRAPHIC AREA COVERED: UNITED STATES SOURCE USED TO GENERATE: STF4 DATA DICTIONARY, AS USED ON 1980 STF'S ==> Shouse.sas <== /* NAME: $house DESCRIPTION: Returns name of incumbent state state rep for Missouri state house. PGMR: lcm DATE CREATED: 3-98 ARGUMENT: 3-character Missouri state house of representatives code. VALUE RETURNED: Name and party affiliation of current state rep from that district. SAMPLE ENTRY(S): "002"="Don Summers (R)" GEOGRAPHIC AREA COVERED: State of Missori SOURCE USED TO GENERATE: ?? Linda found it in a publication. ==> Shucname.sas <== /* GENERATED BY GENFMAT MACRO ON 01/11/97 */ PROC FORMAT DDNAME=LIBRARY ; VALUE $hucname '01 '='NEW ENGLAND ' '0101 '='ST. JOHN ' '010100 '='ST. JOHN ' '01010001'='UPPER ST. JOHN ' '01010002'='ALLAGASH ' '01010003'='FISH ' '01010004'='AROOSTOOK ' '01010005'='MEDUXNEKEAG ' '0102 '='PENOBSCOT ' '010200 '='PENOBSCOT ' '01020001'='WEST BRANCH PENOBSCOT ' '01020002'='EAST BRANCH PENOBSCOT ' ==> Sidvname.log <== 1 The SAS System 07:46 Monday, August 11, 2003 NOTE: Copyright (c) 1999-2001 by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) Proprietary Software Release 8.2 (TS2M0) Licensed to UNIVERSITY OF MISSOURI AT COLUMBIA, Site 0001242018. NOTE: This session is executing on the AIX 4.3 platform. This message is contained in the SAS news file, and is presented upon initialization. Edit the files "news" in the "misc/base" directory to display site-specific news and information in the program log. The command line option "-nonews" will prevent this display. ==> Sidvname.sas <== /* NAME:$ DESCRIPTION: Defines list of variable names to be considered as ID variables (by dexter data extraction utility), even if they may be of type numeric. Mostly geocode names. PGMR: JGB DATE CREATED: 8/03 ARGUMENT: Variable name in all upper case. VALUE RETURNED: Return 'yes' if arg is one of the names, otherwise 'no'. SAMPLE ENTRY(S): There is only 1. SOURCE USED TO GENERATE: ==> Silplace.sas <== /* NAME:$ILPLACE DESCRIPTION: Illinois place names PGMR: jgb DATE CREATED: 7-92 ARGUMENT: 4-char. census place code (illinois assumed) VALUE RETURNED: Name of place from STF3A, 1990. SAMPLE ENTRY(S): '0005'='Abingdon city' '1790'='Elsah village' GEOGRAPHIC AREA COVERED: State of Illinois. SOURCE USED TO GENERATE: STF903A, Ill. See setup in SASMFATS.CNTL ($ILPLACE) ==> Silpow.sas <== /* GENERATED BY GENFMAT MACRO ON 05/14/99 */ PROC FORMAT DDNAME=library ; VALUE $ilpow '1700101'='Quincy city ' '1700102'='Payson village ' '1700103'='Camp Point village ' '1700104'='Mendon village ' '1700105'='Remainder of Adams County ' '1700106'='Pike County ' '1700107'='Hannibal city (pt.), MO ' '1700108'='Palmyra city, MO ' '1700109'='Remainder of Marion County, MO ' '1700110'='McDonough County ' '1700111'='Hannibal city (pt.), MO ' '1700112'='Remainder of Ralls County, MO ' ==> Sksschl.sas <== /* GENERATED BY GENFMAT MACRO ON 04/05/94 */ PROC FORMAT DDNAME=LIBRARY ; VALUE $KSSCHL '00001'='SOUTHEAST OF SALINE ' '00002'='LINDSBORG ' '00003'='WAMEGO ' '00004'='POTTAWATOMIE WEST ' '00005'='SABETHA ' '00006'='HIAWATHA ' '00007'='SMITH CENTER ' '00012'='BARNES ' '00013'='TRIPLAINS ' '00014'='CENTRAL HEIGHTS ' '00015'='OTTAWA ' '00016'='MARYSVILLE ' ==> Sleaname.sas <== /* GENERATED BY GENFMAT MACRO ON 04/15/2002 (Stoutland district - 2929580 - in MO edited 7-07 jgb */ /* NAME:$leaname DESCRIPTION: Names of "Local Educational Agencies, i.e. School Districts as used by NCES PGMR: Blodgett DATE CREATED: 4-15-02 ARGUMENT: 2-CHARACTER FIPS STATE CODE || 5-digit LEA school district code. (Same as the codes for sdelm, sdsec and sduni in Census summary file headers and in TIGER line files.) VALUE RETURNED: Name of the district in mixed case. SAMPLE ENTRY(S): "2928500"="South Nodaway Co. R-IV" GEOGRAPHIC AREA COVERED: U.S. 50 states + DC ==> Slibdname.sas <== /* GENERATED BY GENFMAT MACRO ON 01/13/2003 */ /* and edited by jgb, 3/17/2005 to change names of 2 Jefferson County subdistricts (063, 064) */ PROC FORMAT DDNAME=library ; VALUE $libdname '001'='Adair County Public Library' '002'='Albany Carnegie Public Library' '003'='Appleton City Public Library' '004'='Atchison County Library' '005'='Barry-Lawrence Regional Library - Barry County' '006'='Barry-Lawrence Regional Library - Lawrence County' '007'='Barton County Library' '008'='Bernie Public Library' '009'='Bethany Public Library' '010'='Bloomfield Public Library' '011'='Bollinger County Library' ==> Slrgplac.sas <== /* NAME:$LRGPLAC DESCRIPTION: Large Places (1from 1990 STF3C) PGMR: jgb DATE CREATED: 03-04-98 ARGUMENT: 2-char FIPS code || 4-char census place code VALUE RETURNED: Name of city, mixed case, || state abrev. in caps. NUMBER OF ENTRIES: 3148 INTERVALS USED? NO OTHER: Not specified. END ==> Slsadc.sas <== /* From Roy Williams, U of Mass. Amherst. Derived from SF1 2000 Tech Doc. */ /* Added to mcdc library, 3-219-03 */ VALUE $ LSADC /* Legal/Statistical Area Description Codes: */ '00'='(none) - nation' /* no description is appended to the name of the entity. */ '01'='(none) - state or state equivalent' /* no description is appended to the name of the entity. */ '03'='City and Borough - Legal county equivalent in AK' /* "City and Borough" is appended to the name of the entity. */ '04'='Borough - Legal county equivalent in AK' ==> Smcdcnvt.sas <== /* GENERATED BY GENFMAT MACRO ON 05/04/94 */ /* Converts census mcd ("cousub" or "cousubce") codes to FIPS code equivalents. Returned value include FIPS state code and FIPS MCD code. FIPS MCD codes can be repeated in a state for diff counties, UNLIKE census MCD codes which are always repeated for each county. IMPORTANT NOTE: We created a reverse of this conversion as format code $fmcdcnv in job /mscdc/ciesin/mable/mable06.sas. We used the gics90.cousubs dataset as source. THAT format code has: arg: 10-char fips county || fips mcd, result: 3-char. census MCD code. (other=' ' used). jgb 3-2-96-----------------------------------------------------*/ PROC FORMAT DDNAME=LIBRARY ; VALUE $MCDCNVT ==> Smcdnecd.sas <== /* GENERATED BY GENFMAT MACRO ON 02/14/07 */ PROC FORMAT DDNAME=LIBRARY ; VALUE $mcdnecd '0900104720'=' ' '0900108070'=' ' '0900108980'=' ' '0900118500'=' ' '0900118850'=' ' '0900123890'=' ' '0900126620'=' ' '0900133620'=' ' '0900148620'=' ' '0900150580'=' ' '0900150860'=' ' '0900152980'=' ' ==> Smcdnect.sas <== /* GENERATED BY GENFMAT MACRO ON 02/14/07 */ PROC FORMAT DDNAME=LIBRARY ; VALUE $mcdnect '0900104720'='72850' '0900108070'='71950' '0900108980'='72850' '0900118500'='72850' '0900118850'='71950' '0900123890'='71950' '0900126620'='71950' '0900133620'='71950' '0900148620'='71950' '0900150580'='71950' '0900150860'='72850' '0900152980'='71950' ==> Smetro.sas <== /* NAME:$metro DESCRIPTION: Names of metro areas: MSA, CMSA, PMSA and NECMA. Includes current and defunct codes since 1990. PGMR: jgb DATE CREATED: 06-07-97 Modified: We are using the $metro94_ and $metro95_ modules as starters for this one. Our intent is to keep ALL codes that have existed since 1990 here. Replaces obsolete module of same name (that one renamed as METRO.sas (note upper-case, no "S"). UPDATED: 3/99 - adding entry for Missoula, MT making module current as of 6-30-98 3/99 - some minor name edits to insure consistency with file downloaded from Bureau web site (see /mscdc/data/georef/98mfips.expanded.txt) ==> Smetro94_.sas <== /* NAME:$metro94_ DESCRIPTION: Names of metro areas as defined 6-30-94. Includes MSA's, PMSA's CMSA's and NECMA's. PGMR: jgb DATE CREATED:10-21-95 Modified: 2-14-96: to add entries for metros that were there in 1990 but went away by 94. Added to bottom of list. Generate by job in sasfmats/Tools/xmetros.sas. ARGUMENT: 4-character metro code. VALUE RETURNED: Name of metro area. Type, other than MSA, indicated by type code in parentheses at end of name (C), (P) or (N). ==> Smetro95.sas <== x cd /mscdc/sasfmats/Tools; %let pgm=comet95; filename pgm "&pgm..sas"; *--create the revised format codes $comet95_ and $metro95_ using the 94 codes with additions/changes (per Wm Frey, U of Mi). jgb, 5-96--; libname library clear; libname library '/mscdc/sasctlgs'; *<--save in library.formats catalog; *--create custom format codes to assign and name the metro areas--; proc format library=library; value $comet95_ '04005', '49025'='2620M' '08077'='2995M' other=[$comet94_]; value $metro95_ '2620'='Flagstaff,AZ-UT' '2995'='Grand Junction, CO' '3290'='Hickory-Morganton-Lenoir, NC' '5602'='New York CMSA + New Haven et al NECMA' other=[$metro94_]; ==> Smetrodiv.sas <== /* GENERATED BY GENFMAT MACRO ON 10/20/2004 to reflect values as defi /* GENERATED BY GENFMAT MACRO ON 06/17/2005 */ /* GENERATED BY GENFMAT MACRO ON 08/04/06 */ PROC FORMAT DDNAME=LIBRARY ; VALUE $metrodiv '14484'='Boston-Quincy, MA Metropolitan Division ' '15764'='Cambridge-Newton-Framingham, MA Metropolitan Division ' '21604'='Essex County, MA Metropolitan Division ' '40484'='Rockingham County-Strafford County, NH Metropolitan Division ' '16974'='Chicago-Naperville-Joliet, IL Metropolitan Division ' '23844'='Gary, IN Metropolitan Division ' '29404'='Lake County-Kenosha County, IL-WI Metropolitan Division ' '19124'='Dallas-Plano-Irving, TX Metropolitan Division ' '23104'='Fort Worth-Arlington, TX Metropolitan Division ' '19804'='Detroit-Livonia-Dearborn, MI Metropolitan Division ' ==> Smigcnty.sas <== proc format library=library; Value $migcnty '01999'='Other Alabama' '02999'='Other Alaska' '04999'='Other Arizona' '05999'='Other Arkansas' '06999'='Other California' '08999'='Other Colorado' '09999'='Other Connecticut' '10999'='Other Delaware' '11999'='Other District of Columbia' '12999'='Other Florida' '13999'='Other Georgia' '15999'='Other Hawaii' '16999'='Other Idaho' ==> Smobgloc.sas <== /* GENERATED BY GENFMAT MACRO ON 09/12/2001 */ VALUE $mobgloc '290019501.001'='Uninc. Polk township (et. al) ' '290019501.002'='Uninc. Salt River township (et. al) ' '290019501.003'='Uninc. Wilson township (et. al) ' '290019502.001'='Novinger (mostly) ' '290019502.002'='Uninc. Morrow township (et. al) ' '290019502.003'='Uninc. Pettis township (et. al) ' '290019503.001'='Kirksville (mostly) ' '290019503.002'-'290019503.004'='Kirksville ' '290019504.001'-'290019505.001'='Kirksville (mostly) ' '290019505.002'-'290019505.004'='Kirksville ' '290019505.005'='Uninc. Benton township (mostly) ' '290019505.006'-'290019510.003'='Kirksville ' '290030101.001'='Uninc. Jefferson township ' ==> Smobl2ld.sas <== /* GENERATED BY GENFMAT MACRO ON 03/23/94 */ /* NAME:$MOBL2LD DESCRIPTION: MO. BLOCK TO MOREP||MOSEN||CD *<=====THIS IS JUST DOCUMENTATION: FULL SOURCE CODE WAS NOT SAVED. SEE JOB OF SAME NAME IN SASFMATS.CNTL LIB======= PGMR: JGB DATE CREATED: (SEE COMMENT ABOVE) ARGUMENT: 16-CHAR: COUNTY||TRACT||BLK VALUE RETURNED: 3-CHAR MO HOUSE DISTRICT || 2-CHAR MO SENATE || CD SAMPLE ENTRY(S): '290019501.00101 '-'290019509.00926 '='0021809' GEOGRAPHIC AREA COVERED: MISSOURI ==> Smobl2sc.sas <== /* GENERATED BY GENFMAT MACRO ON 01/06/94 */ PROC FORMAT DDNAME=LIBRARY ; VALUE $MOBL2SC '290019501.00101 '-'290019501.00105 '='05790 001092' '290019501.00106 '-'290019501.00137 '='16740 001091' '290019501.00138 '-'290019501.00151 '='05790 001092' '290019501.00152 '-'290019501.00166A'='16740 001091' '290019501.00166B'='22980 001090' '290019501.00166C'-'290019501.00176 '='16740 001091' '290019501.00177 '-'290019501.00179 '='05790 001092' '290019501.00180 '-'290019501.00190A'='16740 001091' '290019501.00190B'='22980 001090' '290019501.00191A'-'290019501.00197 '='16740 001091' '290019501.00201 '-'290019501.00205 '='05790 001092' '290019501.00206 '-'290019501.00209 '='16740 001091' ==> Smobl2se.sas <== /* GENERATED BY GENFMAT MACRO ON 01/06/94 */ PROC FORMAT DDNAME=LIBRARY ; VALUE $MOBL2SE '290030101.00201 '='04080 002090' '290030101.00202 '='04080 002090' '290030101.00203 '='99999 99999 ' '290030101.00204 '='99999 99999 ' '290030101.00205 '='99999 99999 ' '290030101.00206 '='99999 99999 ' '290030101.00207 '='99999 99999 ' '290030101.00208 '='99999 99999 ' '290030101.00209 '='99999 99999 ' '290030101.00210 '='99999 99999 ' '290030101.00211 '='99999 99999 ' '290030101.00212A'='99999 99999 ' ==> Smoblloc.sas <== /* GENERATED BY GENFMAT MACRO ON 09/12/2001 */ VALUE $moblloc '290019501.001000'-'290019501.001009'='Uninc. Clay township ' '290019501.001010'-'290019501.001013'='Uninc. Polk township ' '290019501.001014'-'290019501.001018'='Greentop ' '290019501.001019'-'290019501.001024'='Uninc. Polk township ' '290019501.001025'-'290019501.001026'='Uninc. Nineveh township ' '290019501.001027'-'290019501.001029'='Uninc. Polk township ' '290019501.001030'='Uninc. Nineveh township ' '290019501.001031'-'290019501.001032'='Uninc. Polk township ' '290019501.001033'-'290019501.001035'='Uninc. Nineveh township ' '290019501.001036'-'290019501.001043'='Uninc. Polk township ' '290019501.001044'-'290019501.001046'='Uninc. Clay township ' '290019501.001047'='Uninc. Polk township ' '290019501.001048'-'290019501.001053'='Uninc. Clay township ' ==> Smoblpa.sas <== CREATE $MOBLPA FORMAT CODE PARTIAL LISTING OF CNTLIN DATA SET FMTNAME=$MOBLPA START END COUNTY TYPE LABEL LENGTH HLO 29001 C 4 O 290019501.00101 290019509.00926 29001 C 00300 4 290030101.00101 290030104.00597 29003 C 00200 4 290059501.00101 290059502.00597 29005 C 00100 4 290079501.00101 290079507.00687 29007 C 00500 4 290099601.00101 290099606.00364 29009 C 01900 4 290119601.00101 290119603.00967 29011 C 01700 4 290139701.00101 290139704.00594B 29013 C 01700 4 ==> Smocnty.sas <== /* GENERATED BY GENFMAT MACRO ON 03/23/01 */ /* Edited to add 29000 entry 08/15/02, jgb */ VALUE $mocnty '20043'='Doniphan KS ' /* long story. involves the modot project */ '29 '='Missouri ' '29000'='Missouri ' '29999'='Missouri ' '29001'='Adair ' '001 '='Adair ' '29003'='Andrew ' '003 '='Andrew ' '29005'='Atchison ' '005 '='Atchison ' '29007'='Audrain ' ==> Smocntye.sas <== /* Extended Missouri county codes, assigning labels to special pseudo-county codes as used by Missouri Economic Research and Info Center (MERIC). Codes 555 and 600 added for use with taxsales files 1-06. */ PROC FORMAT DDNAME=library ; VALUE $mocntye '29555','555'='Misc Locations in MO' '29600','600'='Outside Missouri' '29995','995'='In-State No Fixed Location' '29996','996'='Overseas' '29998','998'='Out-of-State' '29999','999'='Unknown' other=[$mocnty]; /* Sample usage: %libname(empwage); ==> Smocogrp.sas <== /* *<============SPECIAL NOTE: THIS FORMAT SHOULD NOT BE USED FOR THE COUNTIES IN THE KANSAS CITY AREA. CLAY, JACKSON AND PLATTE COUNTIES CANNOT BE MAPPED INTO A SINGLE COUNTY GROUP. THEY ARE SPLIT INTO COUNTY GROUPS 8-10 PLUS PARTS OF 11 AND 12 (ALL OF COGRPS 8-10 ARE MADE UP OF THESE 3 COUNTIES). THE RESULT FIELDS FOR THESE 3 COUNTIES HAVE BEEN EDITED TO "XXX". ============================================= ; NAME:$MOCOGRP DESCRIPTION: MO COUNTY TO 1980 PUMSA COGRP PGMR: BLODGETT DATE CREATED: 5-1-90 ARGUMENT: 5-CHARACTER FIPS COUNTY CODE (1ST 2 DIGITS ALWAYS '29') VALUE RETURNED: 3-DIGIT COUNTY GROUP CODE AS USED ON 1980 PUMSA ==> Smoconmfp.sas <== /* GENERATED BY GENFMAT MACRO ON 04/03/2003 */ /* Edited 5/27/2006 9:11AM to add alternate versions of De Kalb */ /* Edited 2/22/2007 1:04PM to add St. Louis County entry */ PROC FORMAT DDNAME=library ; VALUE $moconmfp 'Adair'='29001' 'Andrew'='29003' 'Atchison'='29005' 'Audrain'='29007' 'Barry'='29009' 'Barton'='29011' 'Bates'='29013' 'Benton'='29015' 'Bollinger'='29017' 'Boone'='29019' ==> Smocorgn.sas <== /* GENERATED BY GENFMAT MACRO ON 09/08/2001 */ PROC FORMAT DDNAME=library ; VALUE $mocorgn '29001'='407 Northeast ' '29003'='408 Northwest ' '29005'='408 Northwest ' '29007'='302 Central ' '29009'='412 Southwest ' '29011'='412 Southwest ' '29013'='414 West Central ' '29015'='414 West Central ' '29017'='405 Lower East Central-Cape ' '29019'='302 Central ' '29021'='408 Northwest ' '29023'='401 Bootheel ' ==> Smodel.sas <== /* NAME: DESCRIPTION: PGMR: jgb DATE CREATED: ARGUMENT: VALUE RETURNED: SAMPLE ENTRY(S): GEOGRAPHIC AREA COVERED: SOURCE USED TO GENERATE: ==> Smodot.sas <== /* ------------------------------------------------------------------- NAME: $modot Description: Names for Missouri DOT regions. PGMR: J. Blodgett DATE CREATED: 01/08/2002 ARGUMENT: 2-CHARACTER DOT region code with leading 0. VALUE RETURNED: Name of region (by oseda, for now). ==> Smofplace.sas <== /* GENERATED BY GENFMAT MACRO ON 03/23/01 */ PROC FORMAT DDNAME=LIBRARY ; VALUE $mofplace '00244 '='Adrian city ' '2900244'='Adrian city ' '00262 '='Advance city ' '2900262'='Advance city ' '00280 '='Affton CDP ' '2900280'='Affton CDP ' '00298 '='Agency village ' '2900298'='Agency village ' '00424 '='Airport Drive village ' '2900424'='Airport Drive village ' '00496 '='Alba city ' '2900496'='Alba city ' ==> Smomcd.sas <== /* GENERATED BY GENFMAT MACRO ON 03/23/01 */ PROC FORMAT DDNAME=LIBRARY ; VALUE $momcd '04546 '='Benton township ' '2904546'='Benton township ' '14248 '='Clay township ' '2914248'='Clay township ' '41924 '='Liberty township ' '2941924'='Liberty township ' '50096 '='Morrow township ' '2950096'='Morrow township ' '52526 '='Nineveh township ' '2952526'='Nineveh township ' '57224 '='Pettis township ' '2957224'='Pettis township ' ==> Smomcds2.sas <== VALUE $MOMCDS '001005'='BENTON ' '001010'='CLAY ' '001015'='LIBERTY ' '001020'='MORROW ' '001025'='NINEVEH ' '001030'='PETTIS ' '001035'='POLK ' '001040'='SALT RIVER ' '001045'='WALNUT ' '001050'='WILSON ' '003005'='BENTON ' '003010'='CLAY ' '003015'='EMPIRE ' '003020'='JACKSON ' '003025'='JEFFERSON ' '003030'='LINCOLN ' '003035'='MONROE ' '003040'='NODAWAY ' '003045'='PLATTE ' '003050'='ROCHESTER ' '005005'='BENTON ' '005010'='BUCHANAN ' '005015'='CLARK ' '005020'='CLAY ' '005025'='COLFAX ' '005030'='DALE ' '005035'='LINCOLN ' '005040'='NISHNABOTNA ' '005045'='POLK ' '005050'='TARKIO ' ==> Smonamef.sas <== /* GENERATED (originally) BY GENFMAT MACRO ON 04/03/2003 and **manually edited** to add various alternate spelling and upper case values. Used extensively in the kidscnt conversion routintes. Arg is a Missouri county name, spelled out. Label returned is the 5-digit FIPS county code. */ PROC FORMAT DDNAME=library ; VALUE $monamef 'Adair'='29001' 'Andrew'='29003' 'Atchison'='29005' 'Audrain'='29007' 'Barry'='29009' 'Barton'='29011' 'Bates'='29013' 'Benton'='29015' 'Bollinger'='29017' 'Boone'='29019' ==> Smoplace.sas <== /* NAME:$MOPLACE DESCRIPTION: MO. FIPS PLACE CODES, PLACE DESCRIPTIONS PGMR: JGB DATE CREATED: 6-92 ARGUMENT: 4-CHAR. MO. FIPS PLACE CODE VALUE RETURNED: PLACE NAME STRING SAMPLE ENTRY(S): '1355'='EUREKA ' GEOGRAPHIC AREA COVERED: MO. SOURCE USED TO GENERATE: STF903A: MISSOURI ==> Smoplco.sas <== /* GENERATED BY GENFMAT MACRO ON 10/28/2004 */ VALUE $moplco '2900244'='29013 Bates MO' '2900262'='29207 Stoddard MO' '2900280'='29189 St. Louis MO' '2900298'='29021 Buchanan MO' '2900424'='29097 Jasper MO' '2900496'='29097 Jasper MO' '2900514'='29075 Gentry MO' '2900568'='29167 Polk MO' '2900604'='29045 Clark MO' '2900712'='29227 Worth MO' '2900748'='29031 Cape Girardeau MO' '2900802'='29107 Lafayette MO' '2900910'='29061 Daviess MO' ==> Smopow.sas <== /* GENERATED BY GENFMAT MACRO ON 05/14/99 */ PROC FORMAT DDNAME=library ; VALUE $mopow '2900101'='Kirksville city ' '2900102'='Remainder of Adair County ' '2900103'='Sullivan County ' '2900104'='Schuyler County ' '2900105'='Scotland County ' '2900106'='Knox County ' '2900107'='Macon city ' '2900108'='Remainder of Macon County ' '2900109'='Lewis County ' '2900110'='Linn County ' '2900111'='Shelby County ' '2900112'='Davis County, IA ' ==> Smopuma.sas <== /* NAME: $mopuma DESCRIPTION: Short names for 2000 Missouri Public Use Microdata Areas, used on 5% files PGMR: J. Blodgett, OSEDA & L. DeMaio, DED DATE CREATED: 9-1-05 ARGUMENT: 5-digit PUMA code or 7-digit (with 29 pre-appended - separate entries) VALUE RETURNED: Short name/description. SAMPLE ENTRY(S): '00400'='Hannibal Area' GEOGRAPHIC AREA COVERED: Missouri SOURCE USED TO GENERATE: PUMA maps from Census Bureau. ==> Smopuma90.sas <== /* NAME:$MOPUMA DESCRIPTION: NAMES MISSOURI PUMA'S USED IN 1990 PUMS "A" FILES. PGMR: JGB DATE CREATED: 9-22-93 ARGUMENT: PUMA CODE (CHARACTER, LENGTH 5) VALUE RETURNED: CODE FOLLOWED BY DESCRIPTIVE TITLE SAMPLE ENTRY(S): '00100'='00100 EXTREME NW CORNER' GEOGRAPHIC AREA COVERED: STATE OF MISSOURI. SOURCE USED TO GENERATE: PUMS EQUIVALENCY FILE FROM CENSUS BUREAU. ==> Smoschl.sas <== /* NAME:$MOSCHL DESCRIPTION: RETURNS SCHOOL DISTRICT NAME FOR MISSOURI SCHOOL DISTRICTS WHEN GIVEN 5-DIGIT NCES/ELSEGIS ID CODE. *<=========$SCHOOL ENTRY SUPERCEDES THIS ONE========== PGMR: JWS DATE CREATED: 5-08-89 ARGUMENT: 5-DIGIT NCES/ELSEGIS SCHOOL DISTRICT CODE (UNIQUE WITHIN STATE). VALUE RETURNED: NAME OF SCHOOL DISTRICT. SAMPLE ENTRY(S): '22980'='ADAIR CO R I' ==> Smotrloc.sas <== /* GENERATED BY GENFMAT MACRO ON 09/12/2001 */ VALUE $motrloc '290019501.00'='Uninc. Wilson township (et. al) ' '290019502.00'='Uninc. Pettis township (et. al) ' '290019503.00'='Kirksville ' '290019504.00'='Kirksville (mostly) ' '290019505.00'='Kirksville ' '290019509.00'='Kirksville ' '290019510.00'='Kirksville ' '290030101.00'='Uninc. Monroe township (mostly) ' '290030102.00'='Savannah (mostly) ' '290030103.00'='Uninc. Lincoln township (mostly) ' '290030104.00'='Uninc. Rochester township (mostly) ' '290059501.00'='Tarkio (mostly) ' '290059502.00'='Rock Port (mostly) ' ==> Smovtd.sas <== /* GENERATED BY GENFMAT MACRO ON 03/23/01 */ PROC FORMAT DDNAME=LIBRARY ; VALUE $movtd '290012 '='Brashear VTD* ' '0012 '='Brashear VTD* ' '290013 '='Federal VTD* ' '0013 '='Federal VTD* ' '290014 '='Gibbs VTD* ' '0014 '='Gibbs VTD* ' '290015 '='Millard VTD* ' '0015 '='Millard VTD* ' '290016 '='NEBenton-4 VTD* ' '0016 '='NEBenton-4 VTD* ' '290017 '='NEBenton-5 VTD* ' '0017 '='NEBenton-5 VTD* ' ==> Smozipco.sas <== /* GENERATED BY GENFMAT MACRO ON 05/02/97 */ PROC FORMAT DDNAME=LIBRARY ; VALUE $mozipco '63005'='29189' '63010'='29099' '63011'='29189' '63012'='29099' '63013'='29071' '63014'='29071' '63015'='29071' '63016'='29099' '63017'='29189' '63019'='29099' '63020'='29099' '63021'='29189' ==> Smponame.sas <== /* GENERATED BY GENFMAT MACRO ON 10/07/2002 Redone per e-mail note from Lance H 1-2-2003. Edited name of Jefferson city MPO, 11-11-03. PROC FORMAT DDNAME=library ; VALUE $mponame '1'='City of Columbia' '2'='East West Gateway Coordinating Council' '3'='City of Jefferson City' '4'='City of Joplin' '5'='Mid-America Regional Council' '6'='City of Springfield' '7'='City of St. Joseph' '9'='Non-MPO area' ; 4/4/2006 12:06PM: ==> Smsa.sas <== /* NAME:$MSA DESCRIPTION: MSA NAMES (METROPOLITAN STATISTICAL AREAS) PGMR: JGB DATE CREATED: 1988 ARGUMENT: 4-CHARACTER FIPS MSA CODE. VALUE RETURNED: MSA TITLE (NAME) SAMPLE ENTRY(S): "0720"="BALTIMORE, MD" GEOGRAPHIC AREA COVERED: U.S. SOURCE USED TO GENERATE: COSTAT2. ==> Smsacmsa.sas <== *---This is just an alisa for $metro----; proc format library=library; value $msacmsa '0000'-'9999'=[$metro]; run; ==> Smsapmsa.sas <== /* NAME:$msapmsa DESCRIPTION: Returns names of MSAs and PMSAs (Metropolitan Statistical Areas and Primary MSAs) PGMR: JGB DATE CREATED: 12-30-03 ARGUMENT: 4-character (digit) metro code VALUE RETURNED: Name of area in mixed case including state or states and metro type word SAMPLE ENTRY(S): '0240'='Allentown-Bethlehem, PA-NJ MSA ' ==> Snaics.sas <== /* GENERATED BY GENFMAT MACRO ON 06/04/07 */ PROC FORMAT DDNAME=LIBRARY ; VALUE $naics '------'='Total' '11----'='Forestry, fishing, hunting, and agriculture support' '11 '='Forestry, fishing, hunting, and agriculture support' '113///'='Forestry and logging' '113 '='Forestry and logging' '1131//'='Timber tract operations' '1131 '='Timber tract operations' '11311/'='Timber tract operations' '11311 '='Timber tract operations' '113110'='Timber tract operations' '1132//'='Forest nurseries & gathering forest products' '1132 '='Forest nurseries & gathering forest products' ==> Snaics02.sas <== /* GENERATED BY GENFMAT MACRO ON 06/06/07 Name edited to get around proc export glitch. */ PROC FORMAT DDNAME=LIBRARY ; VALUE $naic02_ '------'='Total' '11----'='Forestry, Fishing, Hunting, and Agriculture Support' '11 '='Forestry, Fishing, Hunting, and Agriculture Support' '113///'='Forestry and Logging' '113 '='Forestry and Logging' '1131//'='Timber Tract Operations' '1131 '='Timber Tract Operations' '11311/'='Timber Tract Operations' '11311 '='Timber Tract Operations' '113110'='Timber Tract Operations' '1132//'='Forest Nurseries and Gathering of Forest Products' ==> Snaics2_.sas <== /* GENERATED BY GENFMAT MACRO ON 06/04/07 */ PROC FORMAT DDNAME=LIBRARY ; VALUE $naics2_ '11'='Forestry, fishing, hunting, and agriculture support' '21'='Mining' '22'='Utilities' '23'='Construction' '31'='Manufacturing' '42'='Wholesale trade' '44'='Retail trade' '48'='Transportation & warehousing' '51'='Information' '52'='Finance & insurance' '53'='Real estate & rental & leasing' '54'='Professional, scientific & technical services' ==> Snecma.sas <== /* NAME:$NECMA DESCRIPTION: NEW ENGLAND COUNTY METROPOLITAN AREAS PGMR: JGB DATE CREATED: 1988 Rev. 4/99 for new defn 7/98 ARGUMENT: 4-CHARACTER NECMA CODE. VALUE RETURNED: NECMA TITLE (NAME) SAMPLE ENTRY(S): "0733"="Bangor, ME NECMA" GEOGRAPHIC AREA COVERED: NEW ENGLAND SOURCE USED TO GENERATE: Census Bureau web site. ==> Snecta.sas <== /* GENERATED BY GENFMAT MACRO ON 02/14/07 */ PROC FORMAT DDNAME=LIBRARY ; VALUE $necta '70300'='Amherst Center, MA Micropolitan NECTA ' '70450'='Athol, MA Micropolitan NECTA ' '70600'='Augusta, ME Micropolitan NECTA ' '70750'='Bangor, ME Metropolitan NECTA ' '70900'='Barnstable Town, MA Metropolitan NECTA ' '71050'='Barre, VT Micropolitan NECTA ' '71350'='Bennington, VT Micropolitan NECTA ' '71500'='Berlin, NH Micropolitan NECTA ' '71650'='Boston-Cambridge-Quincy, MA-NH Metropolitan NECTA ' '71950'='Bridgeport-Stamford-Norwalk, CT Metropolitan NECTA ' '72250'='Brunswick, ME Micropolitan NECTA ' '72400'='Burlington-South Burlington, VT Metropolitan NECTA ' ==> Snectadv.sas <== /* GENERATED BY GENFMAT MACRO ON 02/14/07 */ PROC FORMAT DDNAME=LIBRARY ; VALUE $nectadv '71654'='Boston-Cambridge-Quincy, MA NECTA Division ' '72104'='Brockton-Bridgewater-Easton, MA NECTA Division ' '73104'='Framingham, MA NECTA Division ' '73604'='Haverhill-North Andover-Amesbury, MA-NH NECTA Division ' '74204'='Lawrence-Methuen-Salem, MA-NH NECTA Division ' '74804'='Lowell-Billerica-Chelmsford, MA-NH NECTA Division ' '74854'='Lynn-Peabody-Salem, MA NECTA Division ' '75404'='Nashua, NH-MA NECTA Division ' '78254'='Taunton-Norton-Raynham, MA NECTA Division ' ; ==> Snemc2ma.sas <== /* GENERATED BY GENFMAT MACRO ON 08/05/97 */ PROC FORMAT DDNAME=LIBRARY ; VALUE $nemc2ma '09001005 '='5602C' '09001005P'='1930P' '09001010 '='5602C' '09001010P'='1160P' '09001015 '='5602C' '09001015P'='1930P' '09001020 '='5602C' '09001020P'='1930P' '09001025 '='5602C' '09001025P'='8040P' '09001030 '='5602C' '09001030P'='1160P' ==> Snepl2mc.sas <== /* NAME: $nepl2mc DESCRIPTION: New England FIPS place to MCD table: 1-to-1 correspondences only. PGMR: jgb DATE CREATED: 8-4-97 ARGUMENT: FIPS state+county+place codes (2+3+5) VALUE RETURNED: FIPS MCD code (cousubfp) SAMPLE ENTRY(S): '0900104790'='04720' '0900108000'='08070' GEOGRAPHIC AREA COVERED: 6 New England states ==> Snumstrt.sas <== /* GENERATED BY GENFMAT MACRO ON 02/16/98 */ PROC FORMAT DDNAME=LIBRARY ; VALUE $numstrt 'EIGHTEENTH '='018' 'EIGHTH '='008' 'EIGHTIETH '='080' 'EIGHTY-EIGHTH '='088' 'EIGHTY-FIFTH '='085' 'EIGHTY-FIRST '='081' 'EIGHTY-FOURTH '='084' 'EIGHTY-NINTH '='089' 'EIGHTY-SECOND '='082' 'EIGHTY-SEVENTH '='087' 'EIGHTY-SIXTH '='086' 'EIGHTY-THIRD '='083' ==> Spattabl.sas <== /* GENERATED BY GENFMAT MACRO ON 02/13/98 */ PROC FORMAT DDNAME=LIBRARY ; VALUE $pattabl '1 '='5 ' '11 '='55 ' '112 '='552 ' '1125 '='552 ' '115 '='615 ' '1151 '='1555 ' '11512 '='15552 ' '1152 '='6152 ' '11522 '='11522 ' '1155 '='1555 ' '11552 '='15552 ' '12 '='52 ' ==> Splace.sas <== /* NAME:$place DESCRIPTION: Names for FIPS place codes in US, 2000 census and 2003 updates . Similar to the $fplace format, but THAT format has only places on the 2000 census (no entries for post-2000 incorporations) and does not have the state abbrev in the label. THIS format does have the new places and the postal abbreviations added. PGMR: JGB DATE CREATED: 9/15/2004 ARGUMENT: 2-digit FIPS state code || 5-digit FIPS place code. VALUE RETURNED: Names of the place (city) followed by a comma and the state abbrev. ==> Splccnvt.sas <== /* GENERATED BY GENFMAT MACRO ON 05/04/94 */ /* IMPORTANT NOTE: We created a reverse of this conversion format code in job /mscdc/ciesin/mable/mable06.sas. That format code is $fplccnv. It takes a 7-char arg of state||placefp and returns a ********* 4-character census place code. Has other=' ' spec and will return '9999' if last 5 digits of arg are '99999'. jgb 3-2-96----*; PROC FORMAT DDNAME=LIBRARY ; VALUE $PLCCNVT '010005'='0100124' '010010'='0100460' '010015'='0100484' '010020'='0100676' '010025'='0100820' '010030'='0100988' '010035'='0101132' '010040'='0101228' '010045'='0101396' '010050'='0101660' '010055'='0101708' '010057'='0101756' '010060'='0101852' '010065'='0102116' ==> Spmacnvt.sas <== /* NAME:$pmacnvt DESCRIPTION: Convert 3-char StL PUMA codes to "official" 5-digit A-PUMA codes, 90. PGMR: JGB. DATE CREATED: 2/97 ARGUMENT: 3-CHARACTER puma code as used by UIC in early 90's to assign St. Louis metro-west (5-county area) PUMA areas. VALUE RETURNED: Official 5-digit 1990 PUMA code (A file). SAMPLE ENTRY(S): "1CE"="01201" GEOGRAPHIC AREA COVERED: 5 couties in Mo portion of St L MSA, 1990. ==> Spmsa.sas <== /* NAME:$PMSA DESCRIPTION: PRIMARY METROPOLITAN STATISTICAL AREAS PGMR: JGB DATE CREATED: 1980 ARGUMENT: 4-CHARACTER PMSA CODE (FIPS) VALUE RETURNED: PMSA TITLE (NAME) SAMPLE ENTRY(S): "0080"="AKRON,OH" "7440"="SAN JUAN,PR" GEOGRAPHIC AREA COVERED: U.S. SOURCE USED TO GENERATE: COSTAT2 APPENDIX ==> Spmsa94_.sas <== /* GENERATED BY GENFMAT MACRO ON 10/20/95 */ PROC FORMAT DDNAME=LIBRARY ; VALUE $pmsa94_ '0080'='Akron, OH (P) ' '0440'='Ann Arbor, MI (P) ' '0560'='Atlantic-Cape May, NJ (P) ' '0720'='Baltimore, MD (P) ' '0875'='Bergen-Passaic, NJ (P) ' '1120'='Boston, MA-NH (P) ' '1125'='Boulder-Longmont, CO (P) ' '1145'='Brazoria, TX (P) ' '1150'='Bremerton, WA (P) ' '1160'='Bridgeport, CT (P) ' '1200'='Brockton, MA (P) ' '1600'='Chicago, IL (P) ' ==> Spmsacms.sas <== PROC FORMAT DDNAME=SASLIB ; /* GENERATED BY SETUP IN $6386.SASFMATS.CNTL($PMSACMS) 5-92. BASED ON MISC.COMCODES DATA SET WHICH IS BASED ON METRO CODES OF 6/91 FROM COSTAT4. ARG IS 4-CHAR. PMSA CODE. LABEL IS 4-CHAR CMSA CODE, A BLANK AND THE CMSA NAME. JGB, 5-13-92 */ VALUE $PMSACMS '0080'='1692 CLEVELAND-AKRON-LORAIN, OH ' '0360'='4472 LOS ANGELES-ANAHEIM-RIVERSIDE, CA ' '0440'='2162 DETROIT-ANN ARBOR, MI ' '0620'='1602 CHICAGO-GARY-LAKE CNTY,IL-IN-WI ' '0845'='6282 PITTSBURGH-BEAVER VALLEY, PA ' '0875'='5602 NY-NORTHERN NJ-LONG ISL, NY-NJ-CT ' '1125'='2082 DENVER-BOULDER, CO ' '1145'='3362 HOUSTON-GALVESTON-BRAZORIA, TX ' ==> Spuma1eq.sas <== Proc format library=pums2000.formats; Value $puma1eq '01043 '-'010439999999999999999'='01100' '01079 '-'010799999999999999999'='01100' '01083 '-'010839999999999999999'='01100' '01089 '-'010899999999999999999'='01100' '01095 '-'010959999999999999999'='01100' '01103 '-'011039999999999999999'='01100' '01133 '-'011339999999999999999'='01100' '01015 '-'010159999999999999999'='01200' '01019 '-'010199999999999999999'='01200' '01027 '-'010279999999999999999'='01200' '01029 '-'010299999999999999999'='01200' '01049 '-'010499999999999999999'='01200' '01055 '-'010559999999999999999'='01200' ==> Spuma51_.sas <== /* NAME:$puma51_ DESCRIPTION: Relates 5 percent puma (Public Use Microsample Area, 2000, i.e. PUMA5) codes within state to "Superpuma" (PUMA1) codes. PGMR: JGB DATE CREATED: 10/03 ARGUMENT: FIPS state code || 5-digit PUMA5 code (2000) VALUE RETURNED: 5-digit "Superpuma" (PUMA1) code (as used in the 1 percent PUMS files) SAMPLE ENTRY(S): '0100100'='01300' (the PUMA5 code 00100 in Alabama is completely contained wihtin the 01300 superpuma area. ==> Sracspan.sas <== /* NAME:$RACSPAN DESCRIPTION: LABELS FOR RACE/HISPANIC CODES USED ON EEO FILES. PGMR: BEE SOO DATE CREATED: 8-21-92 ARGUMENT: 2-CHAR RACSPAN CODE. VALUE RETURNED: CODE FOLLOWED BY LABEL. SAMPLE ENTRY(S): '01'='01 TOTAL' '02'='02 HISPANIC' GEOGRAPHIC AREA COVERED: NA SOURCE USED TO GENERATE: 1980 EEO TECH DOC. ==> Srecoind.sas <== /* ##########JUDY WILL FIX THIS SOON ####### ???? NAME:$RECOIND DESCRIPTION: STF4 (1980) RACE/ORIGIN PGMR: JWS DATE CREATED: CIRCA 1983 COPIED FROM $F2RACE 12/93, JGB ARGUMENT: 2-CHAR RACE/ORIGIN CODE AS USED ON 1980 STF2/STF4 FILES. VALUE RETURNED: RACE/ORIGIN DESCRIPTION OR "N. A." (OTHER) SAMPLE ENTRY(S): "00"="RACE TOTAL" "20"="MEXICAN" SOURCE USED TO GENERATE: STF2 TECHNICAL DOCUMENT CODES UPDATED AS OF: 1980 ==> Sregion.sas <== /* GENERATED BY GENFMAT MACRO ON 09/08/2001 */ PROC FORMAT DDNAME=library ; VALUE $dedrgn '110'='St. Louis MSA ' '203'='Kansas City MSA ' '213'='Springfield - Branson ' '302'='Central ' '401'='Bootheel ' '404'='Lake Ozark Rolla ' '405'='Lower East Central-Cape ' '406'='North Central ' '407'='Northeast ' '408'='Northwest ' '411'='South Central ' '412'='Southwest ' ==> Srpcname.sas <== /* NAME:$RPCNAME DESCRIPTION: ASSOCIATES MO. REGIONAL PLANNING COMMISSION NAMES WITH NEW RPC CODES (4/92) PGMR: jgb DATE CREATED: 5/21/92 Editing to eliminate code as part of returned label and to make names mixed case, jgb, 4-01. Edit to change name from Show-Me to Pioneer Trails, 9-13-02. EJC edited to make corrections to RPC - Bootheel, East-West Gateway, Mid-Missouri RPC, Northwest Missouri RPC, Pioneer Trails RPC and Southeast Missouri Regional Planning and Economic Dev. Comm., 2-18-03 ARGUMENT: 2-DIGIT RPC CODE (SEE $CNTYRPC) ) VALUE RETURNED: NAME OF MO. REGIONAL PLANNING COMMISSION (RPC). ==> Srrpob.sas <== proc format; *--used in standardizing addresses---; value $rrpob 'RT'='RR' 'ROUTE'='RR' 'RURAL ROUTE'='RR' 'RURAL RTE'='RR' 'RURAL RT'='RR' 'RUR RTE'='RR' 'RUR RT'='RR' 'R R'='RR' 'RURAL FREE DELIVERY'='RFD' 'RUR FREE DELIV'='RFD' 'RUR FREE DEL'='RFD' 'R F D'='RFD' ==> Srtl87kb.sas <== /* NAME:$RTL87KB DESCRIPTION: "KIND-OF-BUSINESS" (KB) CODES, DESCRIPTIONS PGMR: DN DATE CREATED: 1-90 ARGUMENT: 3-CHAR. KB CODE VALUE RETURNED: DESCRIPTIVE STRING SAMPLE ENTRY(S): '158'='Fuel and ice dealers ' GEOGRAPHIC AREA COVERED: US SOURCE USED TO GENERATE: CENSUS OF RETAIL TRADE, 1987 (FILE) ==> Sschcnvt.sas <== /* NAME:$SCHCNVT DESCRIPTION: FOR MO CONVERT NCES SCHOOL CODES (5-DIGIT) TO 6-DIGIT CODES USED BY MO. DESE. PGMR: JGB DATE CREATED: 6/93 MODIFIED 1/94, ADDING 00002 ENTRY ,JGB 1/19/94: FIXING ENTRY FOR 00003 ARGUMENT: 5-DIGIT SCHOOLD CODE (LEAID) USED BY NCES ON CORE FILES AND ON 1990 SCHOOL FILES. VALUE RETURNED: 6-DIGIT DISTRICT CODE USED IN MO BY MODESE. SAMPLE ENTRY(S): '00001'='063067' GEOGRAPHIC AREA COVERED: MISSOURI. ==> Sschool.sas <== PROC FORMAT DDNAME=LIBRARY ; VALUE $SCHOOL '00001'='MARIES COUNTY R II ' '00002'='SOUTH HARRISON R II ' '00003'='PORTAGEVILLE SCHOOL DISTRICT ' '00004'='NEW MADRID R I ' '01000'='COLUMBIA SCHOOL DISTRICT 93 ' '02577'='STATE SCH FOR SEVERELY HANDCPD' '02850'='ADRIAN R III ' '02880'='ADVANCE R IV ' '02910'='AFFTON SCHOOL DISTRICT 101 ' '02970'='ALBANY R III ' '03000'='SANTA FE R-X ' /* Prior to 1993 was LAFAYETTE R-X. Fixed here, 6-04 */ '03040'='ALTENBURG SCHOOL DISTRICT 48 ' '03060'='ALTON R IV ' ==> Ssegout.sas <== /* GENERATED BY GENFMAT MACRO ON 03/06/98 */ PROC FORMAT DDNAME=LIBRARY ; VALUE $segout '101'='N ' '102'='S ' '103'='E ' '104'='W ' '113'='NE ' '114'='NW ' '123'='SE ' '124'='SW ' '201'='ST ' '202'='RD ' '203'='EXT ' '204'='BLVD' ==> Ssegtabl.sas <== /* GENERATED BY GENFMAT MACRO ON 03/06/98 */ PROC FORMAT DDNAME=LIBRARY ; VALUE $segtabl '# '='305' 'AL '='225' 'ALLEY '='225' 'ALY '='225' 'ANNEX '='219' 'ANX '='219' 'AP '='301' 'APT '='301' 'AV '='207' 'AVE '='207' 'AVENIDA '='207' 'AVENUE '='207' ==> Ssenate.sas <== /* NAME: $senate DESCRIPTION: Returns name of incumbent state senator for Missouri state senate. PGMR: lcm DATE CREATED: 3-98 ARGUMENT: 2-character Missouri state senate code VALUE RETURNED: Name and party affiliation of current senator from that district. SAMPLE ENTRY(S): "02"="Ted House (D)" GEOGRAPHIC AREA COVERED: State of Missori SOURCE USED TO GENERATE: ?? Linda found it in a publication. ==> Ssf4dset.sas <== /* This format code labels the 2000 sf4 dataset names as stored on the charitsets index sets. John Blodgett, MCDC, May, 2003. */ value $sf4dset 'Total'='Total Pop only (chariter 001)' 'RaceA'='Just the Basic 6 Race Groups, the "Alone" versions (chariters 002,004,006,012,050,070)' 'RaceAC'='Just the Basic 6 again but now the "Alone or in Combination with" versions (chariters 003,005,009,031,060,071)' 'RaceD'='Detailed race, including multi-racial cats (chariters 007,008,010,011,013-030,032-049,051-059,061-069,100-199)' 'Tribes'='American Indian & Alaskan native tribes (chariters 200-299)' 'Hispanic'='Total and detailed Hispanic categories (chariters 400-449)' 'NonHisp'='Total Non-Hispanic and Non-H by race categories (chariters 450-499)' 'Ancestry'='Ancestry-based categories (chariters 500-585)'; ==> Ssic87nm.sas <== /* NAME:$SIC87NM DESCRIPTION: ASSOCIATES INDUSTRY NAMES WITH 1987 SIC CODES. PGMR: JGB DATE CREATED: 5/23/90 ARGUMENT: SIC CODE (AS CODED IN PUBLIC.SICREF87) MAY CONTAIN DASHES TO INDICATE INDUSTRY DIVISIONS, WHILE 2 AND 3-DIGIT LEVELS ARE REPRESENTED WITH TRAILING 0'S AND TRAILING BLANKS (I.E. THERE IS A '25 ' AND A '2500'). VALUE RETURNED: INDUSTRY NAMES ASSOCIATED WITH THE SIC CODE. SAMPLE ENTRY(S): '----'='TOTAL' '10--'='MINING' '10 '='METAL MINING' '1000'='METAL MINING' '1040'='GOLD AND SILVER ORES' '1041'='GOLD ORES' ==> Ssicname.sas <== /* 1977 SIC INDUSTRIES */ PROC FORMAT DDNAME=SASLIB ; VALUE $SICNAME '----'='TOTAL' '07--'='AGRICULTURAL SERVICES,FORESTRY,FISHERIES' '0700'='AGRICULTURAL SERVICES ' '07 '='AGRICULTURAL SERVICES ' '0710'='SOIL PREPARATION SERVICES' '071 '='SOIL PREPARATION SERVICES' '0720'='CROP SERVICES ' '072 '='CROP SERVICES ' '0740'='VETERINARY SERVICES ' '074 '='VETERINARY SERVICES ' '0750'='ANIMAL SERVICES, EXCEPT VETERINARY ' '075 '='ANIMAL SERVICES, EXCEPT VETERINARY ' ==> Sslvl.sas <== /* ------------------------------------------------------------------- NAME:$SLVLWC ($SLVL) DESCRIPTION: Geographic summary levels with codes. Mostly values used by CB on 90 census. ($slvl and $slvlwc are the same format code now. Prior to 2-4-97 they were separate modules. When modifying, the format proc should be invoked twice, to compile it under both names.) *************!!!!!!!!**********NOTE**********!!!!!!!! Problems with defining $slvlwc using the new feature with otehr=(|$slvl|) - program referencing $slvlwc. caused sas to abend. So not doing that again. Run it twice, once with each of the 2 names. PGMR: JGB DATE CREATED: 2/4/97 ARGUMENT: 3-CHARACTER GEOGRAPHIC SUMMARY LEVEL USED ON 90 CENSUS SUMMARY FILES, and some special codes invented by the UIC or MSCDC ==> Sslvlwc.sas <== /* ------------------------------------------------------------------- NAME:$SLVLWC ($SLVL) DESCRIPTION: Geographic summary levels with codes. Mostly values used by CB on 90 census. ($slvl and $slvlwc are the same format code now. Prior to 2-4-97 they were separate modules. When modifying, the format proc should be invoked twice, to compile it under both names.) *************!!!!!!!!**********NOTE**********!!!!!!!! Problems with defining $slvlwc using the new feature with otehr=(|$slvl|) - program referencing $slvlwc. caused sas to abend. So not doing that again. Run it twice, once with each of the 2 names. PGMR: JGB DATE CREATED: 2/4/97 ARGUMENT: 3-CHARACTER GEOGRAPHIC SUMMARY LEVEL USED ON 90 CENSUS SUMMARY FILES, and some special codes invented by the UIC or MSCDC ==> Ssmsa80_.sas <== /* GENERATED BY GENFMAT MACRO ON 01/29/2005 */ PROC FORMAT DDNAME=library ; VALUE $smsa80_ '0040'='Abilene, Tex. SMSA' '0080'='Akron, Ohio SMSA' '0120'='Albany, Ga. SMSA' '0160'='Albany-Schenectady-Troy, N.y. SMSA' '0200'='Albuquerque, N. Mex. SMSA' '0220'='Alexandria, La. SMSA' '0240'='Allentown-Bethlehem-Easton, Pa.- SMSA' '0280'='Altoona, Pa. SMSA' '0320'='Amarillo, Tex. SMSA' '0360'='Anaheim-Santa Ana-Garden Grove, SMSA' '0380'='Anchorage, Alaska SMSA' '0400'='Anderson, Ind. SMSA' ==> Sstabfip.sas <== /* ------------------------------------------------------------------- NAME: $stabfip Description: Takes state postal abbreviation as arg and returns 2-digit FIPS state code. PGMR: J. Blodgett DATE CREATED: 12/19/2001 ARGUMENT: 2-CHARACTER state (or territory) postal abbreviation in upper case. ==> Sstate.sas <== /* NAME:$STATE DESCRIPTION: State (and related entity) Names PGMR: JGB DATE CREATED: ? Last revised: 3-14-05: Adding entry 00 for United States. ARGUMENT: 2-CHARACTER FIPS STATE CODE. (or state equiv) VALUE RETURNED: NAME OF THE STATE or entity (country or outlying area) SAMPLE ENTRY(S): "01"="Alabama" "71"="Midway Islands" "72"="Puerto Rico" "00"="United States". GEOGRAPHIC AREA COVERED: U.S. and outlying areas. SOURCE USED TO GENERATE: 1990 GICS. ==> Sstdivr.sas <== /* NAME:$stdivr DESCRIPTION: Returns state divsion and region codes. PGMR: jgb DATE CREATED: 10/28/98 ARGUMENT: 2-CHARACTER FIPS state code. VALUE RETURNED: 2 characters: division code || region code SAMPLE ENTRY(S): '29'='42' (Missouri in Divsion 4, Region 2) SOURCE USED TO GENERATE: gics90.states CODES UPDATED AS OF: 1990 ==> Sstfpcen.sas <== /* GENERATED BY GENFMAT MACRO ON 10/21/95 */ PROC FORMAT DDNAME=LIBRARY ; VALUE $stfpcen '01'='63' '02'='94' '04'='86' '05'='71' '06'='93' '08'='84' '09'='16' '10'='51' '11'='53' '12'='59' '13'='58' '15'='95' ==> Sstnmfps.sas <== proc format ; /* NAME:$STNMFPS DESCRIPTION: Converts state names to FIPS codes PGMR: JGB DATE CREATED: 6-14-00 ARGUMENT: Mixed case name or upper case postal abbreviation of state or state equiv. VALUE RETURNED: 2-digit FIPS code with leading 0. SAMPLE ENTRY(S): "Alabama","AL" = "01" "Puerto Rico","PR" = "72" GEOGRAPHIC AREA COVERED: U.S. and outlying areas. ==> Ssumlev.sas <== /* ------------------------------------------------------------------- NAME:$Sumlev Description: Geographic summary level codes used on Census files. Numeric codes are set by Census Bureau, alpha codes are locally defined. PGMR: J. Blodgett DATE CREATED: 11/30/2001 LAST MOD: 4/25/2006 3:58PM ARGUMENT: 3-CHARACTER GEOGRAPHIC SUMMARY LEVEL USED ON 1990 or 2000 CENSUS SUMMARY or special tabulation FILES, and some special codes invented by OSEDA / MCDC. The latter to handle locally defined summary level codes for entities such as DED regions, U of Missouri Extension regions or Tract Areas. VALUE RETURNED: A description of the geographic level. Hierarchies are indicated ==> Ssuparea.sas <== *--Names to go with code for DESE Superintendant admin areas, 5/2002 per Lance H.--; *--Coded 5.14.03, jgb---; value $suparea J="Northwest" I="North Central" H="Northeast" G="South Central" F="West Central" E="Southeast" D="Central" C="Southwest" B="Kansas City" A="St. Louis"; run; ==> Ssuperp.sas <== /* NAME:$superp DESCRIPTION: User assigned names for 2000 Missouri SuperPUMAs . PGMR: JGB DATE CREATED: 2/20/2007 11:19AM ARGUMENT: 5-digit 2000 Super PUMA code (aka "puma1") VALUE RETURNED: A descriptive title for the area as assigned by JGB SAMPLE ENTRY(S): '29200'='Mid Missouri' SOURCE USED TO GENERATE: Looked at the map and made up the names. ==> Ssyrrats.sas <== /* NAME: $syrrats DESCRIPTION: Lookup table used by agersex web application. Used to apportion pop in the 15-19 cohort to the 15-17 subcohort. Arg. is the state FIPS code||4-digit year. 00 for state code yields values for US totals. See /mscdc/data/popest/Tools/syrrats.sas for job that generated the source. PGMR: JGB DATE CREATED: 10/99 ARGUMENT: 2-char FIPS state copde || 4-digit year (from 1990 to 1998). VALUE RETURNED: 3 8-char values representing decimal portion of 15-19 yr old people who are 15-17 within that state for that year. ==> Stigcfcc.sas <== /* NAME:$TIGCFCC DESCRIPTION: TIGER/LINE CENSUS FEATURE CLASS CODES PGMR: BLODGETT DATE CREATED: 6-23-89 ARGUMENT: 3-CHAR. CLASS CODE VALUE RETURNED: CLASS CODE WITH CLASS TITLE SAMPLE ENTRY(S): "A00" = "A00 ROAD,CLASS UNKNOWN,N.E.C. " SOURCE USED TO GENERATE: TIGER/LINE FILE TECHNICAL DOC. CODES UPDATED AS OF: 1988 ==> Str8090s.sas <== /* NAME:$TR8090S DESCRIPTION: CONVERT 80 TRACTS TO 90, STL ALLOWING FOR BG-BLK LEVEL ON INPUT WHERE A TRACT WAS SPLIT. PGMR: JWS/JGB DATE CREATED: OCT 91 ARGUMENT: 1980 CENSUS TRACT OR TRACT/BG OR TRACT/BLK AS REQUIRED VALUE RETURNED: 1990 TRACT OR "+" OR "?" (SEE USAGE NOTES) SAMPLE ENTRY(S): "1011.00"="1011.00" "2182.00"="+ " "3109.00413"-"3109.00499"="3109.98" GEOGRAPHIC AREA COVERED: 9-COUNTY ST. LOUIS METRO AREA. ==> Straname.sas <== /* NAME:$TRANAME DESCRIPTION: Assigns names to TRA's (St. Louis tract areas) PGMR: JGB DATE CREATED: 8-16-91 Update: 9-11-91 City entries added 9-12-91. Edited for mixed-case labels 1-98, jgb. ARGUMENT: 4-char. TRA (tract area) code VALUE RETURNED: TRA name in all upper case. 32 chars max. SAMPLE ENTRY(S): "BRID"="Bridgeton" "RIWD"="Riverwood" GEOGRAPHIC AREA COVERED: Eventually, all of St. Louis MSA, but so ==> Strapuma.sas <== VALUE $TRAPUMA 'CARO'='1SO' 'GARD'='1SO' 'SWST'='1SO' 'OAKL'='1SO' 'WEST'='1CE' 'SHER'='1NO' 'NORT'='1NO' 'BADE'='1NO' 'OFAL'='1NO' 'FAIR'='1NO' 'GARF'='1NO' 'FORE'='1CE' 'FMNT'='1SO' 'SHMP'='1SO' ==> Strgploc.sas <== /* 00010000 NAME:$TRGPLOC DESCRIPTION: RETURNS TRACT GROUP LOCATION 00020000 00030000 PGMR: JGB DATE CREATED: 9-10-87 00040000 00050000 ARGUMENT: 4-CHAR. TRACT GROUP CODE 00060000 00070000 VALUE RETURNED: TG LOCATION WITHIN COUNTY (WEST, FAR NORTH, ETC.) 00080002 00090000 SAMPLE ENTRY(S): "2101"="NORTHEAST" 00100000 00110000 GEOGRAPHIC AREA COVERED: MO. PORTION ST LOUIS SMSA 00120000 00130000 SOURCE USED TO GENERATE: NONE (ENTERED MANUALLY). OUR OWN DEFNS. 00140002 00150000 ==> Strgpnm.sas <== /* 00010000 NAME:$TRGPNM DESCRIPTION: RETURNS TRACT GROUP NAME 00020000 00030000 PGMR: JGB DATE CREATED: 9-10-87 00040000 00041006 00050000 ARGUMENT: 4-CHAR. TRACT GROUP CODE 00060000 00070000 VALUE RETURNED: TG NAME (MAX 27 CHAR. TOT) 00080000 00090000 SAMPLE ENTRY(S): "2101"="SPNSH LAKE-BELLFNTN-RIVERVW" 00100001 "9999"="(UNCODED)" 00110003 00111001 GEOGRAPHIC AREA COVERED: MO. PORTION ST LOUIS SMSA 00120000 00130000 ==> Strgrp.sas <== /* 00010000 NAME:$TRGRP DESCRIPTION: RETURNS TRACT GROUP CODE/NAME 00020000 00030000 PGMR: JGB DATE CREATED: 9-8-87 00040000 EDITED: 3-19-91, FOR 1990 TRACTS (JGB) 00041005 (NOT YET EDITED FOR FRANKLIN & JEFFERSON)00050005 ARGUMENT: 7-CHAR. TRACT, E.G. "2151.02", "1011.00" 00060000 00070000 VALUE RETURNED: 4-CHAR TG CODE, A BLANK, TG NAME (MAX 32 CHAR. TOT) 00080000 00090000 SAMPLE ENTRY(S): "2101.00"-"2107.00"= 00100000 "2101 SPNSH LAKE-BELLFNTN-RIVERVW" 00110000 GEOGRAPHIC AREA COVERED: MO. PORTION ST LOUIS SMSA 00120000 00130000 SOURCE USED TO GENERATE: NONE (ENTERED MANUALLY) 00140000 ==> Strmsca.sas <== /* 00010000 NAME:$TRMSCA DESCRIPTION: TRACT TO MAJOR SUBCOUNTY AREA 00020000 00030000 PGMR: JGB DATE CREATED: 10-26-88 00040000 00050000 ARGUMENT: 7-CHAR. TRACT, E.G. "2151.02", "1011.00" 00060000 00070000 VALUE RETURNED: 5-CHAR MSCA CODE, A BLANK, AND MSCA NAME (32 CHARS) 00080000 00090000 SAMPLE ENTRY(S): "7010.00"-"7014.00"="SJEFF SOUTH JEFFERSON" 00100000 00110000 GEOGRAPHIC AREA COVERED: MO. PORTION ST LOUIS SMSA 00120000 00130000 SOURCE USED TO GENERATE: ENTERED MANUALLY USING $TRGRP AS MODEL 00140000 00150000 ==> Strname.sas <== /* NAME:$TRNAME DESCRIPTION: ASSIGN AREA NAME TO TRACTS PGMR: JGB DATE CREATED: REVISED TO INCLUDE BOTH 80 AND 90 CODES (MO SIDE ONLY), 8/91. SIGNIGIFICANT EDITING ST CHAS CO 9-11-91 Editing for mixed case, 1-98, jgb ARGUMENT: 1980/1990 CENSUS TRACT CODE (XXXX.XX) VALUE RETURNED: IN CITY, THE HEALTH DISTRICT NAME. ELSEWHERE, THE NAME OF CITY WITH MOST POPULATION IN COMMON. IF WORD "AREA" FOLLOWS IT MEANS IN UNINCORPORATED AREA NEAR THE CITY, E.G. "NEW MELLE AREA" (OUTSIDE CITY OF NEW MELLE). SAMPLE ENTRY(S): "1011.00"-"1018.00"="Carondelet" ==> Strpuma.sas <== PROC FORMAT DDNAME=SASLIB PRINT ; VALUE $TRPUMA '1011.00'='1SO' '1012.00'='1SO' '1013.00'='1SO' '1014.00'='1SO' '1015.00'='1SO' '1018.00','1018.99'='1SO' '1021.00'='1SO' '1022.00'='1SO' '1023.00'='1SO' '1024.00'='1SO' '1025.00'='1SO' '1031.00'='1SO' '1034.00'='1SO' ==> Strtra.sas <== /* NAME:$TRTRA DESCRIPTION: TRACT TO TRACT AREA CORRSPDNC PGMR: JGB DATE CREATED: 9/91 ARGUMENT: CENSUS TRACT (1980 AND/OR 1990) IN ST LOUIS METRO WEST VALUE RETURNED: 4-CHARACTER TRA MNEMONIC CODE SAMPLE ENTRY(S): '1011.00'='CARO' GEOGRAPHIC AREA COVERED: 5-COUNTY ST. LOUIS METRO-WEST SOURCE USED TO GENERATE: IN CITY WE USE HEALTH DISTRICTS (TRACT GROUPS). ELSEWHERE WE ASSIGNED THESE BASED ON EFFORTS TO ==> Strtra2k.sas <== /* GENERATED BY GENFMAT MACRO ON 10/27/2003 */ PROC FORMAT DDNAME=library ; VALUE $trtra2k '8001.00'='WASH' '8002.01'='WASH' '8002.02'='WASH' '8003.00'='WASH' '8004.01'='FARW' '8004.02'='FARW' '8005.00'='FARW' '8006.01'='UNPA' '8006.02'='UNPA' '8007.01'='UNPA' '8007.02'='UNPA' '8008.00'='UNPA' ==> Suauc2k.sas <== /* NAME:$uauc2k DESCRIPTION: Urbanized Area/Urban Cluster codes PGMR: jgb DATE CREATED: 05May2002 ARGUMENT: 5-chacter UA or Urban Cluster FIPS code VALUE RETURNED: Name of the UA or UC . For UA's ends with "(UA)" SAMPLE ENTRY(S): '00280'='Abilene, TX (UA)' SOURCE USED TO GENERATE: Code files downloaded from Census Bureau. See /pub/data/georef/ua2k.txt and uc2k.txt. Setup in georef/Tools where we also create sas dataset georef.uauc2k. ==> Suername.sas <== /* ************Not maintained any more: we use a value stmt to define this is the equivalent of $umxname. See the Sumxname.sas module. ************ NAME:$UERNAME DESCRIPTION: ASSOCIATES UNIVERSITY EXTENSION REGION NAMES WITH UER CODES PGMR: NMK DATE CREATED: 3/22/96 ARGUMENT: 3-DIGIT UER CODE (SEE $CNTYUER) ) VALUE RETURNED: NAME OF UNIVERSITY EXTENSION REGION SAMPLE ENTRY(S): '918'='EAST CENTRAL' ==> Sui_code.sas <== /* GENERATED BY GENFMAT MACRO ON 03/24/07 */ PROC FORMAT DDNAME=LIBRARY ; VALUE $ui_code '01'='Large-in a metro area with at least 1 million residents or more ' '02'='Small-in a metro area with fewer than 1 million residents ' '03'='Micropolitan adjacent to a large metro area ' '04'='Noncore adjacent to a large metro area ' '05'='Micropolitan adjacent to a small metro area ' '06'='Noncore adjacent to a small metro with town of at least 2,500 residents ' '07'='Noncore adjacent to a small metro and does not contain a town of at least 2,500 ' '08'='Micropolitan not adjacent to a metro area ' '09'='Noncore adjacent to micro area and contains a town of 2,500- 9,999 residents ' '10'='Noncore adjacent to micro area and does not contain a town of at least 2,500 res' '11'='Noncore not adjacent to a metro/micro area and contains a town of 2,500 or more ' '12'='Noncore not adjacent to a metro/micro area and does not contain a town of at lea' ==> Sumxname.sas <== /* NAME:$umxname DESCRIPTION: ASSOCIATES UNIVERSITY EXTENSION REGION NAMES WITH umx 2-char codes aka $uername PGMR: JGB DATE CREATED: 3/29/01 Replaces previous version that used numeric codes. ARGUMENT: 2-DIGIT umx CODE - takes upper of lower case. VALUE RETURNED: NAME OF UNIVERSITY EXTENSION REGION SAMPLE ENTRY(S): 'ec','EC'=East Central' GEOGRAPHIC AREA COVERED: MO. ==> Surbarea.sas <== /* NAME: $urbarea DESCRIPTION: U.S. Urbanized Area Codes (OLD!!!) <===== For current UA, Urban Cluster codes see Suauc2k.sas ======> PGMR: jgb DATE CREATED: 3-31-96 ARGUMENT: 4-digit U.A. code VALUE RETURNED: Name of Urbanized Area SAMPLE ENTRY(S): '0040'='Abilene, TX' '7040'='St. Louis, MO--IL' '9999'=' ' GEOGRAPHIC AREA COVERED: United States (incl. outlying) SOURCE USED TO GENERATE: 1990 GICS files (gics90.urbareas) ==> Suscenci.sas <== /* GENERATED BY GENFMAT MACRO ON 01/27/94 */ PROC FORMAT; VALUE $USCENCI '010060'='Anniston city ' '010175'='Bessemer city ' '010185'='Birmingham city ' '010480'='Decatur city (pt.) ' '010500'='Dothan city ' '010640'='Florence city ' '010685'='Gadsden city '