SAS Reference Data Manager 3.3 features a HTML5 interface, where you can manage flexible hierarchies, domains and columns lists. It provides tools to download, import, access and export the data through a REST API. Read further about attributes multi-language support and how to import reference data from a flat file.
Let’s use a simple example to understand the multi-language support for attributes. For example, manage a list with country codes and labels in several languages.
Create the domain.
Select any image to see a larger version.
Mobile users: To view the images, select the "Full" version at the bottom of the page.
Choose the lookup domain attributes.
Choose several languages. The language refers to the chosen attribute.
You may want to display the attribute, Country name in several languages. Say you choose: English, French, Chinese, Dutch.
Create New items one by one:
Until you have the desired list. Versions are incremented when you save.
In a hierarchy, each Item has a Parent. For Item Country, you chose the Parent Continent.
Then, fill in the attribute Country, in each of the chosen language.
Save when done.
It is useful to see the data structure, in a file format. Download the reference data:
A csv file is generated:
"DOMAIN_NAME","DOMAIN_ID","VERSION_ID","VERSION","ITEM_ID","PARENT_ID","ITEM_KEY","ITEM_LABEL","COUNTRY_ZH","COUNTRY_NL","COUNTRY_EN","COUNTRY_FR"
"Countries","c6f9ba0e-3695-4c9a-ba89-d26f6c02170c","ab46e71d-6feb-4312-8238-57569255d719","16.0","24323f0c-a1de-4464-b51e-6766b0116240","eaa6232b-487b-48d7-86e2-6f9e73b87494","BE","Belgium","比利时","België","Belgium","Belgique"
"Countries","c6f9ba0e-3695-4c9a-ba89-d26f6c02170c","ab46e71d-6feb-4312-8238-57569255d719","16.0","4f739a02-292b-4db0-ba15-e332564cf89a","622f04cb-3953-4113-84ff-7d95635c09fa","US","United States","美国","Verenigde Staten van Amerika","United States of America (the)","États-Unis"
"Countries","c6f9ba0e-3695-4c9a-ba89-d26f6c02170c","ab46e71d-6feb-4312-8238-57569255d719","16.0","f7b32784-f6eb-47e9-abe2-feebff59a987",,"OC","Oceania",,,,
"Countries","c6f9ba0e-3695-4c9a-ba89-d26f6c02170c","ab46e71d-6feb-4312-8238-57569255d719","16.0","fab9a2a2-0acb-4109-bdb3-2e27f4d79cb4","f7b32784-f6eb-47e9-abe2-feebff59a987","AU","Australia","澳大利亚","Australië","Australia","Australie"
"Countries","c6f9ba0e-3695-4c9a-ba89-d26f6c02170c","ab46e71d-6feb-4312-8238-57569255d719","16.0","eaa6232b-487b-48d7-86e2-6f9e73b87494",,"EU","Europe",,,,
"Countries","c6f9ba0e-3695-4c9a-ba89-d26f6c02170c","ab46e71d-6feb-4312-8238-57569255d719","16.0","622f04cb-3953-4113-84ff-7d95635c09fa",,"NA","North America",,,,
You can import the items from a file. The import interface is described in the doc
You may want to add a new country in the list. Each item has a parent, if the parent does not exist, you must create it.
The file to be imported becomes:
"PARENT_KEY","ITEM_KEY","ITEM_LABEL","COUNTRY_ZH","COUNTRY_NL","COUNTRY_EN","COUNTRY_FR"
,"AS","Asia",,,,
"AS","CN","China","中国","China","China","Chine"
You can use the very friendly import interface.
A new version of the Hierarchy is created at import time. You can navigate through the attributes in different languages.
SAS Reference Data Manager 3.3 offers: ultra-flexible hierarchies, multi-language support, easy to use import interface, clear data model.
Thank you for your time reading this post. Please comment and share your experience with the SAS Reference Data Manager 3.3.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning and boost your career prospects.