Wow!! Congratulation... I was eagerly waiting for the result.  Great news 🙂  ... View more

As you have defined RUNDATE macro variable, similarly you need to define T1   For example %LET T1=COL1; ... View more

I tried it but its not working data Have1; length ID $20.; input ID $ age; datalines; 10000_John 25 10001_Andrew 24 10002_Sam 22 ; data have2; length ID $20.; input ID $ marks1 marks2; datalines; 10000 75 78 10001 58 89 10002 85 73 ; proc sql; create table want as select a.id, a.age,b.marks1, b.marks2 from have1 a, have2 b where index(a.id,b.id) = 1 ; quit; ... View more

I have created a macro to split data. It takes symbol root as an input and creates dataset with name as "Data_AA". Here AA is your symbol root. It will create separate dataset for every symbol root.   I have assume column name as SYMBOL_ROOT in testdata.          %macro split_data(_sym_root); %put symroot val = &_sym_root; proc sql; create table Data_&_sym_root. as select * from testdata where SYM_ROOT ="&_sym_root"; quit; %mend; filename Split temp; data _null_; set test_master; file split; put "%" "split_data(" SYMBOL_ROOT ");"; run; %inc Split;   Just for your knowledge Split file would have call to the macro something like this. %split_data(A ); %split_data(C ); %split_data(B );     You can add your analysis in %split macro or may be you may need to create separate macro with same kind of approach. ... View more

  Use Truncover option in infile statement to  read the thrid line as record number 3 ... View more