Date: Tue, 14 Dec 2004 14:25:34 -0800
Reply-To: David Fickbohm <DavidF@HOMEGAIN.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: David Fickbohm <DavidF@HOMEGAIN.COM>
Subject: SAS Data into a formatted Excel workbook
Content-Type: text/plain; charset="iso-8859-1"
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
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
Data Mining Analyst
2450 45th St.
Emeryville, CA, 94608
Phone 510 655 0800 ext 4151