topic Re: Compress func has too many arguments in SAS Programming

Compress func has too many arguments

Sathish_jammy — Fri, 13 Jul 2018 06:03:20 GMT

data have;
input abc $;
cards;
1.0 MG
0.25#
*1
2.5 UG
run;


data want;
set have;
a1 = compress(abc,'#*','s','a');
run;

I need only the numeric value. while using the compress func an ERROR occurred:

The COMPRESS function call has too many arguments.

Please suggest me any methods to solve.

Shmuel — Fri, 13 Jul 2018 05:45:12 GMT

The 2nd argument of compress is a string contains the delimiters or characters to ignore.

There is a 3rd argument with special means. In your case "kd" means keep digits only:

a1 = compress(abc, , 'kd');

You better look at the documentation.

Sathish_jammy — Fri, 13 Jul 2018 05:53:18 GMT

If i use 'kd' in compress then it delete '.' punctuation in (1.5, 2.5, 1.0) so the value should like (15 , 25, 10)

I need value in decimal as same as in my dataset.

Kurt_Bremser — Fri, 13 Jul 2018 06:34:32 GMT

READ THE DOCUMENTATION!

From the "modifier" part:

k or K keeps the characters in the list instead of removing them.

So you want to keep digits and dots, just use a list of all digits and the dot as second parameter, and k as the third.

data have;
input abc $;
cards;
1.0 MG
0.25#
*1
2.5 UG
;
run;

data want;
set have;
a1 = compress(abc,'0123456789.','k');
run;

Or use a combination of parameters:

data want;
set have;
a1 = compress(abc,'.','kd');
run;

Sathish_jammy — Fri, 13 Jul 2018 07:10:40 GMT