Please post your example data as datalines in a data step. Nobody in his right mind will open a Excel file from the internet. And also supply "want" data to ilustrate your requirements. ... View more

Sample data set ; Loan No Relationship Id Principal loss Interest Loss Available Amount 001 a1 1250 300 6000 002 a1 200     003 a1 450     456 a2 2000 450   789 a2 3000 390   786 a3 5000 850 4500 456 a4 1200 650 3000 253 a4 1300 753   243 a4 1900 253              For each loan account we  have to adjust the pricipal loss amount first & then Interest Loss from the available amount . Logic is for one relationship id there may many loan account nos as well as savings account nos. we have taken the available amount from the savings a/c. now we have to adjust the principal loss & interest loss for each loan account  and to  updated the balance due.   Regards Aarthi ... View more

Have you looked at the noheader option of proc report? For this, and how to supress individula column headers, https://communities.sas.com/t5/ODS-and-Base-Reporting/Hide-PROC-Report-column-names/td-p/61639 might be interesting. ... View more

Here is an example:   proc fcmp outlib=work.functions.smd; function ftoc(f) $; length r $ 10; if f=210 then r='C'; else if f=211 then r=put(f,yymmdd10.); else r='N'; return (r); endsub; run; options cmplib=(work.functions); proc format; value ftoc(default=10) other=[ftoc()]; run; data have; input c ; cards; 210 211 212 ; run; data have; set have; format c ftoc10.; run; proc print;run; ... View more

proc report data=sashelp.class nowd ; define name/style={cellheight=4cm cellwidth=4cm}; run; ... View more