Hi I am trying to unload a table from memory in the caslib. For Develop SAS Code the code is ------------------ /*Connecting to EAPG Resale Daily caslib */ LIBNAME TEST cas caslib="TEST FOLDER" DATALIMIT=ALL; option DBIDIRECTEXEC; proc sql; drop table TEST.TEST_SORT ; quit; ----------------------------- Is it possible to use Prepare Data CASL option? ---------------- loadActionSet 'fedSql'; queryCode='drop table "'||_dp_inputCaslib||'"."TEST_SORT" {options force=true} '; print queryCode; ExecDirect / query=queryCode; ------------- I try to run the prepare data query, the error is TEST_SORT cannot be found under the caslib. Please help. Thanks.
... View more