Re-format a number to remove empty spaces and PDF print

[ljim1075]

Hello everyone and anyone!  When you run the below code the display PDF number has space/separation from the title.  How do I re-format to the number of characters.

Current view: 'Total Number of Records:      2,020'

Want view: 'Total Number of Records: 2,020'

SAS Code:

ods pdf file="file path to save/Total Count.pdf";
options linesize=max;

proc sql noprint;
select
count(*) as Tot_Cnt format comma10.
into
:Obs
from SASHELP.aacomp
;
quit;
%put NOTE: &Obs;

ods pdf startpage=no;
ods proclabel='Title';
title bold height=22pt color=purple "Total Number of Records: &Obs.";
proc report data=SASHELP.aacomp;
run;
title;

ods pdf close;

Thank you for your support!

[PaigeMiller]

Current view: 'Total Number of Records:      2,020'

The easiest thing to do is to create this string without the unwanted blanks. If you can't do that, use the COMPBL function.

[Kurt_Bremser · Accepted solution]

Add this after the SQL:

%let obs = &obs.;

A %LET will automatically strip the value.

[ljim1075]

Thank you all for your feedback, I knew it had to be something simple.  The %LET did the work.

Thank you again!

[andreas_lds]

Or add the option "trimmed" to the into-clause:

proc sql noprint;
  select count(*) as Tot_Cnt format comma10.
    into :Obs trimmed
    from SASHELP.aacomp
  ;
quit;