Help using Base SAS procedures

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

Reply
N/A
Posts: 0

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

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.
New Contributor
Posts: 2

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

Posted in reply to deleted_user
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.
N/A
Posts: 0

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

Posted in reply to 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="@tSmiley Surprisedracle_serverSmiley Surprisedracle_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.
Ask a Question
Discussion stats
  • 2 replies
  • 118 views
  • 0 likes
  • 2 in conversation