topic How can I pull second field from the sql nesting query in SAS Programming

How can I pull second field from the sql nesting query

Stalk — Fri, 22 Oct 2021 18:02:01 GMT

Select nid, date_p, accession from table1

where accession in(select distinct accession from table2).

I also want to pull pid field along with accession field from table2.

What is the best way?

Thank you

Re: How can I pull second field from the sql nesting query

PeterClemmensen — Fri, 22 Oct 2021 18:08:24 GMT

Something like

select a.nid
      ,a.date_p
	  ,a.accession as a_accession
	  ,b.pid 
	  ,b.accession as b_accession
from table1 as a, table2 as b_accession
where a.accession = b.accession

Re: How can I pull second field from the sql nesting query

Stalk — Fri, 22 Oct 2021 21:59:55 GMT

Thank you. It worked