Hi, Hopefully somebody may be able to give me a steer as I’m fairly new to base SAS. I’m preparing a dataset for import to VA (version 7.3).I have the following dataset following a transpose procedure. I am trying to construct a cumulative total for each product by its stage (A,R and U), its status, area and town. I had thought of using by variables in a data step would be the way forward but I have not been able to get it to work. Does anybody have any suggestions please? Dayno Product Status Area Town Stage A StageR StageU Daily_Tot 0 DGSEPCHI E HWB NMSW 2 2 . 4 0 DGSEPCHI H HWB NMSW 23 18 4 45 0 DGSEPCHI O HWB APS 2 2 . 4 0 DGLW4 H SASS CJC 4 5 5 14 12 DGSEPCHI H HWB NMSW . . . 0 27 DGLW4 H SASS CJC 1 4 . 5 39 DGLW4 H SASS CJC . . . 0 40 DGLW4 H SASS CJC 1 6 2 9 41 DGLW4 H SASS CJC . . 6 6 43 DGLW4 H SASS CJC 1 . . 1 47 DGLW4 H SASS CJC . . . 0 48 DGSEPCHI H HWB APS 1 . . 1
... View more