topic Re: Help with if-then statement in macro in SAS Data Management

Help with if-then statement in macro

Megan2020 — Fri, 10 Jan 2020 20:29:17 GMT

Hi,

The following code doesn't work. I'm wondering if someone could suggest a fix.

Note: I am trying to mimic an if-then statement with basically two conditions, e.g., if x then 1, if y then 2, else z. ..I can't figure out how to get it to do that as I'm not as proficient in macros.

%if &trim=0 %then %do;
%let condition = %str(if myvars(i)< perct1(i) then myvars(i)=perct1(i) );
%let condition = %str(if myvars(i)> perct2(i) then myvars(i)=perct2(i));
%end;
%else %let condition = %str(myvars(i)=min(perct2(i),max(perct1(i),myvars(i))) );

Re: Help with if-then statement in macro

Reeza — Fri, 10 Jan 2020 20:36:39 GMT

Your logic and code don't match at all so I'm having a hard time understanding which to fix here.

What are you trying to do overall? What makes you think you need a macro in the first place as well - this type of logic is usually best done via a format or SELECT statement, not a macro but hard to confirm that without knowing more.

Re: Help with if-then statement in macro

Megan2020 — Fri, 10 Jan 2020 20:39:05 GMT

It's someone else' macro I'm trying to fix. Here's the entire macro

https://wrds-www.wharton.upenn.edu/pages/support/research-wrds/macros/wrds-macros-winsorize/#example

I need the by group functionality and his is the only one I can find that works for that but it only works for trimming TRIM=1 because I think he's missing code for TRIM=0.

That's what my few lines were trying to add.

Thanks for any help. Much appreciated.

Re: Help with if-then statement in macro

Tom — Fri, 10 Jan 2020 20:57:36 GMT

That %IF/%THEN/%ELSE is just being used to stuff some SAS code into a macro variable.

Is the problem that you want to stuff two SAS statements into the macro variable CONDITION when is TRIM is set to 0?

Just add a semi-colon between the two statements inside the %STR() macro function call.

%if &trim=0 %then %let condition = 
%str(if myvars(i)< perct1(i) then myvars(i)=perct1(i) 
    ;if myvars(i)> perct2(i) then myvars(i)=perct2(i)
    )
;
%else %let condition = 
%str(myvars(i)=min(perct2(i),max(perct1(i),myvars(i))) 
    )
;