Thank you so much!
The TEST was created by ID-TYPE-CD-DATE (see below), so the way you describe should work. I was given the code with PROC SQL and data steps and asked to replace the data steps with PROC SQL.
proc sql;
create table TEST as
select id, type, cd, date, sub_id, type2, count(*) as cnt
from indsn
group by 1,2,3,4,5,6
order by 1,2,3,4,5,6 ;
quit;
Another question, how to just simply rewrite the PROC SORT NODUPKEY data=... to PROC SQL to remove the dup?
proc sql;
create table TEST as
select id, type, cd, date, sub_id, type2, status, dollar, amt
from indsn a1,
indsn2 a2
where a1.id = a2.id and
a1.type = a2.type and
a1.cd = a2.;
quit;
proc sort data=TEST NODUPKEY; by id type cd; run;
... View more