PR PROC G C GMA MAP t P to visualiz visualize e 30 y 30 year - PowerPoint PPT Presentation

PR PROC G C GMA MAP t P to visualiz visualize e 30 y 30 year ears o s of US Census da f US Census data a DV DV10 Evian Fernandez Garcia Astellas Pharma Europe BV Leiden, The Netherlands

The Data • US Census Data. • Years: 1980, 1990, 2000 and 2010. • States: California, Nevada, Arizona, Utah, New Mexico, Colorado, Texas, Oklahoma, Kansas, Louisiana, Arkansas, Mississippi, Alabama, Georgia, Tennessee, North Carolina, South Carolina, Florida. • Race: Hispanic , White *, Black *, Other *. (* means non-Hispanic) • Origin of Hispanics: Mexican, Puerto Rican, Cuban, Other. • PopulaYon counts at State and County levels. • New Mexico, Oklahoma and South Carolina for 1980 are missing. • The county of Yuma was divided in two counYes a[er 1980.

72.2% - 54.6% 10.9% - 23.7% 14.1% - 13.5% 2.9% - 8.2%

U.S. Decennial Census. Hispanics(%) U.S. Decennial Census. Hispanics(%) U.S. Decennial Census. Hispanics(%) U.S. Decennial Census. Hispanics(%) year=2010 year=1990 year=1980 year=2000 26.5% 37.6% 29.7% 46.3% 37.6% 22.5% Hispanics(%) Hispanics(%) Hispanics(%) Hispanics(%) [0, 10) [0, 10) [0, 10) [0, 10) [10, 20) [10, 20) [10, 20) [10, 20) [20, 30) [20, 30) [20, 30) [20, 30) [30, 40) [30, 40) [30, 40) [30, 40) [40, 50) [40, 50) [40, 50) [40, 50) Majority, <50 Majority, <50 Majority, <50 Majority, <50

PROC GMAP DATA= stat3 MAP= mapssas.us; ID statecode; CHORO percc / LEVELS= 8 UNIFORM LEGEND= legend1; BY year; RUN ;

U.S. Decennial Census. Hispanics(%) U.S. Decennial Census. Hispanics(%) U.S. Decennial Census. Hispanics(%) U.S. Decennial Census. Hispanics(%) year=1980 year=2010 year=1990 year=2000 Hispanics(%) Hispanics(%) Hispanics(%) Hispanics(%) [0, 10) [0, 10) [0, 10) [0, 10) [10, 20) [10, 20) [10, 20) [10, 20) [20, 30) [20, 30) [20, 30) [20, 30) [30, 40) [30, 40) [30, 40) [30, 40) [40, 50) [40, 50) [40, 50) [40, 50) Majority, <50 Majority, <50 Majority, <50 Majority, <50 [50, 75) [50, 75) [50, 75) [50, 75) [75,100] [75,100] [75,100] [75,100]

California Nevada Arizona Florida New Texas Mexico

U.S. Decennial Census. Hispanics(%) U.S. Decennial Census. Hispanics(%) U.S. Decennial Census. Hispanics(%) U.S. Decennial Census. Hispanics(%) U.S. Decennial Census. Hispanics(%) U.S. Decennial Census. Hispanics(%) U.S. Decennial Census. Hispanics(%) U.S. Decennial Census. Hispanics(%) year=1990 orig=Mexican year=1980 orig=Mexican year=2000 orig=Mexican year=2010 orig=Mexican year=2000 orig=Puerto Rican year=2010 orig=Puerto Rican year=1990 orig=Puerto Rican year=1980 orig=Puerto Rican Hispanics(%) Hispanics(%) Hispanics(%) Hispanics(%) Hispanics(%) Hispanics(%) Hispanics(%) Hispanics(%) [0, 10) [0, 10) [0, 10) [0, 10) [10, 20) [10, 20) [10, 20) [10, 20) [20, 30) [20, 30) [20, 30) [20, 30) [30, 40) [30, 40) [30, 40) [30, 40) [0, 10) [0, 10) [0, 10) [0, 10) [10, 20) [10, 20) [10, 20) [10, 20) [20, 30) [20, 30) [20, 30) [20, 30) [30, 40) [30, 40) [30, 40) [30, 40) U.S. Decennial Census. Hispanics(%) U.S. Decennial Census. Hispanics(%) U.S. Decennial Census. Hispanics(%) U.S. Decennial Census. Hispanics(%) U.S. Decennial Census. Hispanics(%) U.S. Decennial Census. Hispanics(%) U.S. Decennial Census. Hispanics(%) U.S. Decennial Census. Hispanics(%) year=1990 orig=Cuban year=2000 orig=Cuban year=1980 orig=Cuban year=2010 orig=Cuban year=1980 orig=Other year=1990 orig=Other year=2010 orig=Other year=2000 orig=Other Hispanics(%) Hispanics(%) Hispanics(%) Hispanics(%) Hispanics(%) Hispanics(%) Hispanics(%) Hispanics(%) [0, 10) [0, 10) [0, 10) [0, 10) [10, 20) [10, 20) [10, 20) [10, 20) [20, 30) [20, 30) [20, 30) [20, 30) [30, 40) [30, 40) [30, 40) [30, 40) [0, 10) [0, 10) [0, 10) [0, 10) [10, 20) [10, 20) [10, 20) [10, 20) [20, 30) [20, 30) [20, 30) [20, 30) [30, 40) [30, 40) [30, 40) [30, 40)

U.S. Decennial Census. Hispanics(%) U.S. Decennial Census. Hispanics(%) U.S. Decennial Census. Hispanics(%) U.S. Decennial Census. Hispanics(%) U.S. Decennial Census. Hispanics(%) U.S. Decennial Census. Hispanics(%) U.S. Decennial Census. Hispanics(%) U.S. Decennial Census. Hispanics(%) year=2000 orig=Mexican year=1990 orig=Mexican year=1980 orig=Mexican year=2010 orig=Mexican year=2010 orig=Puerto Rican year=2000 orig=Puerto Rican year=1990 orig=Puerto Rican year=1980 orig=Puerto Rican Hispanics(%) Hispanics(%) Hispanics(%) Hispanics(%) Hispanics(%) Hispanics(%) Hispanics(%) Hispanics(%) [0, 10) [0, 10) [0, 10) [0, 10) [10, 20) [10, 20) [10, 20) [10, 20) [20, 30) [20, 30) [20, 30) [20, 30) [30, 40) [30, 40) [30, 40) [30, 40) [0, 10) [0, 10) [0, 10) [0, 10) [10, 20) [10, 20) [10, 20) [10, 20) [20, 30) [20, 30) [20, 30) [20, 30) [30, 40) [30, 40) [30, 40) [30, 40) [40, 50) [40, 50) [40, 50) [40, 50) Majority, <50 Majority, <50 Majority, <50 Majority, <50 [50, 75) [50, 75) [50, 75) [50, 75) [75,100] [75,100] [75,100] [75,100] [40, 50) [40, 50) [40, 50) [40, 50) Majority, <50 Majority, <50 Majority, <50 Majority, <50 [50, 75) [50, 75) [50, 75) [50, 75) [75,100] [75,100] [75,100] [75,100] U.S. Decennial Census. Hispanics(%) U.S. Decennial Census. Hispanics(%) U.S. Decennial Census. Hispanics(%) U.S. Decennial Census. Hispanics(%) U.S. Decennial Census. Hispanics(%) U.S. Decennial Census. Hispanics(%) U.S. Decennial Census. Hispanics(%) U.S. Decennial Census. Hispanics(%) year=1990 orig=Cuban year=2010 orig=Cuban year=1980 orig=Cuban year=2000 orig=Cuban year=1980 orig=Other year=2010 orig=Other year=2000 orig=Other year=1990 orig=Other Hispanics(%) Hispanics(%) Hispanics(%) Hispanics(%) Hispanics(%) Hispanics(%) Hispanics(%) Hispanics(%) [0, 10) [0, 10) [0, 10) [0, 10) [10, 20) [10, 20) [10, 20) [10, 20) [20, 30) [20, 30) [20, 30) [20, 30) [30, 40) [30, 40) [30, 40) [30, 40) [0, 10) [0, 10) [0, 10) [0, 10) [10, 20) [10, 20) [10, 20) [10, 20) [20, 30) [20, 30) [20, 30) [20, 30) [30, 40) [30, 40) [30, 40) [30, 40) [40, 50) [40, 50) [40, 50) [40, 50) Majority, <50 Majority, <50 Majority, <50 Majority, <50 [50, 75) [50, 75) [50, 75) [50, 75) [75,100] [75,100] [75,100] [75,100] [40, 50) [40, 50) [40, 50) [40, 50) Majority, <50 Majority, <50 Majority, <50 Majority, <50 [50, 75) [50, 75) [50, 75) [50, 75) [75,100] [75,100] [75,100] [75,100]

PROC GMAP DATA= stat5 MAP= outline2; ID state county; CHORO percc / LEVELS= 8 UNIFORM LEGEND= legend1 COUTLINE= GRAYF0; BY year orig; RUN ;

U.S. Decennial Census. Hispanics(%) U.S. Decennial Census. Hispanics(%) U.S. Decennial Census. Hispanics(%) year=2030 year=2010 year=2020 40.6% 42.0% Hispanics(%) Hispanics(%) Hispanics(%) [0, 10) [0, 10) [0, 10) [10, 20) [10, 20) [10, 20) [20, 30) [20, 30) [20, 30) [30, 40) [30, 40) [30, 40) [40, 50) Majority, <50 Majority, <50 [50, 75) [50, 75) Majority, <50

PROC MIXED DATA= stat2; CLASS race id state; MODEL count = race race*year / NOINT S; REPEATED / SUB= id; RANDOM int / SUB= id; RUN ;

U.S. Decennial Census. Race Pies by State(%) U.S. Decennial Census. Race Pies by State(%) U.S. Decennial Census. Race Pies by State(%) U.S. Decennial Census. Race Pies by State(%) year=1980 year=1990 year=2000 year=2010

DATA anno; FORMAT color $10.; /* Get the coordinates for the center of the state from the MAPS.USCENTER data set */ MERGE stat3(IN=a) maps.uscenter; BY state; IF a; /* X and Y coordinate system is set to data values */ xsys='2'; ysys='2'; /* Apply the annotation after the procedure output */ WHEN='a'; /* Draw a pie */ function='pie'; /* Color the slices for each race */ SELECT (race); PROC GMAP DATA= anno WHEN ( 1 ) color= 'black'; WHEN ( 2 ) color= 'red'; MAP= mapssas.us WHEN ( 3 ) color= 'darkgreen'; ID state; WHEN ( 4 ) color= 'darkblue'; OTHERWISE; CHORO state / nolegend annotate=anno END; coutline=black; /* Draw the portion of the pie */ BY year; rotate= 360 *perc/ 100 ; size= (round(log2(count_sum), 1 )- 19 )/ 2.2 ; RUN ; /* Use a solid pattern fill */ style='solid'; line= 0 ; RUN ;

Conclusions • Not possible (in an easy way) to merge two of more areas inside a geographical level, e.g. two counYes, and plot them as such. This can be done using PROC GREMOVE. • At county level, the SAS map mapssas.uscounty do not contain the names of the counYes and states, only the respecYve code numbers. • There are no opYons to combine different maps. This have to done through programming, modifying coordinates. • There are no opYons to plot different type of lines at different geographical levels, e.g., black outline for the US and grey outline for the States. This can be done using the ANNO opYon in CHORO. • There are no opYons to label geographical areas. This can be done using the ANNO opYon in CHORO. • This SAS procedure is not for the beginner programmer if we want to use several advance opYons.

REFERENCES hcps://www.census.gov/ hcps://support.sas.com/sassamples/graphgallery/PROC_GMAP.html CONTACT INFORMATION Evian Fernandez Garcia Astellas Pharma Europe BV evian.fernandezgarcia@astellas.com