From: saurabh modi on
Hello Group

I made some changes but It is filling up all the rows .


%ExcelCreate( dsn1=,dsn2=xyz);
some code ......
put '[select("c1:c6")]';
put '[formula("=mod(row(),2)=1")]';
put '[patterns(1, ,15)]';
put '[select("r1c1")]';
put '[SAVE.AS("c:\tempo\Bits' "&dsn2..xls" '")]';
put '[QUIT()]';
run;
%mend;

Any suggestion or thoughts where I am wrong ?


Thanks

Sunny