Hello,   I am trying to create a waterfall graph in SAS showing annual revenues historically with a breakout of growth by source company by calendar year.  I want to create a graph that looks just like the one in the attached Word document which shows a breakout of growth going from 2017 to 2018 as shown with column totals as shown. Here is the correspong (example) data I used:   ID Co. A Co. B Co. C YoY Chg Rolling Total CY15       97.9    35.1    38.9                    171.9 CY16     102.0    43.2    44.6                    189.9 CY17     106.8    49.9    46.7                    203.4    Co. A: ROW     203.4             6.0                  209.4    Co. A:       US     209.4             5.5                  214.9    Co. A:  Dom     214.9             3.0                  217.9    Co. B:  Dom+Int     217.9             9.6                  227.5    Co. C:  Dom + Int     227.5             4.1                  231.6 CY18     121.3    59.5    50.8                    231.6     How do I replicate this Excel graph using SAS?  I spent hours trying to figure it out without luck.   Many thanks! Jack ... View more

Hello,   I am trying to create a SAS graph where I have 3 horizontal bar charts that use the same vertical axis (firm size by employee count) representing 3 groups (here I am looking at exports growth from Canada by firm size for three trade lanes: (1) to the US and rest-of-world, (2) to the US only and (3) to the ROW only as compiled from Statistics Canada data).   Here is the data:   firm_size_num_employees US_plus_ROW ROW_only US_Only 0 -28.1 45.2 11.0 1-9 19.4 -10.6 -39.0 10-49 65.4 -27.4 -18.8 50-99 -26.5 19.3 -19.3 100-249 18.9 -44.2 18.5 250-499 15.8 62.9 35.0 500+ 17.9 67.2 10.1 I attached the graph I want to create (I drew it by hand since I can't find what a compariable online).   How do I do this either using (a) SAS code or (b) in SAS EG via pulldown menus?   Any help appreciated.   Thanks Jack     ... View more

Hello,   I have a dataset that looks something like this:     Type Code Date Bankruptcy_Count 1 Sector 11 Apr-16 2 2 Sector 11 May-16 5 3 Sector 11 Jun-16 6 4 Sector 21 Apr-16 8 5 Sector 21 May-16 4 6 Sector 21 Jun-16 9 7 Sector 31 Apr-16 5 8 Sector 31 May-16 2 9 Sector 31 Jun-16 1     I want to create totals by month by inserting a new Type called "Total' with the code of 1.  I would like the end product to look something like this with Total being included in the Type heading and Bankruptcy_Count the sum of the monthly sector values 11+21+31:     Type Code Date Bankruptcy_Count 1 Total 1 Apr-16 15 2 Total 1 May-16 11 3 Total 1 Jun-16 16 4 Sector 11 Apr-16 2 5 Sector 11 May-16 5 6 Sector 11 Jun-16 6 7 Sector 21 Apr-16 8 8 Sector 21 May-16 4 9 Sector 21 Jun-16 9 10 Sector 31 Apr-16 5 11 Sector 31 May-16 2 12 Sector 31 Jun-16 1   What is the easiest way to code this in SAS.  Do I need to create a new dataset?   Thanks Jack ... View more