topic Re: SAS Dataset Size Showing 10 times bigger in oracle in SAS Programming

SAS Dataset Size Showing 10 times bigger in oracle

Son_Of_Krypton — Thu, 18 Mar 2021 14:02:19 GMT

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.??

Re: SAS Dataset Size Showing 10 times bigger in oracle

andreas_lds — Thu, 18 Mar 2021 14:17:11 GMT

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

Re: SAS Dataset Size Showing 10 times bigger in oracle

ballardw — Thu, 18 Mar 2021 14:27:10 GMT

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.

Re: SAS Dataset Size Showing 10 times bigger in oracle

Sajid01 — Thu, 18 Mar 2021 15:20:04 GMT

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.

Re: SAS Dataset Size Showing 10 times bigger in oracle

LinusH — Fri, 19 Mar 2021 08:18:31 GMT

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