topic Re: How to add leading space in values of a variable? in ODS and Base Reporting

How to add leading space in values of a variable?

DrAbhijeetSafai — Mon, 11 Jul 2022 10:27:31 GMT

I want to know how to add leading spaces in SAS for values of a character variable. Kindly note that I do not want to remove spaces but want to add 5 white spaces in the leading section of values of a character variable. Thanks in advance.

Re: How to add leading space in values of a variable?

andreas_lds — Mon, 11 Jul 2022 10:51:04 GMT

Is the variable long enough to store five additional chars? Something like this should do:

var = cat(repeat(' ', 4), var);

Please note, that html and log may hide those leading spaces.

Re: How to add leading space in values of a variable?

Patrick — Mon, 11 Jul 2022 10:56:35 GMT

This is certainly a rather unusual request and I assume you want to do this for some reporting/indention.

You can easily add leading blanks just by concatenating such blanks to the variable BUT depending on the procedure and especially the output destination used these leading blanks might still not print as you'd like it.

Consider the following code:

data test;
  length var2 var3 $10;
  format var3 $char10.;
  var='abcd';
  var2='     '||var;
  var3='     '||var;
run;
ods listing;
proc print data=test;
run;

Listing destination:

HTML destination (the SAS EG default):

So if this is about reporting/printing then eventually it's more about using styles instead of adding blanks to the internal value of SAS variables.

Let us know a bit more in detail what you have and what you need and we can go from there.

Re: How to add leading space in values of a variable?

DrAbhijeetSafai — Mon, 11 Jul 2022 12:00:29 GMT

Thank you @Patrick for the quick response. I was also thinking on the same lines but it was not working at that time. However, after sometime the solution given by you worked, however, I had not seen your response at that time. It just worked (maybe there was some other issue) and now I am seeing your response. Thanks a lot once again for the quick response. It is surely helpful.

- Dr. Abhijeet Safai