topic Re: how to use compress keep digit on macro variable in SAS Programming

how to use compress keep digit on macro variable

atul_desh — Thu, 13 Jul 2017 14:40:57 GMT

%put &dsn;
File_x_20170116 File_Y_20170220 File_z_20170320

%put %scan(&dsn,1,' ');
File_x_20170116

I want ouput from below function as '20170116' [digits from Fiile_x_20170116]

%put %sysfunc(compress(%scan(&dsn,1,' '), ,'kd'))
WARNING: In a call to the COMPRESS function or routine, the modifier "'" not valid.

is there any way to get it ?

Thanks

Atul Deshmukh

art297 — Thu, 13 Jul 2017 14:51:50 GMT

%let dsn=File_x_20170116 File_Y_20170220 File_z_20170320;
 
%put %scan(&dsn,1,' ');
 
%put %sysfunc(compress(%scan(&dsn,1,' '),,kd));

Art, CEO, AnalystFinder.com

Astounding — Thu, 13 Jul 2017 15:01:50 GMT

Using COMPRESS with kd is dangerous. It gives the wrong answer if digits appear elsewhere in the incoming file name. You would be better off using:

%let final_digits = %scan(%scan(&dsn, 1, %str( )), -1, _);

Tom — Thu, 13 Jul 2017 15:45:27 GMT

You do not need to put quotes around string literals in macro code. Everything is a string to the macro processor.

So this code that you would use in a data step.

want = compress(scan(DSN,1,' '),,'kd');

Would look more like this in macro code.

%let want=%sysfunc(compress(%scan(&dsn,1,%str( )),,kd)) ;

What you ran was more like this in data step code.

want=compress(scan(DSN,1,"' '"),,"'kd'") ;