Hi all, I am connecting to my Oracle SQL schema using SAS Enterprise Guide. Once I have my SQL datasets into SAS (total of 8 datasets), I want to call all the datasets, individually, into the Work library. I am writing the code below to bring in one dataset into Work library at a time: DATA WORK.DATASET_1; SET MYSQL.DATASET_1; RUN; DATA WORK.DATASET_2; SET MYSQL.DATASET_2; RUN; . . . DATA WORK.DATASET_8; SET MYSQL.DATASET_8; RUN; I have tried the following macro: %MACRO ST (DS); PROC SORT DATA = MYSQL.&DS OUT=WORK.&DS; BY PRIMARY_ID; RUN; %MEND; %ST(DATASET_1); %ST(DATASET_2); %ST(DATASET_3); %ST(DATASET_4); %ST(DATASET_5); %ST(DATASET_6); %ST(DATASET_7); %ST(DATASET_8); This takes a very long to run as the datasets are large and they are being sorted. Is there a way to bring in the datasets into Work library (individual datasets) using a macro without using proc sort? Thank you for the help!
... View more