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!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.