Hello,
I'm having an issue with this code:
%IF &SAVE_OUTPUT. = Y %THEN %DO;PROC SQL _METHOD UNDO_POLICY=NONE;CREATE VIEW &TABLES_SAVE_PATH_LIBNAME..PnC_Quote_Central ASSELECT MAT.*,MAIN.*FROM &TABLES_SAVE_PATH_LIBNAME..SUBMISSION_MATURITY_TABLE (WHERE=(MATURITY_GROUP='Ultimate')) MATLEFT JOIN &TABLES_SAVE_PATH_LIBNAME..SUBMISSION_MAIN_TABLE MAINON MAT.AGREEMENT_NUMBER=MAIN.AGREEMENT_NUMBERUSING LIBNAME &TABLES_SAVE_PATH_LIBNAME. "&TABLES_SAVE_PATH.";QUIT;%END;
@samlac wrote:
Thank you for the quick reply. By curiosity, would there be a way to do it with a Dataset? By your answer, I understand that the limitation comes from SQL.
No. The physical location of a dataset is determined through the library assignment, no matter where in SAS you use them.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: