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
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.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.