# Analysis of impact between 2 observations

I have 2 columns of ~18000 observations. First column contains a value that shows the delay of a filed document (in days) of year 2017. For example: if the document had to be filed on May 5th 2017, but was filed on May 7th 2017, the value for that observation would be "2". The second column contains the same observation for the year 2018. The document needs to be filed annually.

Quirks of the data:

1. If the document was filed in a timely manner, the observation is "0";
2. If the document had to be filed, but wasn't at all, the observation is "Q";
3. If the document didn't have to be filed and wasn't filed, the observation is empty;
4. The rest of the observations are natural numbers.

Question: Assume an action was taken to increase compliance of filing this document. Is it possible to measure the effect of this action?

So far I've divided the 2017 column into 4 subsets, filtered by the observation type (0, Q, Empty, Natural) and made a matrix, showing the distribution of the 2018 column in each of these subsets. Is there a better test I could do for this problem?

3. It sounds like the illegitimately missing values (Qs) are of an interest of themselves, as their rate of occurrence might indicate the level of compliance. You could supplement 1/2 (above) with the comparison of the proportion of Qs in 2017 vs 2018. It would probably make sense to look at the proportion of Qs among active entities only, i.e. Qs/(Qs+Ns+0s), excluding empty values. R's prop.test() is a common way of doing this.