02-01-2017 05:26 AM
I'm quite new to SAS and I'm trying to perfrom a sumif function on a data set in DI, but I cant find an equivalent procedure / code that would help me with this. I have the data set below.
|Bucket A||Bucket B||Value|
I want to add a column to sum the values >= Bucket A, but also to exclude the values of the previous row, so I've used a SUMIF with reative referencing. For example, the fourmula in cel D2 is, =SUMIF(A2:A10,">="&A2,C2:C10) = 48.
|Bucket A||Bucket B||Value||sumif (>=A)|
Is there a way to recreate this in SAS and DI?
02-01-2017 07:11 AM
I can understand you might have problems grasping DI if you use Excel as a reference.
DI Studio is used for standardised ETL, where the target are detail data layers, data marts and similar.
But your requirement doesn't look like a generic table structure, feels like a report to me. Or what is the application? Sorry, I can't the logic/use of the caclulated column. Please elaborate about the data flow and use.
Perhaps this is better suited for a report tool, like a stored process.
If you need to perform this in DI, my gut feeling is that you need some kind of user written code.