topic Re: why do I lose information when I use compress=yes data option to load a table from orcale databa in SAS Procedures

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

gyambqt — Mon, 08 Feb 2016 05:54:34 GMT

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

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

LinusH — Mon, 08 Feb 2016 07:14:36 GMT

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.

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

gyambqt — Wed, 10 Feb 2016 05:04:00 GMT

solved, thanks