@Froebel wrote:
Thank you, I appreciate your response and I realize i should have provided more details. I have added the required code snippet, like you noted there is an error in the part where i am checking for null condition but what is it?
Part of the issue could well be where the macro variables Type and Minage are set. You do not show that anywhere.
Not sure what you are expecting for a result as there is no data accompanying the macro or the expected result. Adding the MINAGE added another syntax issue:
AND TRUNC(months_between(orderdate, BIRTH_DATE) / 12) &minage.;
I don't find any documentation for a MONTHS_BETWEEN function in SAS. Is that some locally defined function (typically for such I would expect to see the INTCK function). And regardless the use of "And trunc(somevalue) &minage." will be a syntax error.
Suggestion: Turn on the option MPRINT as I showed above. Run your macro. Go to the log and copy the result of running your macro with all the MPINT notes. On the forum open a text box and paste that text. I strongly suspect you will see at least one if not more error messages.
You may have not been bothering to tell us about the errors you are receiving from the code because the default error messages shown after a macro runs are bit difficult to connect with specific statements. The MPRINT option will make the errors appear in closer proximity to the code causing them.
