Account Department (NNPC)
Date: Tue, 18 Feb 2003 09:18:27 +0000
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
Subject: Re: Importing from Excel
Content-type: text/plain; charset=us-ascii
In Excel the position of a number in general format tells you whether the
number has been entered as a number (right) or text (left). My personal
favourite is to add zero to every cell. Copy any empty cell then use Edit
-> Paste special -> Add. True text values and numbers are unaffected.
Blank/missing cells are preserved. Numbers entered as text are converted to
"Carey G. Smoak"
<carey.smoak@ROC To: SAS-L@LISTSERV.UGA.EDU
HE.COM> cc: (bcc: David Mcnulty/GB/QUES/ICI)
Sent by: "SAS(r) Subject: Importing from Excel
to "Carey G.
I have a program that imports data from Excel to SAS. Here is the code:
proc import out=test99
proc print data=test99;
The Excel file looks like:
The cells with an asterisk are left justified and the cells without an
asterisk are right justified. The cell format in Excel is "general."
The problem that I am having is that when I import the data from Excel to
SAS, the cells with an asterisk are blank in SAS. For example, *0.842 is
not blank in SAS.
Any suggestions on how to correct the problem? Thanks in advance for your
This email is confidential, may be legally privileged, and is for the
intended recipient only. Access, disclosure, copying, distribution, or
reliance on any of it by anyone else is prohibited and may be a criminal