Prev: Russell Investments has a Sr. SAS Developer/Business Analyst opening for Seattle
Next: Do loops in SAS
From: Sunny on 16 Jun 2010 14:31

How to apply a alternate color pattern on rows in excel sheet ?

Here what I'm trying to do .

%ExcelCreate( dsn1=,dsn2=xyz);


some code ......

put '[select("c1:c6")]';
put '[formula("=mod(row(),2)=1")]';
put '[format.pattern("automatic")]';
put '[select("r1c1")]';
put '[SAVE.AS("c:\tempo\Bits' "&dsn2..xls" '")]';
put '[QUIT()]';
run;


%mend;
 | 
Pages: 1
Prev: Russell Investments has a Sr. SAS Developer/Business Analyst opening for Seattle
Next: Do loops in SAS