topic Re: How to remove extra blank spaces after the text in SAS Programming

How to remove extra blank spaces after the text

varshabansal — Mon, 30 Oct 2023 11:07:51 GMT

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!

Re: How to remove extra blank spaces after the text

TarunKumar — Mon, 30 Oct 2023 11:28:54 GMT

Use compress function

Re: How to remove extra blank spaces after the text

Kurt_Bremser — Mon, 30 Oct 2023 11:34:20 GMT

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.

Re: How to remove extra blank spaces after the text

varshabansal — Mon, 30 Oct 2023 11:34:39 GMT

use compress getting compress(name .sas)

Re: How to remove extra blank spaces after the text

PaigeMiller — Mon, 30 Oct 2023 11:53:30 GMT

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

I don't know what this means.

Re: How to remove extra blank spaces after the text

Kurt_Bremser — Mon, 30 Oct 2023 12:24:16 GMT

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