topic Data existence in a table in SAS Programming

Data existence in a table

aloou — Tue, 19 Apr 2022 09:19:17 GMT

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

Re: Data existence in a table

Patrick — Tue, 19 Apr 2022 10:29:00 GMT

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.

Re: Data existence in a table

Sajid01 — Tue, 19 Apr 2022 15:37:42 GMT

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.