Appending in cs pro

[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

[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.

[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

[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.

[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

[Ayebian]

sah kindly help explain to me the contents of that selcase command