Learn how to access, import, visualize, prepare, and analyze U.S. Census Bureau data in SAS Studio.

• Introduction to Analyzing Census Bureau Data in SAS Studio | Video 1 of 6 | 9:30 minutes
• Access Census Bureau Data | Video 2 of 6 | 12:25 minutes
• Import Census Bureau Data into SAS Studio | Video 3 of 6 | 13:41 minutes
• Visualize Census Bureau Data in SAS Studio | Video 4 of 6 | 17:19 minutes
• Prepare Census Bureau Data in SAS Studio | Video 5 of 6 | 16:45 minutes
• Analyze Census Bureau Data in SAS Studio | Video 6 of 6 | 20:40 minutes

In this course series, learn how to access, import, visualize, prepare, and analyze U.S. Census Bureau data in SAS Studio. SAS studio lets you generate code, use predefined tasks or build custom tasks to access, join, filter, sort, prepare and analyze data. Once you access and import Census Bureau data into SAS Studio, you can access data files, tables and libraries from a single, customizable interface.

Note: To follow along with the tutorial series videos and access practice exercises and answers, you must download the Course Tutorial Notes, Instructions, and Practice Exercises document from the course materials and set up your SAS Studio environment. If you have access to SAS Studio, skip to the Setting Up the Tutorial Data section of the first video. If you do not have access to SAS Studio or do not have the necessary licenses, start at the Accessing SAS Studio Using ASA OnDemand for Academics section of the first video to learn how to access to SAS Studio for free. If you are unsure if you have access to the necessary licenses, you can determine this with a step-by-step guide on page four of the Course Tutorial Notes, Instructions, and Practice Exercises document in the Course Materials.

Level: Beginner to Advanced

This course is appropriate for those who those who are new or experienced with Census Bureau data and those who would like to learn how to advance their data analysis and data visualization skills.

Part 1 | Part 2 | Part 3 | Part 4 | Part 5 | Part 6 | Certificate

This video shows you the steps and preparations you will need to make to get started analyzing Census Bureau data in SAS Studio. In this video, SAS Technical Trainer Luna Bozeman introduces you to the tutorial series and shows you how to access SAS Studio for free by using SAS OnDemand for Academics. Luna also guides you through setting up the tutorial data so you can follow along with her or practice on your own.

0:00:00 – Welcome
0:10:00 – About this series
0:02:12 – Access SAS Studio using a SAS OnDemand for Academics account
0:03:30 – Setting up the tutorial data
0:08:32 – About the tutorial notes

How to follow along and practice on your own

• Create a free SAS OnDemand for Academics account to access SAS Studio
• Download the practice data setup program and tutorial notes that include practice exercises
• Course Tutorial Notes, Instructions, and Practice Exercises

Learn more about the American Community Survey

Understanding and Using American Community Survey Data

Share your accomplishment on your social media by downloading this certificate or badge!

What types of data does the Census Bureau make available and how can you use it? In this video, SAS Technical Trainer Luna Bozeman shows you how to access and download Census Bureau data from the American Community Survey in data.census.gov and then prepare it for import to SAS Studio.

0:00:00 – Welcome
0:00:30 – Accessing data from data.census.gov
0:04:57 – Filtering the data
0:06:04 – Downloading and exploring the data
0:08:05 – Formatting the data in Microsoft Excel
00:11:55 – Summary and next steps

data.census.gov

Share your accomplishment on your social media by downloading this certificate or badge!

In this video, SAS Technical Trainer Luna Bozeman shows you how to use the Import Data utility to import Census Bureau data into SAS Studio. You will then learn how to select criteria to modify what data is displayed. As an example, in this video, we demonstrate how to filter the table to show the states that have a median home value greater than or equal to the national median home value.

0:00:00 – Welcome
0:00:37 – Overview of SAS Studio
0:01:30 – Uploading the Excel file to a SAS server
0:02:36 – Importing the data
0:05:38 – Exploring the data
0:07:24 – Modifying the view of the table
0:13:11 – Summary and next steps

Share your accomplishment on your social media by downloading this certificate or badge!

Follow along with SAS Technical Trainer Luna Bozeman as she shows you how to use the Bar Chart task in SAS Studio to compare median home values across states. Then learn how to edit the code generated by the task to further enhance and organize the bar chart results. Last, learn how to share your chart.

0:00:00 – Welcome
0:01:23 – Using the Bar Chart task
0:04:08 – Modifying the chart’s appearance
0:06:46 – Adding a reference line
0:08:45 – Filtering the data
0:10:50 – Modifying the SAS code generated by the task
0:15:24 – Exploring result formats
0:16:47 – Summary and next steps

• data.census.gov

Share your accomplishment on your social media by downloading this certificate or badge!

Learn to prepare Census Bureau data for visualization and analysis using SAS Studio. SAS Technical Trainer Luna Bozeman shows you how to use a Query utility to join two tables together. You will see how to combine median household income data with a geography lookup table, use a Rank Data task to rank the median household income values within each region, use a List Data task to create a report that displays the top five states by median household income within each Census Bureau geographic region.

0:00:00 – Welcome
0:01:11 – Exploring the data
0:03:20 – Using the Query utility to combine tables
0:08:46 – Using the Rank Data task
0:11:36 – Using the List Data task
0:16:45 – Summary and next steps

• Data.census.gov - Table B19013 (2018 1-year ACS State Level Geography)
• 2018 Geography Look Up Table (Region and Division Codes and FIPS Codes for States)
• Map of Census Regions and Divisions of the United States

Share your accomplishment on your social media by downloading this certificate or badge!

Learn how to analyze Census data using some of the statistical tasks available in SAS Studio. SAS Technical Trainer Luna Bozeman shows you how you how to use the Distribution Analysis task to examine the distribution of median household income values in each region. Then learn how to use One-Way ANOVA task to determine if there is a significant relationship between median household income values and region. Finally, you'll see the Correlation Analysis task to examine the relationship between median household income values and other statistics, like mean hours worked per week and median monthly housing costs.

0:00:00 – Welcome
0:01:31 – Exploring the data
0:03:08 – Using the Distribution Analysis task
0:06:40 – Using One-Way ANOVA task
0:12:38 – Using the Correlation Analysis task
0:19:52 – Summary and next steps

Follow along with Luna and practice on your own.

Share your accomplishment on your social media by downloading this certificate or badge!

Share your accomplishment on your social media by downloading this certificate or badge!