Hi,  can someone tell me why that  data new; do map = 1 to 7; output; end; char_map= put(map,4.); run; doesn't do what it should, namely to change from numeric to character/string? (need it to map with another column which is a string... ) Thanks! ... View more

Hi!  I have the following problem, I would like to sum up a column and divide the sum every line through the sum of the whole column till a specific value is reached. so in Pseudocode it would look like that: data; sum_of_whole_column = sum(column); subtotal[i] = 0; i =1; do until (subtotal[i] = 70000) subtotal[i] = (subtotal[i] + subtotal[i+1])/sum_of_whole_column i = i+1 end;   but I don't know if the Syntax is right, can I use that subtotal[i] to get the value in a specific cell? so I would like to run through an existing column...  Many thanks in advance! Best regards      Edit: I get the error that I haven't defined an array... so can I use something else instead of subtotal[i]? ... View more