topic How to use nbspace in proc report in SAS Programming

How to use nbspace in proc report

sri1 — Wed, 26 Aug 2020 10:23:43 GMT

Hi ,

I have the following dataset and trying to add blank spaces with nbspace function, but appears as text in output of proc report.

I am not sure where I am getting wrong.

data test;

infile cards;

input x $ x1 $;

cards;

10.1 0

0 10.2

4.5 0

;

run;

ods escapecahr="$";

data test2;

array arr1(2) $15 x x1;

set test;

do i= 1 to 2;

if arr1(i)=0 then arr1(i)="0${nbspace3}";

end;

run;

ods rtf file="C:\test.rtf";

proc report data=test2;

column x x1;

define x/display center;

define x1/display center;

run;

ods rtf close;

proc report output is as below:

x x1

10.1 0{nbspace3}

0{nbspace3} 10.2

4.5 0{nbspace3}

Appreciate your input.

Thanks

Re: How to use nbspace in proc report

PaigeMiller — Wed, 26 Aug 2020 10:56:55 GMT

Are you doing this to try to right justify or left justify the zeros? There are other ways to do this, and you'd be much better off if you read in X and X1 as numbers instead of characters. And I'm not sure exactly what nbspace at the end of the line will do anyway, usually you would use nbspace in the middle of text, such as this:

footnote  "Marketing Data ^{nbspace 50}  www.sas.com ";

Anyway, this line will not work

if arr1(i)=0 then arr1(i)="0${nbspace3}";

It should say

if arr1(i)="0" then arr1(i)="0${nbspace3}";

Re: How to use nbspace in proc report

Ksharp — Wed, 26 Aug 2020 12:08:26 GMT

if arr1(i)=0 then arr1(i)="0${nbspace3}";
==>
if arr1(i)=0 then arr1(i)="0$_$_$_";

Re: How to use nbspace in proc report

RichardDeVen — Wed, 26 Aug 2020 12:34:49 GMT

You can use the hard space character denoted in hex form as 'A0'x

if arr1(i)=0 then arr1(i)=cats('0', repeat('A0'x,2));