This may not fit your idea of "quick" or "efficient" but it is tried and true and relatively easy to understand.  Old style coding:   data almost_there; set have; random_order = ranuni(12345); run;   proc sort data=almost_there; by random_order; run;   data want; set almost_there; random_number = _n_; drop random_order; run;   Assign a random fraction to each observation.  Then just number the observations in order. ... View more

I would use the SQL aggregation function SUM() first and then deal with the missing values.     coalesce(sum(var_d),0)   Note that IFNULL() is not a valid SAS function.   ... View more

Replace 'Paid Search)'  --> 'Paid Search') ... View more

I believe this is the way I need to do it. Had to create a mid-man variable between initial and adjusted variables. However It's saying my alphabetical variables A - L are uninitialized. I would assume they would be available for use as I'm defining them before they are used down stream in subsequent calculations....weird. DATA Adjusted_Points; Set Actual_Points; /* -=Existing Point Variables=- Points_Feb Points_Mar Points_Apr Points_May Points_Jun Points_Jul Points_Aug Points_Sep Points_Oct Points_Nov Points_Dec Points_Jan; */ /* January  */ IF Points_Jan <0 THEN Jan2 = 0 AND B = SUM(Points_Jan,Points_Dec); ELSE IF Points_Jan >= 0 THEN Jan2 = Points_Jan AND B = Points_Dec; /* December  */ IF B <0 THEN Dec2 = 0 AND C = SUM(B,Points_Nov); ELSE IF B >= 0 THEN Dec2 = Points_Dec AND C = Points_Nov; /* November  */ IF C <0 THEN Nov2 = 0 AND D = SUM(C,Points_Oct); ELSE IF C >= 0 THEN Nov2 = Points_Nov AND D = Points_Oct; /* October  */ IF D <0 THEN Oct2 = 0 AND E = SUM(D,Points_Sep); ELSE IF D >= 0 THEN Oct2 = Points_Oct AND E = Points_Sep; /* September  */ IF E <0 THEN Sep2 = 0 AND F = SUM(E,Points_Aug); ELSE IF E >= 0 THEN Sep2 = Points_Sep AND F = Points_Aug; /* August  */ IF F <0 THEN Aug2 = 0 AND G = SUM(F,Points_Jul); ELSE IF F >= 0 THEN Aug2 = Points_Aug AND G = Points_Jul; /* July  */ IF G <0 THEN Jul2 = 0 AND H = SUM(G,Points_Jun); ELSE IF G >= 0 THEN Jul2 = Points_Jul AND H = Points_Jun; /* June  */ IF H <0 THEN Jun2 = 0 AND I = SUM(H,Points_May); ELSE IF H >= 0 THEN Jun2 = Points_Jun AND I = Points_May; /* May  */ IF I <0 THEN May2 = 0 AND J = SUM(I,Points_Apr); ELSE IF I >= 0 THEN May2 = Points_May AND J = Points_Apr; /* Apr  */ IF J <0 THEN Apr2 = 0 AND K = SUM(J,Points_Mar); ELSE IF J >= 0 THEN Apr2 = Points_Apr AND K = Points_Mar; /* Mar  */ IF K <0 THEN Mar2 = 0 AND L = SUM(K,Points_Feb); ELSE IF K >= 0 THEN Mar2 = Points_Mar AND L = Points_Feb; /* Feb  */ IF L <0 THEN Feb2 = 0; ELSE IF L >= 0 THEN Feb2 = Points_Feb; RUN; ... View more