Dear community,               I have 2 huge datasets with millions of records. I want to simulate that in this small example.  I have dataset AA & BB. I want to get unique records (no duplicates) when I merge these two datasets with ID field. and I also want get the records whose age is greater than or equal to 60 years (even with duplicates whose age is greater than or equal to 60). If there are any other lower age with 60 years then I don't want to see them (like BB dataset has ID 'D' which has age of 60 & 59).  Data AA; Input ID Name$ Height age; cards; 1 A 1 30 3 B 2 40 5 C 2 50 7 D 2 60 9 E 2 70 ; run; Data BB; Input ID Name1$ height1 age1; cards; 1 A 1 30 3 B 4 40 3 B 2 40 5 C 2 50 5 C 2 50 5 C 2 50 7 D 2 60 7 D 2 60 7 D 2 59 9 E 2 70 9 E 2 70 ; run; PROC SQL; CREATE TABLE LOOK AS SELECT A.*, B.* FROM AA AS A INNER JOIN BB AS B ON A.ID=B.ID ; QUIT; DATA ONE TWO; SET LOOK ; BY ID; IF AGE >= 60 and age1 >=60 THEN OUTPUT ONE; ELSE IF FIRST.ID AND LAST.ID THEN OUTPUT ONE; ELSE OUTPUT TWO; RUN; The desired output should look like below.  ID Name Height age Name1 Height1 age1 1  A        1          30    A          1           30 9  E        2         70     E          2          70 9  E        2         70     E          2          70 Any help is much appreciated. Thanks in advance.    ... View more

Guys, I have building a report as shown below. Can anyone help me to obtain that?  data cars (DROP=MODEL); set sashelp.cars; run; PROC SQL; CREATE TABLE HAVE AS SELECT make,origin,type,drivetrain,Cylinders,enginesize,MSRP,invoice,horsepower, WEIGHT,WHEELBASE,LENGTH FROM CARS WHERE MAKE='Audi' GROUP BY MAKE,ORIGIN,TYPE,DRIVETRAIN,CYLINDERS order by MAKE,ORIGIN,TYPE,DRIVETRAIN,CYLINDERS ; QUIT; I want my output to look like this either in SAS or excel (prior to proc export step).   Thanks in advance ... View more