Difficult to help without seeing the log.
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:
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.
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.