topic Re: how to add leading blank spaces to Title statement in SAS Programming

how to add leading blank spaces to Title statement

mgorripati — Mon, 15 Aug 2016 17:37:44 GMT

Can someone explain how to add Leading Blank spaces to Title Statement while left justifying the Title.

Thanks,

Re: how to add leading blank spaces to Title statement

Cynthia_sas — Mon, 15 Aug 2016 18:01:22 GMT

Hi:
The answer will depend on your destination of interest (HTML, PDF, RTF)? Why do you need leading spaces if you are left-justifying the title (just curious).

cynthia

Here's an example for the 3 primary destinations:

Re: how to add leading blank spaces to Title statement

mgorripati — Mon, 15 Aug 2016 19:34:51 GMT

Cynthia, thanks for the response and sorry for not providing complete deltails.

I want to add few Leading blank spaces to the Title in my excel report generated by PROC REPORT using tagsets.ExcelXP.

TITLE J=LEFT " " "Total Members = &client_cnt";

I want the Total Members to be displayed starting from 2nd or 3rd column . providing space in TITLE statment is not working when i am left justifying it .

Thanks,

Re: how to add leading blank spaces to Title statement

Cynthia_sas — Mon, 15 Aug 2016 22:27:12 GMT

Hi:
I am not sure that TAGSETS.EXCELXP will use the ESCAPECHAR and {NBSPACE} technique that works with other destinations. You might need to work with Tech Support on this. I think that once you are in Excel, you can indent a cell, but I am not sure you can insert leading spaces and have Excel use the leading spaces when opening the file.

cynthia

Re: how to add leading blank spaces to Title statement

ballardw — Mon, 15 Aug 2016 22:46:23 GMT

A possibly confusing approach might be to try null characters (ASCII 255). You often can type them into the editor by holding down the alt key and then use the NUMERIC key pad to type 255 and release the alt key (for each character). What gets seen may depend on the active font but mostly it looks like a space and generally doesn't get stripped like a space does.

Re: how to add leading blank spaces to Title statement

Ksharp — Tue, 16 Aug 2016 02:19:30 GMT

Can you just add some TAB characters before it ?


TITLE " '09'x   '09'x  '09'x  '09'x    xxxxxxxx";

Re: how to add leading blank spaces to Title statement

svil — Wed, 02 Oct 2019 17:49:52 GMT

Adding TAB characters works excellent. Thank you!!!