Hey, I figured it out. I just added a new variable  just like sum to calculate to the sum of the rows/columns. It worked. thanks for helping though. ... View more

Hey Ksharp, I wanted calculate the weighted gdp of other countries to find the market potential now. So my original sample Sample Data: ( The col1-49 show the distance between the two countries and is symmetric) Country     GDP         Col1      Col2     Col3.............Col49 Germany      5             0          3           1                  2 France         4              3           0          2                 1 Belgium        1              1         2           0                  1 Now to calculate the market potential for Germany, I need: MktPot = [(France GDP * France Distance from Germany) + (Belgium GDP * Belgium distance from Germany)] / (Sum of the distances)                                                                        In this sample data, MktPot Germany = [ (4*3) + (1*1) ] / (3+1) Can you please help me on how to go about that. I was a bit confused on calculating the row sum as desired. Thanks much again. You're a savior. ... View more

It worked Thank you much!! I really appreciate it. ... View more

Hey, Sorry I didn't realize that uppercase/lowercase mattered in Hash table. The program ran after that. Thank you. But ran into another problem. Most of the distances are 0 because they are two far away from each other, so while calculating the sum, many will be divided by 0, and hte program will give an error. Is there a way to correct it? Sorry, I don't use SAS much, and you've been tremendous help. Thanks again. ... View more

Hey Ksharp, I have 49 countries, and there are col1-col49 in the dataset with the same variable name. When i did rc=ha.find(), the program runs, but the sum is zero. if i just do ha.find(), it says ERROR: Key not found. Can't seem to figure out the problem. Been trying for a while now. Thanks for your help. I appreciate it. ... View more

Hey, A bit confused here. Thanks for your help in advance. This is what I have. Col1-49 is a symmetric 49*49 matrix and they represent distance from one another. Country     GDP         Col1      Col2     Col3.............Col49 Germany      5             0          3           1                  2 France         4              3           0          2                 1 Belgium        1              1         2           0                  1 So basically Market potential for Germany = (GDP of france)/Distance between germany and france (3 in this case)  + (GDP of Belgium)/(Distance between Ger and Bel (1 in this case). So I got a help from Ksharp here, but it says ERROR: Key not found. data have; set have; k=cats('Col',_n_); run; data want; if _n_ eq 1 then do;   if 0 then set have(keep=k rgdpinmi rename=(rgdpinmi=_gdp));   declare hash ha(dataset:'have(keep=k rgdpinmi rename=(rgdpinmi=_gdp))');    ha.definekey('k');    ha.definedata('_gdp');    ha.definedone(); end; set have; array x{*} col: ; sum=0; do i=1 to dim(x); if _n_ ne i then do;                    k=vname(x{i});                    ha.find();                      sum + _gdp/x{i};                       end; end; run; Can you help me solve the problem please? Thanks for your help. (The program worked when there were just 3 dataset (3*3 matrix), but doesn't work with my dataset 49*49 matrix. I realize it has to do with ha.find(), but couldn't figure out a way to solve it. Thanks. ... View more

Hey Ksharp, I was trying to do what you did. But I ran into a problem. When i run it, it says ERROR: KEY NOT FOUND And I realize its for ha.find() command. But i'm not sure how to fix the problem. i tried doing something random like rc=ha.(find) but don't know how to correct the program. Appreciate your help once again. ... View more

Ksharp, You're the man!!! Thank you. The sum gives exactly what I want. Although I don't understand much of what you did. But I'll try and look it up. thanks. ... View more

I figured it out, thank you. ... View more

Hey Linlin, appreciate your help. I tried to use the same thing to create a second lag/two lag , i.e. lag2(liquidity), but seems like it doesn't work for that. Could you please tell me how to go about that. thank you. I really do appreciate the help. Thanks. ... View more