Help using Base SAS procedures

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

Accepted Solution Solved
Reply
Regular Contributor
Posts: 152
Accepted Solution

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

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


Accepted Solutions
Solution
‎02-10-2016 12:03 AM
Super User
Posts: 5,437

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

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.
Data never sleeps

View solution in original post


All Replies
Solution
‎02-10-2016 12:03 AM
Super User
Posts: 5,437

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

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.
Data never sleeps
Regular Contributor
Posts: 152

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

solved, thanks
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 266 views
  • 0 likes
  • 2 in conversation