08-29-2016 09:28 AM
08-29-2016 09:31 AM
- 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.
09-27-2017 05:54 AM
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.
09-27-2017 07:01 AM
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.