01-30-2015 12:49 PM
I created two macro variables using proc sql select into. My expectation is that I will get two numbers and then continue to next step. The part of my is below:
proc sql noprint;
The error messages are:
ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric
operand is required. The condition was: 290.6-10
ERROR: The macro PLOT will stop executing.
I know one way to use input function in data step but not sure how to achieve my goal in this situation.
Any suggestions are welcome and thanks for all.
01-30-2015 01:15 PM
select (min(mean) -10),(max(mean)+10) into : low , :upper
and avoid the extra step?
Of course if you also need mini and maxes that's not needed.
01-30-2015 01:57 PM
For axis scaling I would look at the IML routine GSCALE. I it takes min and max values and produces nice tick marks using some criteria that you can adjust, like Number of Ticks.
Need further help from the community? Please ask a new question.