Working : proc sql; select count(*)into:cnt from dataset_name; quit; %put &cnt; %macro sep(); %do j=1 %to &cnt %by 800000; %let last=%eval(&j+799999); %put &j &last ; proc export data=dataset_name(firstobs=&j obs=&last) outfile="D:\required_path\workbook_name.xlsx" dbms=xlsx replace; sheet="A&j"; run; %end; %mend; %sep;
... View more