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!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.