topic Re: symput a macro variable with "/*.dat" in the string in SAS Programming

symput a macro variable with "/*.dat" in the string

JMarkW — Fri, 21 Aug 2009 19:29:11 GMT

I'm having difficulty defining a macro variable with the string "/*.dat" in it. if the * is changed to another character value the code works fine.

Is there some type of escape character that needs to proceed a * in this type of string?

Re: symput a macro variable with "/*.dat" in the string

deleted_user — Fri, 21 Aug 2009 20:17:54 GMT

Does surrounding the variable with %STR() or %NRSTR() help?

Re: symput a macro variable with "/*.dat" in the string

JMarkW — Mon, 24 Aug 2009 12:25:44 GMT

I'm using "call symput" in a data step so the macro commands will not work there.

I'm generating UNIX commands and did find that //*.dat will work while /*.dat will not.

Re: symput a macro variable with "/*.dat" in the string

PatrickG — Mon, 24 Aug 2009 13:43:32 GMT

That won't work. Those two characters in that order and everything that follows up to and including the chars */ in that order are consumed by the lexical analysis phase of the tokenizer, which thinks you're inserting a comment in your code. The trigger for this action is the / followed immediately by the *. That is why no amount of macro quoting will make any difference.

Re: symput a macro variable with "/*.dat" in the string

Flip — Mon, 24 Aug 2009 14:07:48 GMT

Ok, I took the simple approach to this and it works fine for me.

data _null_;
call symput('badstr', '"ls /*.txt ;"');
run;
x &badstr ;

Putting the quotes into the macro variable works, but quoting in the X command will not. (That is double quotes inside single quotes.)

Re: symput a macro variable with "/*.dat" in the string

JMarkW — Mon, 24 Aug 2009 15:49:06 GMT

The command is actually very complex grep being created dependent on input data.

Re: symput a macro variable with "/*.dat" in the string

JMarkW — Mon, 24 Aug 2009 15:53:07 GMT

I did get the following to work. I wonder if the first / escapes the second.

/usr/xpg4/bin/grep -l -E -e '^[^|]*\|[^|]*\|abc\|' -e '^[^|]*\|[^|]*\|defg\|' /dir1/dir2/dir3//*.txt

Re: symput a macro variable with "/*.dat" in the string

Peter_C — Thu, 12 Nov 2009 13:46:58 GMT

an old post, but one with outstanding value and issues ...
How

%let a= / ;
%let b= /&a.*;
%put %superQ(b) ;
b is established as //*
an alternative to /*.dat as a definition of all dat files, would be /?*.dat
Separating / and * with ? should not reduce the selection of files selected but will remove that troublesome /* combination

peterC