Hello,
I am new to tabulate reporting need help with a report that I am trying to build. Below is my sample data.
data test; input date : mmddyy10. product $ value ; format date mmddyy10.; cards; 3/17/2019 CLE 3785 3/18/2019 CLE 2245 3/19/2019 CLE 1125 3/20/2019 CLE 24589 3/21/2019 CLE 0 3/18/2019 DAG 5200 3/24/2019 DAG 4700 3/25/2019 DAG 3345 3/26/2019 DAG 3800 3/17/2019 DAG 111 3/18/2019 AGR 333 3/19/2019 AGR 2 3/20/2019 AGR 15 3/21/2019 AGR 0 3/24/2019 KML 1245 3/25/2019 KML 7789 3/26/2019 KML 6189 3/27/2019 KML 6030 3/28/2019 AGR 62 ; run;
I need my output in tabular form as below. The numbers should be centered and comma formatted.
Date
Product Volume
CLE
DAG
AGR
KML
3/17/2019
3,785
111
-
-
3/18/2019
2,245
5,200
333
-
3/19/2019
1,125
-
2
-
3/20/2019
24,589
-
15
-
3/21/2019
-
-
-
-
3/24/2019
-
4,700
-
-
3/25/2019
-
3,345
-
-
3/26/2019
-
3,800
-
-
3/17/2019
-
-
-
-
3/18/2019
-
-
-
-
3/19/2019
-
-
-
-
3/20/2019
-
-
-
-
3/21/2019
-
-
-
-
3/24/2019
-
-
-
1,245
3/25/2019
-
-
-
7,789
3/26/2019
-
-
-
6,189
3/27/2019
-
-
-
6,030
3/28/2019
-
-
62
-
Total
31,744
17,156
412
21,253
Thank you for your help!
... View more