Value set name and value label from External file (Excel)
Posted: August 17th, 2018, 7:18 am
Hello Everyone!
Please, by the way, I have an Excel file that I would like to read with CSPro it is the data of the administrative division of my country in the attached excel file.
So I would like to make sure that when I choose a region, CSPro only displays the departments, subprefectures and villages of this region.
I know how to do this manually on CSPro with the function "setvalueset (variable_name, Value_set_name)", but this time the data is in a rather large Excel file and I think it's quite difficult to do it manually.
I will be very grateful to you forhelping me.
Thanks !
Please, by the way, I have an Excel file that I would like to read with CSPro it is the data of the administrative division of my country in the attached excel file.
So I would like to make sure that when I choose a region, CSPro only displays the departments, subprefectures and villages of this region.
I know how to do this manually on CSPro with the function "setvalueset (variable_name, Value_set_name)", but this time the data is in a rather large Excel file and I think it's quite difficult to do it manually.
I will be very grateful to you forhelping me.
Thanks !