topic SAS Macro in SAS Programming

SAS Macro

desireatem — Tue, 02 Nov 2021 16:03:21 GMT

Please can someone help tell me why the data Ycomple1 is not being created despite the data Ycomple exist.

%macro multi;

data Ycomple1; /*** This data is not created *****/;

set Ycomple; / ** This data exist ****/;

%do i=0 %to 100;

ipw&i=ipw*WGT&i;

drop WGT&i;

%end;

run;

%mend multi;

Re: SAS Macro

ghosh — Tue, 02 Nov 2021 15:50:31 GMT

put another semicolon after %end

%end; ;

Re: SAS Macro

desireatem — Tue, 02 Nov 2021 16:04:46 GMT

That does not solve it.

Re: SAS Macro

ghosh — Tue, 02 Nov 2021 16:05:40 GMT

please show the error log

Re: SAS Macro

Reeza — Tue, 02 Nov 2021 16:08:14 GMT

Run the following and post the log then we can tell you why.

EDIT: I don't see the macro actually called so adding that in, just in case.


options mprint symbolgen;
%macro multi;

data Ycomple1;
set Ycomple;
%do i=0 %to 4;
ipw&i=ipw*WGT&i;
drop WGT&i;
%end;
run;
%mend multi;



%multi;

@desireatem wrote:

Please can someone help tell me why the data Ycomple1 is not being created despite the data Ycomple exist.

%macro multi;

data Ycomple1; /*** This data is not created *****/;

set Ycomple; / ** This data exist ****/;

%do i=0 %to 100;

ipw&i=ipw*WGT&i;

drop WGT&i;

%end;

run;
%mend multi;

Re: SAS Macro

desireatem — Tue, 02 Nov 2021 16:17:46 GMT

Thank you, you are right, it wasnt being called.