topic Re: How do I get the first part of the string using %scan in SAS Programming

How do I get the first part of the string using %scan

gyambqt — Wed, 17 May 2017 01:30:26 GMT

Hello experts,

if I have a string defined as &a and I want to grab all the string prior to @ from the whole string as defined by the %macro a %put. how do I achieve the result?

the following macro a is not working...

%let a=%str(SELECT a.ITS_ORIG_STN_CD , a.ITS_ORIG_STN_DS , b.CODE_CD, b.SUB_CODE_CD, b.CODE_TYPE_GP, b.CODE_LITERAL_DS from DS_LEAP.DS_ACCUSED a INNER JOIN DS_LEAP.DS_CODE_TABLE b ON ( a.ITS_ORIG_STN_CD = b.CODE_CD ) WHERE b.CODE_TYPE_GP = '0026' AND a.ITS_ORIG_STN_DS <> b.CODE_LITERAL_DS@a);

%macro a;

%put %scan(%nrstr(&a),1,'@');

%mend;

%a;

Thanks

Re: How do I get the first part of the string using %scan

AhmedAl_Attar — Wed, 17 May 2017 01:45:34 GMT

Try this,

%let a= %str(SELECT a.ITS_ORIG_STN_CD,a.ITS_ORIG_STN_DS,b.CODE_CD, b.SUB_CODE_CD,b.CODE_TYPE_GP,b.CODE_LITERAL_DS from DS_LEAP.DS_ACCUSED a INNER JOIN DS_LEAP.DS_CODE_TABLE b ON ( a.ITS_ORIG_STN_CD = b.CODE_CD ) WHERE b.CODE_TYPE_GP = '0026' AND a.ITS_ORIG_STN_DS <> b.CODE_LITERAL_DS@a);

%macro a;
 %put %scan(%superq(a),1,%str(@));
%mend;
%a;

Ahmed

Re: How do I get the first part of the string using %scan

gyambqt — Wed, 17 May 2017 01:55:30 GMT

thanks for your reply but it doesn't work when you try
%put %scan(%superq(a),2,%str(@));

Re: How do I get the first part of the string using %scan

Astounding — Wed, 17 May 2017 02:07:20 GMT

Have you tried removing the quotes from the third parameter: @ instead of '@'

The quotes aren't needed, and therefore indicate that quotes are one of the characters that %SCAN should use as a delimiter.

%SUPERQ (as was suggested) is a good idea as well:

%macro a;

%put %scan(%super(a), 1, @ );

%mend a;

Re: How do I get the first part of the string using %scan

AhmedAl_Attar — Wed, 17 May 2017 02:49:16 GMT

What are you expecting to get from %put %scan(%superq(a),2,%str(@));?
From your example string, there are no text after the '@' character.