Yes this code worked. Thanks. But can I use multiple datasets in place of File2? ... View more

Data file1; Set one; Input prsnid $ ; Datalines; 11 12 13 14; run; Data file2; Set two Input prsnid $ gracedate yymmdd10.; Datalines; 11 2020-12-31 12 2020-12-31 14 2020-01-01; run; I need to report prsnid=13 in excel sheet because that is missing from second dataset ... View more

Data file1; Set one; Input prsnid $ ; Datalines; 11 12 13 14; run; Data file2; Set two Input prsnid $ gracedate yymmdd10.; Datalines; 11 2020-12-31 12 2020-12-31 14 2020-01-01; run; I need to report prsnid=13 in excel sheet because that is missing from second dataset ... View more