topic Re: missing data diagnostic macro in SAS Programming

missing data diagnostic macro

vonda12 — Thu, 07 May 2015 02:09:14 GMT

Hello,

I am trying to use a macro for exploring patterns of missing data but have no idea how macros actually work...

At first, I only used the couple of lines of code given in the paper (http://support.sas.com/resources/papers/proceedings11/339-2011.pdf), but later saw a website where the macro was available for download (http://www.columbia.edu/~qc2138/macro%20studying%20missing%20pattern.sas). So I copied the entire code from that page and plugged in my info the way it was shown in the paper. But nothing happens - there is no error message in the log, also no output. How do I get the summary tables?

Thank you for the help in advance!

Re: missing data diagnostic macro

ballardw — Thu, 07 May 2015 15:59:32 GMT

Before calling the macro add the following statement. It will provide details in the log of the code generated and will possibly help:

options mprint symbolgen mlogic;

You might also consider removing the NOPRINT options. That would generate some output that might be getting suppressed elsewhere. If you see lots of no records selected that may indicate your data doesn't match some assumptions of the macro OR that you specified something incorrectly in the macro call statement.

Re: missing data diagnostic macro

mcdj — Sun, 21 Feb 2016 18:25:33 GMT

Hi Vonda,

Do you by chance have the entire syntax for the Macro? I am trying to download it but the link from the paper to the Columbia website where you can download it is broken. Thanks!

Claire