Page 1 of 1
Appending in cs pro
Posted: July 15th, 2017, 11:08 am
by Ayebian
Helo forum is there a way i can append the ISIC ( United Nations International Standard Industrial Classification)
Codes into cs pro dictionary values as a valueset
Re: Appending in cs pro
Posted: July 15th, 2017, 5:53 pm
by sah
Yes, you can, in several ways thus either as valueset in the dictionary which depends on the way you organize it. or external file using the functions such as selCase Kindly check
.\CSPro\Examples 7.0\1 - Data Entry\Set Value
for selcase
Code: Select all
OK = selcase(OCCUPATION_DICT, "")
include(OCCUPATION_CODE, OCCUPATION_SUMMARY_LEVEL)
where OCCUPATION_CODE >= misvalue and OCCUPATION_CODE <= maxValue;
This function will pop out the codes for you to select.
Re: Appending in cs pro
Posted: July 16th, 2017, 12:33 am
by Ayebian
I have the codes list as excel file help me with the whole steps to append them in dictionary as value set under item "employment".thank you
Re: Appending in cs pro
Posted: July 16th, 2017, 12:31 pm
by Gregory Martin
If your Excel data is in the format:
Column 1: Label
Column 2: Value
You can copy it and paste it into the CSPro value set editor. That will create a value set from the Excel data.
Re: Appending in cs pro
Posted: July 18th, 2017, 4:36 pm
by sah
Kindly format it as Josh have instructed and let it look like what is in the picture. then you can paste it in the dictionary
Re: Appending in cs pro
Posted: July 25th, 2017, 3:06 am
by Ayebian
sah kindly help explain to me the contents of that selcase command