A data engineer uses PROC CASUTIL to copy a table from one caslib to another in SAS Viya. Which statement correctly copies table 'SALES' from caslib 'WORK' to caslib 'MYLIB'?
Select an answer to reveal the explanation.
Short Explanation
Here's the deal — PROC CASUTIL's COPY statement with TABLE=, INCASLIB=, and OUTCASLIB= is what you use to copy a CAS table from one caslib to another. PROMOTE only changes scope, and PROC COPY works with SAS libraries, not CAS caslibs.
Full Explanation
PROC CASUTIL's COPY statement with TABLE='SALES', INCASLIB='WORK', and OUTCASLIB='MYLIB' is correct because it copies a CAS table from one caslib to another. The PROMOTE statement with TARGETCASLIB='MYLIB' is wrong because PROMOTE changes a table's scope within a caslib, such as local to global, not between caslibs. The DROPTABLE/ADDTABLE statement is fabricated syntax. PROC COPY with IN=WORK, OUT=MYLIB, and SELECT SALES is wrong because PROC COPY copies SAS libraries on disk, not CAS caslibs.