SAS Dataset Size Showing 10 times bigger in oracle

[Son_Of_Krypton]

Hi There,

I have sas dataset which has size around 2GB but after appending data to oracle it's showing 11GB size of same table in oracle.

Can somebody help me with this issue.?? 

[andreas_lds]

Hardly possible to suggest something useful with that little information you have provided. Start by posting proc contents of the dataset you append.

[ballardw]

By "appending" do you mean you took data from SAS and appended to an existing table in Oracle?

If so, what are the properties of the variables in the Oracle table? Compare the Proc Contents for the SAS data set.

If SAS data set has text variable with 10 characters (length 10) and the data is "appended" to a field that in Oracle is set to hold 50 characters there may be some extra space used in Oracle because of the setting.

SAS numeric variables typically are 8 bytes. So if you append them to an Oracle field that is set to use higher precision then more space is used in Oracle.

If a SAS variable is a Date, that is a numeric variable. I have no idea how Oracle stores dates and times but that is another potential issue where converted data in Oracle may take more space.

Not a specific to SAS/Oracle issue. I ran into similar behavior with SPSS and Microsoft Access.

[Sajid01]

Hello @Son_Of_Krypton 
I see from your question that you are "appending data to oracle ".
Are you appending data to an existing oracle table OR creating a new table and adding data to it?
Looks like  you have created a connection to oracle using libname statement and performing the append, please note that in proc append the table attributes will correspond to the attributes of the base table.

[LinusH]

I think you need to work closely with your Oracle DBA to understand these issues.