topic Re: comparing two excels in SAS Programming

comparing two excels

Raj_C — Mon, 29 Aug 2016 13:28:05 GMT

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 — Mon, 29 Aug 2016 13:31:44 GMT

- 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 — Wed, 27 Sep 2017 09:51:53 GMT

Hello Sir,

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

Kurt_Bremser — Wed, 27 Sep 2017 09:54:32 GMT

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 — Wed, 27 Sep 2017 10:01:04 GMT

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

Kurt_Bremser — Wed, 27 Sep 2017 11:01:09 GMT

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-data-AKA-generate/ta-p/258712), so we can get an idea how to compare them. Reduce number of observations, if necessary.