Re: Identifying unique sets of combinations

Hi, Booth:

Yeah, I have been leaning toward the HLL solution myself, but don't like setting limits (110, 55) ... Even if they're 11000 and 5500 (which they cannot be, alas!).

I may end up with a hybrid between array/space and SQL, but your idea should work fine.
--
Sent from my Galaxy tablet phone with with K-9 Mail. Please excuse my brevity.

"Booth Martin" <booth@xxxxxxxxxxxx> wrote:

Would something like this work?

1-Define an array(ARAC) of 110 absence codes.
2-Define an array(ARCAT) of 55 categories with two fields:
a-ARAC and the
b-category code.

3- Do a Read Loop through the Category file, at each new category:
a-using a FOR loop, load ARAC(i) with the absence codes.
b-Sort ARAC.
c-load ARCAT(j) with ARAC and the current category code.

4-Once the Read Loop is completed sort ARCAT.

5-Print ARCAT.
6-Duplicates should be grouped together.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dennis
Sent: Friday, June 03, 2011 12:40 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Identifying unique sets of combinations

We have a table as part of our HR system that is used to categorize

days

off. For example, "S" (for sick) is in the SCKAC, USEDS, VACCK and

14 other

categories (I know, I know). V(acation) is in 7 categories, and so

on.

These things are categorized in such a way because they intersect so

much.

For example, a Carry-over vacation day and a Vacation day each have

the same

effect in terms of Vacation Balance, but very different effects when

it

comes to calculating next year's new balance.

In all, there are 110 absence codes that are grouped into 55

different

categories. In an effort to simplify all of this, I've been asked to
identify categories that share common members, with no exceptions.

(In

other words, if categories AAA, ABB and ACC all contain V and C, and

none of

them contain anything else, they are exact duplicates.)

By the same token, If V and G are in 5 categories, but a sixth

category

lacks G, the powers that be would like this noted also.

I'm sure there's a way to get to this answer and still maintain

what's left

of my sanity (many of you realize that there's little left), but I

have not

yet landed on it. I thought SQL might get me to the answer most

readily,

but try as I might I haven't found a workable solution yet; my CTEs

quickly

get too complex for me to follow. (See prior note on sanity.) Pivot

table

doesn't seem quite right (though it may help); counts are not

definitive

enough...

So I thought I'd come to this group; see if you've had a similar

situation,

and might be willing to share how you arrived at a solution.

Thanks!

--
Booth Martin
802-461-5349
http://www.martinvt.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.