Help using Base SAS procedures

PROC COMPARE - electronically analyze the output dataset?

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 7
Accepted Solution

PROC COMPARE - electronically analyze the output dataset?

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


proc compare snapshot.JPG

Accepted Solutions
Solution
‎05-07-2013 06:42 PM
Respected Advisor
Posts: 3,799

Re: PROC COMPARE - electronically analyze the output dataset?

where lm_comp_dt ne .E;

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

View solution in original post


All Replies
Solution
‎05-07-2013 06:42 PM
Respected Advisor
Posts: 3,799

Re: PROC COMPARE - electronically analyze the output dataset?

where lm_comp_dt ne .E;

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

Occasional Contributor
Posts: 7

Re: PROC COMPARE - electronically analyze the output dataset?

Posted in reply to data_null__

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

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 176 views
  • 4 likes
  • 2 in conversation