topic Re: Add leading spaces to a calculated item in SAS Visual Analytics

Add leading spaces to a calculated item

LisaSklar — Mon, 30 Apr 2018 13:30:19 GMT

I am trying to add leading spaces to a calculated item that is going on a button bar, but VA won't display them. I am using 7.4. I have tried adding the spaces to the text itself inside the quotation marks, and also concatenating a sting of just spaces.

(This is to workaround the inability to right justify text in button bars... which is to workaround the fact that you can't put a text box in the report prompt area...)

Thanks.

Re: Add leading spaces to a calculated item

Astounding — Mon, 30 Apr 2018 14:34:18 GMT

As a SAS programmer with no VA knowledge ...

Are you able to apply a format to your field? In SAS language, the $CHAR formats maintain leading blanks that might otherwise be removed from displaying:

format varname $char10.;

Re: Add leading spaces to a calculated item

LisaSklar — Mon, 30 Apr 2018 15:39:05 GMT

Unfortunately, that did not work. Thanks for the suggestion, though.

Re: Add leading spaces to a calculated item

Madelyn_SAS — Mon, 30 Apr 2018 16:50:28 GMT

You can filter on the leading spaces, but the spaces are not displayed. See Usage Note 57176: SAS® Visual Analytics does not preserve leading blanks in displayed or exported data

Re: Add leading spaces to a calculated item

LisaSklar — Mon, 30 Apr 2018 18:32:08 GMT

Thanks for the reply. I'm sorry to hear there's not a way to make that work, but I appreciate the response.