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

Leveraging picklists for crosswalks

From the course: Data Curation Foundations

Start my 1-month free trial

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…

Contents