topic Re: Need some help with printing macro in SAS Programming

Need some help with printing macro

Filipvdr — Tue, 31 May 2011 10:04:03 GMT

%Macro EDC(Type,id);
data out_table;
set RF300L3.edc_thick;
where col_ins_id = &id;
run;
%mend;

%macro Html;
ods listing close;
ods html file="/imec/other/imecweb/osp/sp/files/HTML.html" data _null_;
set all_append_and_edc_and_vars;
if type = 'THICK' then call execute('%EDC(THICK,col_ins_id)');
proc print data=out_table;run;

run;

ods html close;
%mend;
%Html;

the problem is the id i have to pass

Message was edited by: Filipvdr Message was edited by: Filipvdr

Re: Need some help with printing macro

andreas_lds — Tue, 31 May 2011 11:20:20 GMT

If "col_ins_id" is a dataset variable, then using cat can help.

[pre]call execute(cats('%EDC(THICK,' col_ins_id, ')');[/pre]

Re: Need some help with printing macro

PatrickG — Thu, 02 Jun 2011 14:31:13 GMT

I'm not sure I get what your problem / question is....

Re: Need some help with printing macro

ballardw — Thu, 02 Jun 2011 18:02:53 GMT

> %Macro EDC(Type,id);
> data out_table;
> set RF300L3.edc_thick;
> where col_ins_id = &id;
> run;
> %mend;
>
> %macro Html;
> ods listing close;
> ods html
> file="/imec/other/imecweb/osp/sp/files/HTML.html"

Missing semicolon to end ODS HTML statement;

> data _null_;
> set all_append_and_edc_and_vars;
> if type = 'THICK' then call

This may not work as EDC calls a data step and can not nest datasteps.

> execute('%EDC(THICK,col_ins_id)');
> proc print data=out_table;run;
>
> run;
>
> ods html close;
> %mend;
> %Html;
>
> the problem is the id i have to pass
>
> Message was edited by: Filipvdr
>
> Message was edited by: Filipvdr

Re: Need some help with printing macro

Filipvdr — Tue, 14 Jun 2011 06:36:11 GMT

so there is no solution to do this kind of working with macro and datasets to print?

Re: Need some help with printing macro

sbb — Tue, 14 Jun 2011 10:59:58 GMT

First, the ODS statement is missing a trailing semi-colon as was mentioned.
Second, the DATA step that invokes the CALL EXECUTE must have a RUN; statement to terminate / compile the code before invoking the PROC PRINT that follows.

Recommend the OP add the SAS statement below so that the max amount of diagnostic info is generated to the SAS log, and then if there are still problems, REPLY to this post with a COPY/PASTE of the entire SAS-generated log output:

OPTIONS SOURCE SOURCE2 MACROGEN SYMBOLGEN MPRINT /* MLOGIC */;

Also, if there are problems completing a forum post, review this companion forum post (and bookmark it for future reference) with posting guidelines:

http://support.sas.com/forums/thread.jspa?messageID=27609

Scott Barry
SBBWorks, Inc.

Suggested Google advanced search argument, this topic / post:

call execute run statement site:sas.com

Re: Need some help with printing macro

Ksharp — Fri, 17 Jun 2011 06:17:22 GMT

You should add 'proc print ' into your first macro EDCT. Such as

%Macro EDC(Type,id);
data out_table;
set RF300L3.edc_thick;
where col_ins_id = &id;
run;
proc print data=out_table;run;
%mend;

%macro Html;
ods listing close;
ods html file="/imec/other/imecweb/osp/sp/files/HTML.html" data _null_;
set all_append_and_edc_and_vars;
if type = 'THICK' then call execute('%EDC(THICK,col_ins_id)');

run;

ods html close;
%mend;
%Html;

Because the code generated by call execute is executed after your data _null_;

Ksharp