topic Re: Re-format a number to remove empty spaces and PDF print in New SAS User

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

ljim1075 — Tue, 13 Dec 2022 22:14:07 GMT

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!

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

PaigeMiller — Tue, 13 Dec 2022 22:23:34 GMT

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.

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

Kurt_Bremser — Wed, 14 Dec 2022 07:02:31 GMT

Add this after the SQL:

%let obs = &obs.;

A %LET will automatically strip the value.

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

andreas_lds — Wed, 14 Dec 2022 08:03:46 GMT

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;

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

ljim1075 — Wed, 14 Dec 2022 14:01:17 GMT

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

Thank you again!