MVSFORUMS.com

[hibusalim]

hi,

can anyone help me in resolving this query..

proc sql;
create table a1q3 as
select
a.taxid_no,
q3.seqno,
q3.cdist
from CENSUSFL a, q3seg q3
where a.taxid_no = q3.empno
order by a.taxid_no, q3.seqno;
quit;
run;

proc sql;
create table q3top as
select
aq1.taxid_no,
aq1.seqno,
aq1.cdist
from a1q3 aq1
where
aq1.seqno = (select max(aq2.seqno)
from a1q3 aq2
where aq2.taxid_no = aq1.taxid_no)
order by aq1.taxid_no;
quit;
run;



This is a DB2 query..

Thanks,
Hibu Salim

[kolusu]

Hibusalim,

Why are you opening the seperate topics for the same question? I have deleted your duplicate post an hour ago and you once again post the same question. Your question has been answered . Check this link

http://www.mvsforums.com/helpboards/viewtopic.php?t=3504

If you continue to do this you will loose your privileges of posting on this board.

I am locking this topic

Thanks

kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu