topic Re: Insert zero in the column (excel) in ODS and Base Reporting

Insert zero in the column (excel)

shru — Fri, 30 Mar 2012 15:56:19 GMT

Hi,

I need to put zero to the empty cells of an column in excel.

My code updates the the column of an excel with the some values but some rows will be empty which dont have values.

So how can i put zero's to the rows once i update my excel coulmn with figures.

I am using %openexcel;

and

put statement to put the values..

So how can i do it?

Thanks

OS2Rules — Fri, 30 Mar 2012 16:25:30 GMT

I use "option missing=0; " in my SAS code.

to default the missing data to 0 (zero).

Should work when writing to Excel.

shru — Tue, 03 Apr 2012 17:39:23 GMT

Hi,

My excel file is like this

obs Mar-12

1 56

2 34

4 .

5 .

6 .

7 78

8 12

like this.

My code is

data _null_;

file sas2xl;

put unquote(bquote("select(R&rowC&col)");PUT unquote(bquote("&value");

run;

like wise my code updates the excel,but for some there wont be a value so in that place i need to put zero

How can i do this?

Help me

Thanks