A SAS developer needs to join a SAS dataset in the SAS work library…

Question

A SAS developer needs to join a SAS dataset in the SAS work library with a CAS in-memory table. Which approach correctly accomplishes this in SAS Viya?

Accepted Answer

Both B and C are valid approaches but B is preferred for large datasets to leverage CAS parallel processing — Here's the deal — d is correct because both approaches are valid. B (loading the work dataset to CAS and joining in FEDSQL) leverages distributed CAS processing, which is preferred for large datasets.

Answer

Use PROC SQL with a JOIN between work.dataset and caslib.castable — SAS Viya automatically materializes both to a common location

Answer

First use PROC CASUTIL to load the SAS work dataset into CAS, then join two CAS tables using PROC FEDSQL

Answer

Use PROC DATASETS to copy the CAS table to the work library, then join two work library datasets

A SAS developer needs to join a SAS dataset in the SAS work library with a CAS in-memory table. Which approach correctly accomplishes this in SAS Viya?

Short Explanation and Infographic

Full Explanation