topic Re: extract the data from oracle which is having more than 1024 byt in to SAS in SAS Procedures

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

deleted_user — Wed, 18 Feb 2009 05:39:49 GMT

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.

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

Gaurav — Wed, 18 Feb 2009 12:19:50 GMT

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.

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

deleted_user — Fri, 20 Feb 2009 07:11:35 GMT

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.