Date:         Tue, 14 Dec 2004 16:32:29 -0600
Reply-To:     "Dunn, Toby" <Toby.Dunn@TEA.STATE.TX.US>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Dunn, Toby" <Toby.Dunn@TEA.STATE.TX.US>
Subject:      Re: SAS Data into a formatted Excel workbook
Comments: To: David Fickbohm <DavidF@HOMEGAIN.COM>
Content-Type: text/plain; charset="US-ASCII"

David,

Funny I can't reproduce the problem.  Is there a way you could show us
the code you used to transform the missing to 0.

Toby Dunn

"It's OK to figure out murder mysteries, but you shouldn't need to
figure out code. You should be able to read it." -Steve C McConnell



> -----Original Message-----
> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On
> Behalf Of David Fickbohm
> Sent: Tuesday, December 14, 2004 4:26 PM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: SAS Data into a formatted Excel workbook
>
>
> People,
> I am working in a windows environment.  I have SAS 8.1.    I
> have a sas
> dataset where I have replaced the missing values with zeroes
> as the user requests.  The problem is when I export that sas
> dataset with zeroes into excel 2003 it get blanks instead of zeroes.
>
> Am I correct in saying I will have to create a spreadsheet
> formatted with zeroes in the area where data will reside and
> then move my SAS data into that excel 2003 spreadsheet using
> DDE or something like that ?
>
> I think I am correct, but I thought I would ask SAS-L prior
> to starting this process.
>
> The sas dataset is very small, about 38 rows including
> headings so we are not talking about a huge dataset.
>
> Thanks in advance for any thoughts, ideas, just plain "Yeah
> you are correct that is what you have to do, good luck".
>
> I am sure there are many excellant SUGI papers on this, so it
> should not be horrible.
>
> Dave
>
> Dave Fickbohm
> Data Mining Analyst
> Homegain+
> 2450 45th St.
> Emeryville, CA, 94608
> Phone 510 655 0800 ext 4151
>