So, could you please advise how you would do it, this task seems to be very easy but I am still struggling to find an answer! ... View more

I checked the results and everything is the same except in one dataset the variable has "format" and "informat", but the other does not.        ... View more

Thank you so much, your answered worked for the sample datasets. But when I applied the code for the real datasets, I received the error below:   ERROR: Expression using equals (=) has components that are of different data types.   for on a.id=b.id;   I had checked the data types and both variables are character with the same length !   Could you please advise? ... View more

Thank you, but how using ID statement gives me observation summary? (I tried and it only gives variable summary!). Please help ... View more

DATA1:   ID  A  B 8    .   . 9    .   .     DATA2:   ID C  D 1   5  6 2   7  8 3   9  3 4   6  6   proc compare base = data1 compare=data2; var ID; with ID; run;     Why after running the program, in the observation summary it says: Number of Observations in Common: 2  ?!!   Although, we don't have any common observation in varibale ID. Right?     Thank you       ... View more

what I want is just a simple comparison based on how many variable ID is matched in both datasets. No specific requirement.   Thanks ... View more

I used just a simple Merge statement:   data dataset3; merge dataset1 dataset2; by Variable1; run; ... View more

None of those "And had several suggestions and links to solutions." were useful. By the way, I don't want a full code and exact solution to my problem. I am re-posting my question so that new people/users can easily follow and read my question and give me some hints. ... View more

Although there are millions of rows, it is not going to generate hundreds of columns. Because, the number of Variable2 values (categories) are limited; it is probably about 10 . So it means that I am going to have 9*2 = 18 new expanded columns.   Again, the purpose is to use this file to merge with another dataset. It makes it easier to review the databse once I have only unique Variable1 values in 1st column.    Thank you ... View more

I put another example, and I hope its more clear now. Thank you for help ... View more

Let me put it this way (another example):   Variable1    Variable2    Variable3         1                  W                 3.2      1                  X                  5.1      2                  X                  7.0      3                  E                  8.9      3                  W                 1.3   Whenever, the Variable2 corresponding to Variable1 (ID) is changing its value, we would like to expand it to new columns. In fact per each new category (based on Variable2), two new columns are added to the right:   Variable1   Variable2    Variable3   Variable4   Variable5      1                W                3.2              X               5.1      2                X                 7.0             null            null      3                E                 8.9             W               1.3     PURPOSE: At the end, we are interested to have a unique Variable1 in first column; and the corresponding category(ies) are expanded to the right instead of stacking on top of eachother.   I hope its more clear now. Thank you for help ... View more