topic how to remove spaces in a value in SAS Programming

how to remove spaces in a value

HitmonTran — Mon, 14 Nov 2022 22:52:47 GMT

Hello,

I have values with spaces i want to strip.

data (character values):

var1

( 5.4%, 15.3%)

( 100.0%)

(100.0%,99.9%)

want:

var1

(5.4%, 15.3%)

(100.0%)

(100.0%,99.9%)

Tom — Tue, 15 Nov 2022 00:51:42 GMT

Use the COMPRESS() function. That will remove specific characters. The default is to remove spaces.

data want;
  set have;
  var1=compress(var1);
run;