BookmarkSubscribeRSS Feed
deleted_user
Not applicable
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.
2 REPLIES 2
Gaurav
Calcite | Level 5
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
Not applicable
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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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