topic Re: Pass Blank Value to SAS Dynamic SQL Macro in Developers

Pass Blank Value to SAS Dynamic SQL Macro

DavidPhillips2 — Tue, 03 Mar 2015 20:36:54 GMT

In SAS 9.2

I am converting a series of similar temporary table creation blocks into a macro. I figured out how to write the macro with the
exception of where one table contains one more column than another. I need to be able to pass a blank value into
a macro that won’t throw off my SQL create table statement.

For the column I want I found that I can use

%MyMacro(%str(four_digit_year varchar(4),));

I am not sure what I can use if I want to include a null. Eg.

%MyMacro(null)

It seems that I can’t use “”

Re: Pass Blank Value to SAS Dynamic SQL Macro

DavidPhillips2 — Tue, 03 Mar 2015 20:53:32 GMT

The same idea would be useful here. If I could feed in a blank &group into a
template.

proc template;

define statgraph TotalGraph;

dynamic TITLE1 TITLE2;

begingraph;

entrytitle halign=left TITLE1;

entrytitle TITLE2;

layout overlay / xaxisopts =(label = ' ') yaxisopts =(label = ' ' linearopts=(viewmin=0)) walldisplay=(fill);

seriesplot x=FOUR_DIGIT_YEAR y=students_enrolled / &group

name='a' index=index display=all

ROLENAME=(Year=ACADEMIC_PERIOD_DESC Level=&enrRepTy)

TIP=(Year Level Y) tiplabel=(Year='Academic Term' Y='Students Enrolled' Level ='Level') datalabel=students_enrolled;

endlayout;

endgraph;

end;

run;

Re: Pass Blank Value to SAS Dynamic SQL Macro

Astounding — Tue, 03 Mar 2015 21:10:48 GMT

Passing a null value should be easy:

%MyMacro ()

Re: Pass Blank Value to SAS Dynamic SQL Macro

DavidPhillips2 — Wed, 04 Mar 2015 17:27:03 GMT

Worked for me. If you have a method that accepts three parameters and you feed it two SAS feeds only two parameters. Apparently Polymorphism is not included in SAS.

Re: Pass Blank Value to SAS Dynamic SQL Macro

Astounding — Wed, 04 Mar 2015 17:38:03 GMT

It's not difficult to overcome:

%MyMacro (A,,C)

The first parameter receives a value of A, the second is null, and the third is C. It might be easier to understand if you switch from positional parameters to keyword parameters, though.