Hello, I am stuck with a small problem and I ask for your support. I need to create a table with 60 columns, the value in each column is based on a date range. I cannot get it to work. I have the code data work.data_have; infile datalines delimiter=','; input issue_date :date9. amount :eurox18.2; datalines; '13JAN2018'd,4546.77 '08MAR2018'd,117.39 '12JUL2018'd,130.40 '14JUL2018'd,1167.35 '16JUL2018'd,209.96 '17JUL2018'd,0.00 '12JAN2019'd,4854.69 '08MAR2019'd,117.39 '13JUL2019'd,1274.66 '15JUL2019'd,207.41 '26JUL2019'd,113.75 ; run; data work.out_want; set work.data_have; array var(60) var_1 - var_60; do i=1 to 60; if (Issue_Date GE intnx('year', (today()- (i)), -1,'same')) and (Issue_Date LE (TODAY()- (i)) ) = i then var(i) = Amount; format var_1 - var_60 eurox18.2; end; drop i; run; %let var_i = var_1,var_2,var_3,var_4,var_5,var_6,var_7,var_8,var_9,var_10, var_11,var_12,var_13,var_14,var_15,var_16,var_17,var_18,var_19,var_20, var_21,var_22,var_23,var_24,var_25,var_26,var_27,var_28,var_29,var_30, var_31,var_32,var_33,var_34,var_35,var_36,var_37,var_38,var_39,var_40, var_41,var_42,var_43,var_44,var_45,var_46,var_47,var_48,var_49,var_50, var_51,var_52,var_53,var_54,var_55,var_56,var_57,var_58,var_59,var_60; ; The Output that I need is shown below: Everytime the date range select falls in certain {i} it should fill the sum(amount) in the appropriate column. var_1 var_2 var_3 var_4 var_5 var_6 var_7 var_8 var_9 var_10 var_11 var_12 6567,90 € 6567,90 € 6567,90 € 6567,90 € 6567,90 € 6567,90 € 6567,90 € 6567,90 € 6567,90 € 6567,90 € 4.854,69 € 4.854,69 € Thank you in advance!
... View more