topic Re: select values from proc compare in SAS Procedures

select values from proc compare

amager — Wed, 18 Sep 2019 12:52:45 GMT

Hi everyone,

How to select each values changed between base & compare dataset out by proc compare outnoequal ;

if value equal to ' X.....' then select variable and row for this values.

i want to select this value to update into another dataset.

Thanks in advance

Re: select values from proc compare

PeterClemmensen — Wed, 18 Sep 2019 12:54:40 GMT

Can you demonstrate this logic by an example?

Re: select values from proc compare

amager — Wed, 18 Sep 2019 13:17:13 GMT

in outnoequal dataset from proc compare. if value had changed it's equal to 'XXX......' . i want to select that value from _COMP_ to update another dataset by the value changed , to do that exacytly i need to find the variable and id of this changed value .. any suggestions. may be have an easy way

Re: select values from proc compare

Tom — Wed, 18 Sep 2019 13:22:07 GMT

@amager wrote:
in outnoequal dataset from proc compare. if value had changed it's equal to 'XXX......' . i want to select that value from _COMP_ to update another dataset by the value changed , to do that exacytly i need to find the variable and id of this changed value .. any suggestions. may be have an easy way

Provide an EXAMPLE. Post two data steps that can be used to create two datasets. Post the PROC COMPARE code to compare them and create an output dataset. Show what the resulting output looks like. Explain what you want to select from this dataset. Explain what format you need it in if the way PROC COMPARE creates it is different from how you need it. Then perhaps someone can help you. But most likely just doing that will show you how to solve the problem yourself.

Re: select values from proc compare

amager — Wed, 18 Sep 2019 15:33:13 GMT

I modified my questions how can i found expressions in variables like :
.......X....
X...........
...........X
XXXXXXXX....
........XX..
........XXXX
XXXXXXXXXXXX
and not like
............
X1225112.........
which functions can do it exactly ? or i need regular expressions ?? any help

Re: select values from proc compare

Tom — Wed, 18 Sep 2019 15:46:47 GMT

So if the variable is named FRED then check if it contains any X characters.

if indexc(fred,'X') then ....

Re: select values from proc compare

amager — Wed, 18 Sep 2019 16:13:12 GMT

Thanks for your help @Tom , but this can find also 'X1225112.........'

Re: select values from proc compare

Tom — Wed, 18 Sep 2019 16:19:44 GMT

That value will NOT be possible in the DIFF output. It will only have periods or X. There is another variable that can be checked to test which type of observation you have.

Re: select values from proc compare

amager — Wed, 18 Sep 2019 16:42:59 GMT

you are RIGHT @Tom , i Just Chked it but still don't select value with more 'XX' like '.......XXX.....' ,

Re: select values from proc compare

Tom — Wed, 18 Sep 2019 16:49:44 GMT

Post an actual example. For example take the one you are currently look at: eliminate all variables except the one you are currently checking, and any ID variables required to get PROC COMPARE to run ; eliminate all observations except one that matches exactly and one that produces the '...XXX...' value you are having trouble finding. Then post that as self contained code that others can run to reproduce your issue. Or just make up some data to test with.