Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Add leading spaces to a calculated item

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 11
Accepted Solution

Add leading spaces to a calculated item

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.


Accepted Solutions
Solution
‎04-30-2018 02:30 PM
SAS Super FREQ
Posts: 586

Re: Add leading spaces to a calculated item

Posted in reply to LisaSklar

All Replies
Super User
Posts: 6,935

Re: Add leading spaces to a calculated item

Posted in reply to LisaSklar

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.;

 

 

Occasional Contributor
Posts: 11

Re: Add leading spaces to a calculated item

Posted in reply to Astounding

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

Solution
‎04-30-2018 02:30 PM
SAS Super FREQ
Posts: 586

Re: Add leading spaces to a calculated item

Posted in reply to LisaSklar

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 da...

Occasional Contributor
Posts: 11

Re: Add leading spaces to a calculated item

Posted in reply to Madelyn_SAS
Thanks for the reply. I'm sorry to hear there's not a way to make that work, but I appreciate the response.
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 148 views
  • 0 likes
  • 3 in conversation