topic Re: Proc compare : creating table only for different values in SAS Procedures

Proc compare : creating table only for different values

kajal_30 — Fri, 21 Jun 2019 04:04:12 GMT

Hi,

I am using Proc compare and want to create a table which has all the diff values only for column

eg: we have a

table_1 with columns: A,B,C,D,E

table_2 with columns : A,B,C,D,E

output_table should have A,B,C,D,E (comparing table_1 and table_2 only for variable B and D)

Hope this helps

Thanks

Kajal

Re: Proc compare : creating table only for different values

PeterClemmensen — Fri, 21 Jun 2019 05:59:34 GMT

"comparing table_1 and table_2 only for variable B and D". What does this mean? What observations would output_table contain?

Re: Proc compare : creating table only for different values

ballardw — Fri, 21 Jun 2019 15:30:16 GMT

The VAR statement restricts which variables are compared. So I suspect you may be looking for

VAR B D;

I am not sure if by "output table" you mean a data set or not.

Re: Proc compare : creating table only for different values

kajal_30 — Sun, 23 Jun 2019 05:04:48 GMT

Yes, I am referring to data set. My concern is if I put var then it will give me comparison for the columns in Var statement but it will exclude rest of the columns from out put which I need.

Comparing data set only for one column retaining all other columns in the output.

Thanks

Kajal

Re: Proc compare : creating table only for different values

ballardw — Mon, 24 Jun 2019 16:17:15 GMT

@kajal_30 wrote:

Yes, I am referring to data set. My concern is if I put var then it will give me comparison for the columns in Var statement but it will exclude rest of the columns from out put which I need.

Comparing data set only for one column retaining all other columns in the output.

Thanks

Kajal

I suspect we are having issues if English is not your native language. The above sort of contradicts your original problem description.

output_table should have A,B,C,D,E (comparing table_1 and table_2 only for variable B and D)

which says you only want to compare B and D.

Best at this point would be to provide small examples of data sets table_1 , table_2 and what the desired output should look like for those examples. Provide examples of the kind of matches/ difference you expect to see. Each set should likely only need 10 or 15 rows of data. Provide the data as data step code such as:

data table_1;
  input a b c d e;
datalines;
1 2 3 4 5
2 3 4 5 6
;

Test the code to make sure that it creates data sets. Then Paste the code into a code box opened with the {I} or "running man" icons at the top of the forum message box to preserve correct formatting so the code runs. The message windows on this forum will reformat text and sometimes code pasted in the main windows will not run as pasted and reformatted.