05-17-2016 11:50 AM
I have a very large table which I would like to query on a regular basis, based on several parameters that I predefine. For example, I can identify:
Which then retrieves me the data for a specific cell following the parameters (coordinates) identified, making use of the code below:
CREATE TABLE QUERY_OUTPUT AS
FROM LARGE_TABLE t1
WHERE t1.TABLE_ID ='T1' AND t1.X ='10' AND t1.Y ='05';
However I would like to replace those parameters (in bold) by an excel table(s)/vectors, which can be imported into a SAS dataset(s) and be used as parameters for the query.
Table_ID X Y
T1 10 05
T2 15 10
... ... ...
Can somebody help me finding a solution for this?