Hi All,
I'm new to the sas below is my sample data and output format which I'm looking for. I tried to work on proc report which worked when my data is very low say 200 observations. But, when I applied on the whole date which contains around 32,000 observations my enterprise guide is not responding.
Please help me to resolve this issue.
proc report data=a1 nowd out=a3;
by Amount transaction_date
;
column customer Amount pmt_amt transaction_date
System_date;
define customer/order;
define transaction date
/order;
define System_date/order;
/*break after vin/skip summarize ol;*/
rbreak after/summarize dol;
run;
customer
Amount
transaction date
System date
1234
100
02-Aug-17
02-Aug-17
1234
200
03-Aug-17
03-Aug-17
2345
300
03-Aug-17
03-Aug-17
3214
200
01-Sep-17
01-Sep-17
looking for Output:
1234
transaction date
System date
Amount
02-Aug-17
02-Aug-17
100
03-Aug-17
03-Aug-17
200
Total
300
2345
03-Aug-17
03-Aug-17
300
Total
300
3214
01-Sep-17
01-Sep-17
200
Total
200
Looking forward to hear from you
... View more