BookmarkSubscribeRSS Feed
LineMoon
Lapis Lazuli | Level 10

Hello,

I observe that,

When you use "click on button import in sas  EG " to import  a .txt file.

  you will import the file and you will get the correct value,  when you look at the "sas log" of the import, we can observe in the file log

> LRECL=265, but the logical length to use for reading is more than 500.

Why sas EG makes a correct importation, but does not show in the log the right value of LRECL(here=500), but in the log, we see LRECL=265  ?

2 REPLIES 2
Sonywell
Fluorite | Level 6

Hi,

I believe you may have the 'Generalize this import step to run outside of Enterprise Guide' option set on the 4 page of the import data task wizard.  By default, this sets a maximum record length of 256.  This should be affecting the output of the import task though, causing a truncation of records.

Regards

Patrick
Opal | Level 21

In newer EG version the default appears to be set to 32767 - but you can of course always change it to the value you need.

Capture.PNG

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

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
  • 602 views
  • 0 likes
  • 3 in conversation