%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
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'") ;
%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
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, _);
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'") ;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.