Hi,
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:
Table: T1
Column 10
Row 05
Which then retrieves me the data for a specific cell following the parameters (coordinates) identified, making use of the code below:
PROC SQL;
CREATE TABLE QUERY_OUTPUT AS
SELECT
t1.VALUE_DECIMAL,
t1.TABLE_ID,
t1.X,
t1.Y
FROM LARGE_TABLE t1
WHERE t1.TABLE_ID ='T1' AND t1.X ='10' AND t1.Y ='05';
QUIT;
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.
Something like:
Table_ID X Y
T1 10 05
T2 15 10
... ... ...
Can somebody help me finding a solution for this?
Thank you.
Fernando
Hi Linus,
Can you elaborate a litle bit more on that?
Do you have an example of code that can guide me a litle bit?
thanks!
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.