03-03-2015 03:36 PM
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
I am not sure what I can use if I want to include a null. Eg.
It seems that I can’t use “”
03-03-2015 03:53 PM
The same idea would be useful here. If I could feed in a blank &group into a
define statgraph TotalGraph;
dynamic TITLE1 TITLE2;
entrytitle halign=left TITLE1;
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
TIP=(Year Level Y) tiplabel=(Year='Academic Term' Y='Students Enrolled' Level ='Level') datalabel=students_enrolled;
03-04-2015 12:27 PM
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.
03-04-2015 12:38 PM
It's not difficult to overcome:
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.
Need further help from the community? Please ask a new question.