topic Re: SAS Macro parameter in SAS Programming

SAS Macro parameter

harshpatel — Fri, 08 Apr 2022 06:10:02 GMT

Hi,

Below is my requirement

Column_A Column_B

ABC 21

ABC 23

XYZ 31

XYZ 33

We are creating a macro variable for ABC value but when someone will pass BAAC value instead of ABC then also it should read value of ABC

Can anyone help me on this

Thanks

Harsh

Re: SAS Macro parameter

Oligolas — Fri, 08 Apr 2022 07:48:58 GMT

Please be precise.

why should BAAC return the value of ABC?

Is it because the string BAAC contains all the characters of ABC?

what about XYZ? should xXYzZ also return values of XYZ? what about "X Y Z"?

Re: SAS Macro parameter

ballardw — Fri, 08 Apr 2022 08:23:42 GMT

I'll let you know as soon as I finish writing my mind-reading app. 🤓

Re: SAS Macro parameter

harshpatel — Fri, 08 Apr 2022 08:25:23 GMT

Actually, i cant provide data so i have provided example

But actually if somebody will pass different parameters apart from ABC then also ABC parameter should pass

Remaining value should be kept as it is

Re: SAS Macro parameter

Oligolas — Fri, 08 Apr 2022 10:16:50 GMT

I've no idea what you mean, but here is something that meets the current "requirements". Enjoy.

data have;
input Column_A $ Column_B;
datalines;
ABC 21
ABC 23
XYZ 31
XYZ 33
;
run;

%macro doit(in=,out=,param=);
   data &out.;
      set &in.;
      where Column_A eq 'ABC'
      %if %nrbquote(&param.) ne %then %do;
         or upcase(Column_A) eq upcase("&param.")
      %end;
      ;
   run;
%mend doit;
%doit(in=have,out=want,param=blabla);

Re: SAS Macro parameter

PaigeMiller — Fri, 08 Apr 2022 10:18:52 GMT

@harshpatel wrote:

Actually, i cant provide data so i have provided example

But actually if somebody will pass different parameters apart from ABC then also ABC parameter should pass

Remaining value should be kept as it is

It's fine that you have provided an example. However, the explanation needs a lot more detail. Step-by-step, please explain what happens, in detail. That's the only way we can help you write code.

Re: SAS Macro parameter

harshpatel — Fri, 08 Apr 2022 10:25:25 GMT

Thanks, i got answer from your code

Re: SAS Macro parameter

PaigeMiller — Fri, 08 Apr 2022 10:33:39 GMT

@harshpatel

Please mark the correct response as correct!!