Hello everyone, I am struggling with a very simple problem but somehow I am not getting what I want to - to addition values in one column by creating another column, given several criteria. I add a little extract of the dataset, in a very simplified version, we have three columns - jour (date), investor(a number of ID), position(a number). I want to create another column named sumpos which would provide me with a sum of Position variable IF the investor is the same AND IF the date is the same - basically, daily positions. The pieces of code I have tried are the following: proc sql; create table ptf_funds as select investor, jour, SUM(Position) as sumPosition from funds_merged1 group by investor, jour; quit; but this code above does not add all the values - skips some of them and I did not manage to understand which and why. Another way I have tried is the following: data atrial_funds; set funds_merged1; if ((investor=investor) AND (jour=jour))then sum(Position)=sumPosition; else sumPosition=sumPosition; run; But I am not sure if this would work and I get an error saying that I did not define the sum as an array. If anyone could help me, this would be great!
... View more