Page 1 of 1

Creating value set

Posted: August 21st, 2026, 2:57 am
by Habtamu E
Dear Team,
How are you?
I have difficulty creating a value set from two different lookups. One is a single occurrence, and the second one is a multiple occurrence. If you have a solution, please let me know.
Thank you.

Re: Creating value set

Posted: August 24th, 2026, 7:31 am
by Gregory Martin
You posted an application here: https://www.csprousers.org/forum/viewtopic.php?t=6603

However, you did not give a description of the problem that you are facing. You have this code:
PROC FARMID_K

preproc

    numeric
c;
    ValueSet FarmK_vs;

    do varying c=1 until  c > totocc(WOREDA_DICT.WOREDA_REC);

        forcase WOREDA_DICT where  FRAME_LOGIN_WOREDA=FRAME_LOGIN_KEBELE  do
           
FarmK_vs.add(FRM02_W(c), FARMID_W(c));
        enddo;

    enddo;
But you do not assign the value set to a field like this:
    setvalueset(FARMID_K, FarmK_vs);
Can you give more details about what you are trying to do?

Re: Creating value set

Posted: August 30th, 2026, 4:55 am
by Habtamu E
Thank you Gregory