Prev: Russian Characters in SAS
Next: UPDATE power analysis using SAS proc mixed
From: JT on 7 Jun 2010 14:39
I have an Excel sheet with dollar amounts that I'm importing into
SAS. The column is not formatted in Excel, so the numbers like
$135.35 show as 135.35 and numbers like $110.00 show as 110.

For some reason, when SAS imports the data set, it assumes that I made
a mistake and left out a decimal in the 110. So, it imports it as 1.1
instead of 110.

I've seen this happen with other data sets that I've imported.

Is there some setting that causes this or is it just a bug?

Thanks!

Jonathan
 | 
Pages: 1
Prev: Russian Characters in SAS
Next: UPDATE power analysis using SAS proc mixed