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
- 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.
Hello Sir,
Could you please provide the complete code for comparing two excels ?
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.
My two excel file has been imported. I am not sure about my next step of code..
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.