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
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
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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.