topic Re: Why fdelete doesnt work in my macro in SAS Programming

Why fdelete doesnt work in my macro

Citrine10 — Wed, 09 Feb 2022 13:45:54 GMT

Re: Why fdelete doesnt work in my macro

andreas_lds — Wed, 09 Feb 2022 09:54:13 GMT

Difficult to help without seeing the log.

Re: Why fdelete doesnt work in my macro

Citrine10 — Wed, 09 Feb 2022 09:55:45 GMT

I am not finding the piece of code in the log either so it doesnt seem like its even getting there 😞

Re: Why fdelete doesnt work in my macro

Kurt_Bremser — Wed, 09 Feb 2022 09:56:49 GMT

We will need to see how you insert the code in your macro, so we can detect how the macro code influences the FDELETE operation.

Tips for debugging macros:

use options mprint mlogic symbolgen;
insert %put statements so that you can see the state of variables, or identify when points in your logic are reached
unless you use nested %IF statements or %DO loops, macro code can be run as normal code with a current SAS release, which allows "open code" %IF %THEN %DO %END
start with inserting the FDELETE action into a small macro, then expand it step by step until you arrive at your original macro code

Re: Why fdelete doesnt work in my macro

Astounding — Wed, 09 Feb 2022 11:13:14 GMT

Perhaps your macro fails to contain a %MEND statement.

Perhaps your program defines the macro but fails to call the macro.

Re: Why fdelete doesnt work in my macro

ballardw — Wed, 09 Feb 2022 15:17:04 GMT

Did you have code that worked without creating a macro? First step in macro development is generally non-macro code that works. Then use that to create macro code.