Skip Header
U.S. flag

An official website of the United States government

My Community Explorer is now available. Explore select demographic, business, and resilience data to help identify potentially underserved communities.

Analyzing Census Bureau Data in SAS Studio | A 6 Video Course

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

Course Outline

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

Description

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.

Coure Materials

Skill Level/Who Should Take This Course

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.

Jump to:

Introduction to Analyzing Census Bureau Data in SAS Studio

Video 1 of 6

Description

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.

Content Outline

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

Key Links

Completed the Video Series?

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

Access Census Bureau Data

Video 2 of 6

Description

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.

Content Outline

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

Key Links

Completed the Video Series?

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

Import Census Bureau Data into SAS Studio

Video 3 of 6

Description

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.

Content Outline

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

Completed the Video Series?

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

Visualize Census Bureau Data in SAS Studio

Video 4 of 6

Description

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.

Content Outline

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

Key Links

Completed the Video Series?

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

Prepare Census Bureau Data in SAS Studio

Video 5 of 6

Description

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.

Content Outline

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

Key Links

Completed the Video Series?

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

Analyze Census Bureau Data in SAS Studio

Video 6 of 6

Description

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.

Content Outline

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

Key Links

Completed the Video Series?

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

Congratulations! You Finished the Course!

Completed the Video Series?

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

Text to Copy When You Share:

I just finished the Analyzing Census Data in SAS Studio course. Be sure to check out their free resources! 

#CensusAcademy #SAS #DataScience #DataViz #DataAnalysis #Research #elearning

Top

Back to Header