After documenting picklists, it is possible to leverage their natural order for higher-level classifications. This video shows how to use them to design grouping variables.
- [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 … acted kind of like a Picklist. …
- How curation files function as part of data management
- Back-end curation
- Front-end curation
- Steps for dashboard design
- Designing surveys
- Creating warehouse, analytic, and application flow diagrams
- Text-based curation files
Skill Level Intermediate
1. Introduction to Data Curation
2. Back-End Curation
3. Front-End Curation
4. Special Curation for Surveys
5. Flow Diagrams
6. Text-Based Curation Files
7. Application in the Field
Next steps7m 1s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.