NLM Value Set Authority Center (VSAC) Value Set Authoring.
Exporting Value Set Data.
You might find it useful to save your value set data locally.
Therefore, the VSAC’s value set authoring interface
provides an ‘Export Value Set Details (Excel)’ link
right above the value set’s metadata section.
The link will NOT be visible if the value set is currently open for editing.
You will therefore need to save the value set by clicking the Save button to be able to export its data.
When you click on the Export link, all the value set data, including the list of codes, code metadata,
and the value set’s metadata, will export to a Microsoft Excel file.
You can open or save the file following the options presented by your browser.
The workbook, when opened in Excel, will consist of several spreadsheets.
The first spreadsheet, or tab, is called ‘Value Set Info’. It contains value set’s metadata.
The second tab is ‘Code List’.
It contains all codes and code metadata, as well as the information about the code system
used to define this value set (LOINC 2.40 in this example).
The next tab is ‘Expansion List’.
It consists of the value set’s code list as it is expanded against
the profile named “VSAC Auto Expansion”.
This profile is defined in the last tab called ‘Expansion Profile Detail’.
The tab lists all code system versions that are included in the expansion profile.
The ‘VSAC Auto Expansion’ profile by definition contains the list of latest versions of
the code systems loaded into the VSAC.
In our example, the LOINC version 2.50 is the latest version of LOINC represented
in the VSAC at the time of this recording.
Hence, the ‘Expansion List’ tab contains the results of the expansion
against LOINC version 2.50 of the value set’s
code list that was defined by the value set’s author using version 2.40 of LOINC.
As one may expect, some codes that were active in LOINC 2.40
became inactive in LOINC 2.50.
Inactive codes are listed as having status ‘Inactive’ accordingly.
The next tab called ‘Remap Code Info’ contains the list of those active or inactive codes in the value set
that can be replaced by (or mapped to) other codes.
This information is derived from the code system’s source data.
Each row will contain a pair of such code mappings.
If a code can be mapped to more than one code,
there will be accordingly more than one row for that code.
You can use the downloaded Excel file to make offline edits to your value set or to share the file with your collaborators.
If you make any changes to the code list in the file,
you will then need to update your value set in the VSAC
using the procedure described in our separate tutorial.
This concludes our tutorial.
Back on the VSAC home page, you can read more about the VSAC and value set authoring
by reviewing the information on the VSAC Support Center pages.
Click on the Help link at the VSAC home page to access those pages.
You can also send us your questions by following the Contact Us link.
Thank you for watching!