Check on items belonging to different rosters

Discussions about editing and cleaning data
Forum rules
New release: CSPro 8.0
Post Reply
Tsheringcee
Posts: 12
Joined: July 4th, 2017, 4:21 am

Check on items belonging to different rosters

Post by Tsheringcee »

Dear all

Thnk you so much for the prompt response .it really helps me. I want to know how can we check if the values on two items are equal to individual persons in two different roster. For example I want to put a check where the marital status (m1)should not be 3 if the numbers of times married (m33) in a different roster for the same person is 2. M1 is in the first roster and m33 is the third roster.

Thank you
Gregory Martin
Posts: 1777
Joined: December 5th, 2011, 11:27 pm
Location: Washington, DC

Re: Check on items belonging to different rosters

Post by Gregory Martin »

If the row number of the people on both rosters are is same, you can write code like this:
PROC M33

    if M33 = 2 and M1(curocc()) = 3 then
        errmsg("...");
        reenter;
    endif;
Tsheringcee
Posts: 12
Joined: July 4th, 2017, 4:21 am

Re: Check on items belonging to different rosters

Post by Tsheringcee »

Thank u so much
Post Reply