why do I lose information when I use compress=yes data option to load a table from orcale database

[gyambqt]

Hello experts,

I am trying to load a table from Orcale database into SAS table and I have used compress=yes during the loading process

the SAS table I have got has many blank columns which it shouldn't be.

my code is somehow like below:

proc sql;

connect to oracle(...)

create table A (compress=yes)  as

select * from connection to oracle(

select * from ....);

disconnect from orcale;

quit;

Thanks

[LinusH · Accepted solution]

Compress should not affect any values in your target table. Confirm what values are missing and shouldn't be. What are their data types? (SAS/Oracle). Perhaps you could join back the rows with missing values and do a comparison.

[gyambqt]

solved, thanks