Data existence in a table

[aloou]

hello everyone,

i have a column containing ID , and a big table containing ID too.

How can i check if a list of ID exist or not in the big table, using sas viya.

Many thanks

[Patrick]

A SAS data step hash lookup loading the small table into the hash table is one way to go. Just make sure that you execute the process in the place where the big table exists - like if the big table is in CAS then make sure that you also load the small table into CAS prior to the hash lookup.

[Sajid01 · Accepted solution]

If your intention is to check the existence of the ID's from small table in the big table you can try the following Proc SQL.

Proc sql;
Select  id from big_table
where id in (Select id from small_table);
quit;

This may not be the best approach but easy to understand and use.