topic Re: SAS macro in SAS Programming

SAS macro

scb — Tue, 23 Oct 2018 08:04:09 GMT

May I know what wrong with the macro below as I can't get the T1 dataset? Thanks.

%LET PERIODE=01sep2018;
%LET TODATE ="10sep2018"D;

DATA _NULL_;
IF INTCK('DAY',"&PERIODE"D,&TODATE.) ge 8
THEN call symputx("T", "T1");
ELSE call symputx("T", "T2");
RUN;
%PUT T=&T;

%macro check(dsn);
%if T = "&dsn" %then %do;
DATA T1;
SET SASHELP.CARS;
IF MAKE EQ 'BMW';
RUN;
%end;
%else %do;
DATA T2;
SET SASHELP.CARS;
RUN;
%end;
%mend check;
%check(T1);

Re: SAS macro

Kurt_Bremser — Tue, 23 Oct 2018 08:32:28 GMT

%if T = "&dsn" %then %do;

In this macro statement, you compare the string

with a string that (as the macro is called later) is

"T1"

note the presence and absence of quotes.

What you probably wanted:

%if &T = &dsn %then %do;

The macro preprocessor does not need quotes when comparing strings, as everything is a string for it.

Re: SAS macro

Amir — Tue, 23 Oct 2018 08:36:34 GMT

Hi,

Try changing your %if condition to:

%if T1 = &dsn %then %do;

Regards,

Amir.

Re: SAS macro

RW9 — Tue, 23 Oct 2018 08:58:08 GMT

"May I know what wrong with the macro below " - its all in upper case, no use of the code window {i}, so code is next to impossible to read, no log provided to explain what is "wrong". (all mentioned previously).

At a guess I would say:

%if  T

is your problem as macro variables need an & before, and should also for good coding have a . afterwards.