Hello, I am trying to combine imported datasets using macro but i get warning below WARNING: Multiple lengths were specified for the variable A by input data set(s). This can cause truncation of data.   Note that var A has different length format automatically assigned during the import procedure. below is my code. %macro combine; data c; set %do i = 1 %to 2; &library..&&file&i %end; ; run; %mend; %combine; ... View more

Hi, I want to know if it's possible to automate my proc sql step using macro. Below is my code but I am getting 2 datasets with same 'data a' content as result. I am supposed to have 2 different contents. Kindly help. %let sfile1 = a; %macro varsum (sfile1); proc sql; create table &sfile1. select *, sum(x) as z, from &file1 quit; %mend; /*calling the macro for the 2 datasets*/ %varsum(a); %varsum(b); below is my log 43 %varsum(a); NOTE: The query requires remerging summary statistics back with the original data. NOTE: Table WORK.a_SUM created, with 10 rows and 14 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.06 seconds cpu time 0.04 seconds 44 %varsum(b); NOTE: The query requires remerging summary statistics back with the original data. NOTE: Table WORK.b created, with 10 rows and 14 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.03 seconds cpu time 0.01 seconds ... View more