This will not work in other SQL dialects, but in SAS SQL I think you can get away with this:
PROC SQL;
CREATE TABLE WORK.Experiment_VOLT AS
SELECT
t1.ExperimentID,
t1.STATION,
t2.TYPE,
t2.TIMESTAMP,
t2.VALUE,
t1.TESTRESULT,
t2.ADDRESS
FROM WORK.Experiment t1
INNER JOIN WORK.DATA_FILTERED t2
ON (t1.ExperimentID = t2.ExperimentID)
WHERE TYPE = 'A42' OR TYPE ='AC'
group by t1.ExperimentID
having count(distinct t2.TYPE)=2
ORDER BY t1.ExperimentID, t2.TIMESTAMP;
QUIT;
... View more
