About HSARAI

HSARAI · ‎03-03-2014

kaushal2040, I can answer that since I encountered it myself. The purpose for using the if _n_=1 flag is so that the hash object is only defined once. If the flag is not used, then the hash object is re-declared for every row of the dataset, which is unnecessary.

HSARAI · ‎03-03-2014

There were many different options proposed but I feel that the hash solution is the most flexible, though perhaps not the most efficient. Thank you everyone for your help!

HSARAI · ‎02-28-2014

I'm sure there are a lot of options since I can't imagine this being uncommon. I just need to try understand your proposed solution with my minimal experience of the SAS language, but I'm hoping I can let you know soon if I worked something out.

HSARAI · ‎02-28-2014

I considered a transpose solution too, but the problem is that the indicator variable isn't always the same name as the lookup table. So there could be some values where the column name is ValueABC and I would do a translation to look up the value where the Value is 'XYZ' in the lookup table. I should have specified this, but even though a transpose solution would work with the example I provided it wouldn't unfortunately work for the actual problem I am trying to solve.

HSARAI · ‎02-28-2014

For the first row, just the value of Value1 is equal to 1. Therefore you look up the rows in the lookup table where Value=1, whose value of the Result column is 5. For the second row, the value of Value2 and Value3 are equal to 1. Therefore you look up the rows in the lookup table where Value=2 and Value=3 and add the values of the Result column for those rows which are 18 and 2, sum is 20. For the third row, the value of Value3 and Value4 are equal to 1. Therefore you look up the rows in the lookup table where Value=3 and Value=4 and add the values of the Result column for those rows which are 2 and 1, sum is 3. And so on...

HSARAI · ‎02-28-2014

the lookup table has the same number of rows as the indicator variables, so 200+ rows.

HSARAI · ‎02-28-2014

No. In reality there are 200+ indicator variables with close to a million rows.

HSARAI · ‎02-28-2014

Hello there, I've got a question I've yet to find an answer to. Let's say I have a table with columns containing a 1 or 0, something like this: Value1 Value2 Value3 Value4 1 0 0 0 0 1 1 0 0 0 1 1 1 0 1 0 1 1 1 1 And another table that contains lookup values: Value Return 1 5 2 18 3 2 4 1 What I want to do is add a field which is the sum of the associated value in the lookup table if the indicator is a 1. So something like this: Value1 Value2 Value3 Value4 Total 1 0 0 0 5 0 1 1 0 20 0 0 1 1 3 1 0 1 0 7 1 1 1 1 26 Thanks in advance

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: Lookup rows in a different table based on column values

Re: Lookup rows in a different table based on column values

Re: Lookup rows in a different table based on column values

Re: Lookup rows in a different table based on column values

Re: Lookup rows in a different table based on column values

Re: Lookup rows in a different table based on column values

Re: Lookup rows in a different table based on column values

Lookup rows in a different table based on column values

Re: Lookup rows in a different table based on column values

Re: Lookup rows in a different table based on column values

Re: Lookup rows in a different table based on column values

Re: Lookup rows in a different table based on column values

Re: Lookup rows in a different table based on column values

Re: Lookup rows in a different table based on column values

Re: Lookup rows in a different table based on column values

Re: Lookup rows in a different table based on column values

Lookup rows in a different table based on column values