How to remove extra blank spaces after the text

[varshabansal]

Hello everyone!

I want to remove extra space my text. how to remove that 

output is like this Fsc_acount_dim            .sas  

but i want to be it as fsc_account_dim.sas

Thanks in advance!

[TarunKumar]

Use compress function

[varshabansal]

use compress getting compress(name .sas)

[PaigeMiller]

---

@varshabansal wrote:
use compress getting compress(name .sas)

---

I don't know what this means.

[Kurt_Bremser]

Since @varshabansal tried to use a data step function in a macro statement without %SYSFUNC, the "function call" became part of the text.

[Kurt_Bremser]

You cannot use a data step function like that in macro statements. You have to wrap data step functions into a %SYSFUNC call.

But a simple %LET will automatically strip leading and trailing blanks, so this will do:

%let nam=&name.;

if (and that can be a big IF) you really have blanks (hex 20). Other "whitespace" characters are not filtered.

In the future, use the proper forum windows (</> and "little running man") to copy/paste the log or program text into. Pictures make it hard for us to use code for testing, or to point out mistakes or places for improvement.