How do I Compare the frequency of values for specific variables from two tables

[runningjay]

I'm a SAS EG user and have limited experience with direct SAS programming. I'm currently using SAS EG version 8.2 Update 1 (8.2.1.1223). I would like to accomplish this project in SAS EG if possible.

I have two tables with the same variables and I would like to compare the two tables. Each table has the same 50 variables.

I would like to compare the frequency of values for 28 of the variables shared between the two tables by showing the total frequency for each value within those variables in each table. Additionally, I would like to see the percent change in those frequencies between the two tables.

Is this possible in SAS EG?

Any guidance is appreciated - Thanks.

[Reeza · Accepted solution]

Yes it's possible. It's not possible to do it in one step though, using EG tasks. 

1. Create a summary table for table 1 - use a task, store it to a dataset

2. Create a summary table for table 2 - use a task, store it to a dataset

3. Merge the two data sets by the common key variable, your category. Use Query Builder here

4. Create a computed column that will calculate the difference. Either use Query Builder again or modify your code from Step #3.

[runningjay]

Thanks for the insight and the steps on how to do this. I appreciate the help.