From the course: Data Curation Foundations
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Leveraging picklists for crosswalks
From the course: Data Curation Foundations
Leveraging picklists for crosswalks
- [Announcer] Now that you are good with Picklists, in this video I am going to show you how to leverage a Picklist to serve as a crosswalk. To get you thinking about this concept, let's reflect on the HCUP data set we've been curating. My colleague and I wanted to study discharges from general hospitals. How we could do that is filter by this variable called SERV. Where SERV equals 10 we were dealing with general hospitals, as opposed to specialty hospitals. But, unfortunately, SERV was not in the discharge table, so at first we weren't sure what to do. As you can see, discharge has foreign keys to the hospital table, so I was hoping the HCUP hospital table had SERV in it, but it didn't. But it did have AHAID in it and that is a foreign key to the AHA Linkage File. So using AHAID, I was able to connect the hospital table to the AHA Linkage File and patch in the SERV variable. So, in this situation, the hospital table…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
Data dictionary basics5m 36s
-
(Locked)
Curating study vs. production data6m 5s
-
(Locked)
Entity-attribute-value (EAV) structure6m 8s
-
(Locked)
Indexes5m 18s
-
(Locked)
Entity-relationship diagrams (ERDs)5m 34s
-
(Locked)
Main tables in a data dictionary5m 17s
-
(Locked)
Picklists in a data dictionary5m 6s
-
(Locked)
Leveraging picklists for crosswalks5m 36s
-
(Locked)
Advanced crosswalks5m 29s
-
-
-
-
-
-
-