extract the data from oracle which is having more than 1024 byt in to SAS

[deleted_user]

Hi,

If i extract the oracle table into SAS which is having more than 1024 bytes in one observartion which is truncated into SAS. i want the data as it is in oracle table in to SAS.

[Gaurav]

You may try using the LRECL system option to increase the value.

http://support.sas.com/documentation/cdl/en/lrdict/59540/HTML/default/a003160472.htm


It helps in holding the whole record.

[deleted_user]

Hi,
I don't think you should get the problem of getting the data truncated
while creating the sas dataset from a oracle table. There is no
restriction on the record length while creating the dataset.
Try working on the code below.

libname libref 'SAS-data-Library';
proc sql;
connect to oracle ( user=oracle_id orapw=oracle_passwd
path="@t:oracle_server:oracle_sid");
//create and select statement;
disconnect from oracle;
quit;


If the problem is not solved try setting LRECL option for the record
length of the datasets as stated by Gaurav.


Thanks & Regards,
Saurabh.