topic Re: How to extact mismatch columns from SCD type2 data set in New SAS User

How to extact mismatch columns from SCD type2 data set

learn_SAS_23 — Thu, 27 Sep 2018 13:39:50 GMT

We are Having SCD Type 2 tables almost 200 tables , with 250 columns in each table.

for

EX: STUDENT details

STUDENT_ID VALID_FROM_DT VALID_TO_DT NAME CITY CONTACT_NO BRANCH
1 04-April-2018 10-April-2018 XYZ Chennai 12345 CSE

1 10-April-2018 31-DEC-2055 XYZ MUMBAI 87777 CSE

looking for some generic solution where to exact only mismatch columns for this case the output should be

OUTPUT :

STUDENT_ID VALID_FROM_DT VALID_TO_DT CITY CONTACT_NO
1 04-April-2018 10-April-2018 Chennai 12345
1 10-April-2018 31-DEC-2055 MUMBAI 87777

Can this solution is possible , if so can it be some generic wherei can use this for all my 200 tables.

Thanks in Advance .

Re: How to extact mismatch columns from SCD type2 data set [how to improve your question]

Community_Guide — Thu, 27 Sep 2018 14:30:16 GMT

Hello @learn_SAS_23,

Your question requires more details before experts can help. Can you revise your question to include more information?

Review this checklist:

Specify a meaningful subject line for your topic. Avoid generic subjects like "need help," "SAS query," or "urgent."
When appropriate, provide sample data in text or DATA step format. See this article for one method you can use.
If you're encountering an error in SAS, include the SAS log or a screenshot of the error condition. Use the Photos button to include the image in your message.
It also helps to include an example (table or picture) of the result that you're trying to achieve.

To edit your original message, select the "blue gear" icon at the top of the message and select Edit Message. From there you can adjust the title and add more details to the body of the message. Or, simply reply to this message with any additional information you can supply.

SAS experts are eager to help -- help them by providing as much detail as you can.

This prewritten response was triggered for you by fellow SAS Support Communities member @Reeza

Re: How to extact mismatch columns from SCD type2 data set

ballardw — Thu, 27 Sep 2018 14:36:29 GMT

Define the rules for determining a "mismatch".

For instance are the apparent date values shown involved in the "mismatch" for selecting those records? If there are any variables not to be considered you would need to mention them.

Re: How to extact mismatch columns from SCD type2 data set

learn_SAS_23 — Thu, 27 Sep 2018 18:05:31 GMT

To determine as a mismatch, since it's a scd type 2 Table,if there is any
change in previous record in any of the columns, then a new record will be
created,with the statical columns such as valid date from and valid date
to,

So, if any columns in row 1 is not equal to row 2 then it is considered as
a mismatch, we just need to display the specific mismatched column,

Since we have almost 200 table's with more columns , looking for some
generic solution , if I can pass a table name in the macro code , the
output data set with a specific mismatched columns as shown in the example.

Thanks