topic Re: Proc report allignment in SAS Enterprise Guide

Proc report allignment

nr1 — Sat, 21 Jul 2018 04:05:38 GMT

I want to right align this content to fit the table.

data Footer3 ;

length col1 $5000;

run;

proc sql;

insert into Footer3

values ('DISCLAIMER: This computer generated statement contains the particulars of the transaction(s) in the account that have been updated till the time of day end operations of the CBS system of the Bank on the previous working day and the same will not reflect the transaction(s) that have occurred in the acount, if any, subsequent thereto. The Federal Bank Ltd. shall not be liable/responsible for want of full particulars of the transaction(s) at the time of the genration of this statement.')

values ('This is a computer generated statement which need not normally be signed. Contenets of this statement will be considered correct if no error is reported within 21 days of the statement date.')

values ('****END OF STATEMENT****');

quit;

/*** Inside ODS PDF ****/

proc report data=Footer3 noheader

style(report)=[OUTPUTWIDTH=100%]

style(column)=[font_size=0.24cm /*borderleftcolor=white borderrightcolor=white bordertopcolor=white borderbottomcolor=white*/];

run;

i am getting the output like this .Please check the attachment The blank space i have marked in yellow i want those space also be to filled and fit the table size

Re: Proc report allignment

nr1 — Sat, 21 Jul 2018 06:15:32 GMT

Help would be highly appreciated

Re: Proc report allignment

pau13rown — Sat, 21 Jul 2018 07:14:23 GMT

should you use "flow"?: http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a002473627.htm

Re: Proc report allignment

nr1 — Sat, 21 Jul 2018 07:40:51 GMT

Can you give an example. As far as i know 'flow' is used to wrap/split the text in the columns. I want it to completely fit within the border, not leave any spaces/gaps within the border.

Re: Proc report allignment

ballardw — Mon, 23 Jul 2018 17:05:34 GMT

I am not going to open a ZIP file from an unknown source.

If you want to display text without any actual proc report statistics perhaps PROC ODSTEXT is a better fit for the task.

data example;
   x='DISCLAIMER: This computer generated statement contains the particulars of the transaction(s) in the account that have been updated till the time of day end operations of the CBS system of the Bank on the previous working day and the same will not reflect the transaction(s) that have occurred in the acount, if any, subsequent thereto. The Federal Bank Ltd. shall not be liable/responsible for want of full particulars of the transaction(s) at the time of the genration of this statement.';
run;

proc odstext data=example;
 p x/  style=[font_size=0.24cm ];
run;

Note that ODSTEXT does not place table borders by default.

Actually you don't even need the data set, you could use

p ' your long text goes here' / style=[ ];

but I used the data set incase you actually have multiple "lines" of data to display.

Re: Proc report allignment

nr1 — Fri, 27 Jul 2018 04:35:09 GMT

We tried with ODSTEXT but still the issue is not solved.There is still space /gap in the right side of the content in the pdf.