topic Re: what does it mean ? in SAS Programming

what does it mean ?

tianerhu — Mon, 25 Apr 2022 21:13:16 GMT

%SUBSTR does not mask special characters or mnemonic operators in its
result, even when the argument was previously masked by a macro quoting function.

Re: what does it mean ?

WarrenKuhfeld — Mon, 25 Apr 2022 21:46:21 GMT

While not directly answering your question, a good heuristic when you have to process values of macro variables that might contain any special characters is use a DATA step (e.g. DATA _NULL_), SYMGET, ordinary DATA step string processing, and then SYMPUTX. Your life will be much easier.

Re: what does it mean ?

Tom — Mon, 25 Apr 2022 22:20:04 GMT

@tianerhu wrote:

%SUBSTR does not mask special characters or mnemonic operators in its
result, even when the argument was previously masked by a macro quoting function.

It is saying if you use %SUBSTR() to extract part of an existing string the resulting string will not be masked.

If you use %QSUBSTR() to extract part of an existing string the resulting string WILL have macro quoting.

Consider this example:

%let unquoted=abcd,3;
%let quoted=%str(abcd,3);

%put substr(&unquoted,1)=%substr(&unquoted,1);
%put substr(&quoted,1)=%substr(&quoted,1);

When the input is unquoted the ,3 is considered one of the arguments and the result is just the third character, c.

When it is quoted then the ,3 is part of the string to subset and since the starting point is the first character and no length is given the result is the full string back again.

24    %put substr(&unquoted,1)=%substr(&unquoted,1);
substr(abcd,3,1)=c
25    %put substr(&quoted,1)=%substr(&quoted,1);
substr(abcd,3,1)=abcd,3

But the result is no longer quoted.

You can see this by feeding the output back into the same test:

27    %put %substr(%substr(&quoted,1),1);
c

Re: what does it mean ?

tianerhu — Tue, 26 Apr 2022 00:04:08 GMT

Thank you for your help.

Re: what does it mean ?

tianerhu — Tue, 26 Apr 2022 00:04:33 GMT

Thanks for your help.