topic How do I Compare the frequency of values for specific variables from two tables in SAS Enterprise Guide

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

runningjay — Fri, 15 May 2020 15:26:09 GMT

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.

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

Reeza — Fri, 15 May 2020 15:32:25 GMT

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.

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

runningjay — Wed, 27 May 2020 20:05:02 GMT

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