comparing two excels

[Raj_C]

Hi SAS Users,

I want to compare two excel files which I have attached.

having Subject ID, VISITREFNAME Record identifier are the common variables in both excels.

unmatched data to be reported in new excel sheet with sas code.

Simple code will be highly appreciated.

Kind Regards,
Raju

[Kurt_Bremser]

- import tables into SAS

- sort by identifying key variables

- in a data step, MERGE the two tables by key variables, using the in= dataset option to identify contributing tables

- specify a condition, using the variables from the in= options

PS don't post example data in MS Office files. Nobody in his right mind opens such from the web.

Use a data step with data in a cards; block.

[Abhi1212]

Hello Sir,

Could you please provide the complete code for comparing two excels ?

[Kurt_Bremser]

My consultant fee for doing other people's work is 100 € / hr.

Show what you've already done, provide data, and where your problem lies, to get hints for fixing it.

[Abhi1212]

My two excel file has been imported. I am not sure about my next step of code..

[Kurt_Bremser]

Show the data (data steps created with the macro from https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat...), so we can get an idea how to compare them. Reduce number of observations, if necessary.