topic PROC COMPARE - electronically analyze the output dataset? in SAS Procedures

PROC COMPARE - electronically analyze the output dataset?

KLR65 — Tue, 07 May 2013 22:24:22 GMT

I am curious if anyone has tried to electronically analyze an output dataset created using PROC COMPARE. I am trying to only pull out observations with certain characteristics.Visually, I can see the output but I need to be able to access the dataset via a datastep and pull out the observations with a lm_comp_dt of . (missing) or where the value is not E. Unfortunately, it still acts like a datetime stamp which the initial data is. I've attached a screen print. Thoughts? Thanks in advance! -K

Re: PROC COMPARE - electronically analyze the output dataset?

data_null__ — Tue, 07 May 2013 22:42:15 GMT

where lm_comp_dt ne .E;

The E is special missing E and to reference it you use dot E.

Re: PROC COMPARE - electronically analyze the output dataset?

KLR65 — Tue, 07 May 2013 22:55:31 GMT

Thank you so much! That is just what I was looking for! Much appreciated..