@Reeza Hmm it runs without errors or warnings but still doesn't seem to be working, not removing those strings. The only thing it removes is the punctuation. In the output it shows the value of i as 7 all the way down, like it's stuck on one iteration outside the dimensions of the array. There is an info message in the log, not sure if it's relevant: Character variables have defaulted to a length of 200 at the places given by: (Line):(Column). Truncation can result. That is for company_name.   this is the current code:   data test; set CompanyListing; array rmve_strs(6) $ _temporary_ ('LTD','LLC','INC','CORPORATION','COMPANY','LP'); do i=1 to dim(rmve_strs); company_name = tranwrd(strip(compress(CompanyName, ,"p")), rmve_strs(i), ''); end; run; ... View more

Hi @Reeza , when I try this on my data, I get this error (the structure is the same as yours)   array rmve_strs(*) _temporary_ $ ('LTD','LLC','INC','CORPORATION','COMPANY','LP'); _ 22 200 ERROR: The non-variable based array rmve_strs has been defined with zero elements. ERROR 22-322: Syntax error, expecting one of the following: (, ;. ERROR 200-322: The symbol is not recognized and will be ignored.         ... View more

@Reeza Yup that is exactly what I'm looking for. Sorry about the 667 number. It was an example I was messing around with where the total current_cost was $663.00 and Target was 74.00. I got the numbers mixed up. Thank you both for your help! Much appreciated. ... View more

@Astounding Okay, I think I see what you're doing here. However, what I want is ONE value for factor that applies to all observations to add up to a total that is as close as we can get to the value we get by calculating Total of Prices*(1-Percent), which in this case is $663.00 In my example I ended up with 1.11 to get closest to that total. The top loop is perfect. But factor should be a constant.   MAC_Price*Quantity*Factor = $1.33*30*1.11 = $44.40 MAC_Price*Quantity*Factor = $3.33*30*1.11 = $111.00 MAC_Price*Quantity*Factor = $0.83*30*1.11 = $27.75 MAC_Price*Quantity*Factor = $1.17*30*1.11 = $38.85 MAC_Price*Quantity*Factor = $0.83*30*1.11 = $27.75 MAC_Price*Quantity*Factor = $0.05*30*1.11 = $1.67 MAC_Price*Quantity*Factor = $3.33*30*1.11 = $111.00 MAC_Price*Quantity*Factor = $0.83*30*1.11 = $27.75 MAC_Price*Quantity*Factor = $1.83*30*1.11 = $61.05 MAC_Price*Quantity*Factor = $6.50*30*1.11 = $216.45                                                                Total = $667.67 (which is as close we can get with precison of 2 decimal places)   The output for what you had looks like this (with different factors). factors are in the first column       ... View more

Okay, so here is the situation. Here's the sample data. I goofed up on explaining this before.     data have; infile datalines; format Price dollar7.2 Current_Cost dollar7.2 Target percent8.2 MAC_Price dollar7.2 Quantity 2.; input Price Current_Cost Target MAC_Price Quantity; datalines; 100 40 .7641 1.33 30 300 100 .7641 3.33 30 325 25 .7641 0.83 30 400 35 .7641 1.17 30 100 25 .7641 0.83 30 150 1.50 .7641 0.05 30 350 100 .7641 3.33 30 425 25 .7641 0.83 30 175 55 .7641 1.83 30 225 195 .7641 6.50 30 ;; run;   And this is what I want to see:   data want; infile datalines; format Price dollar7.2 Current_Cost dollar7.2 Target percent8.2 MAC_Price dollar7.2 Quantity 2. Factor 3.2; input Price Current_Cost Target MAC_Price Quantity Factor; datalines; 100 40 .7641 1.33 30 1.11 300 100 .7641 3.33 30 1.11 325 25 .7641 0.83 30 1.11 400 35 .7641 1.17 30 1.11 100 25 .7641 0.83 30 1.11 150 1.50 .7641 0.05 30 1.11 350 100 .7641 3.33 30 1.11 425 25 .7641 0.83 30 1.11 175 55 .7641 1.83 30 1.11 225 195 .7641 6.50 30 1.11 ;; run;   The total of the Prices multiplied by (1-Target) gives us the value we want to get closest to by totalling the values we would get by multiplying MAC_Price*Quantity*Factor for each observation. So for this example:   Total of Prices = $2550.00   -> 2550*(1-76.41%) = 601.50 value we want to match with the value we get from totalling the values from this calculation:   -> MAC_Price*Quantity*Factor  . But the tricky thing is solving for Factor. The way I did        this one was just by plugging in values in excel and came to the closest value of $667.67 by using factor of 1.11. I didn't want to go        past the second decimal place. 601.50 is also rounded I believe, should be 601.54     I hope this is making sense, sorry to confuse you guys before.           ... View more

@Reeza @Astounding Well it turns out this is actually more complex then I thought. I am given just one Target percentage. I have to add up the total for Price, then calculate a single factor to multiply each Current_Cost by to add up to a new cost that would be the target discounted off of the total Price. ... View more