topic Re: using LRECL=54 in import in SAS Programming

using LRECL=54 in import

Ronein — Mon, 11 May 2020 14:57:33 GMT

Hello

What is the meaning of using "LRECL=54 recfm=f;" in infile statement when I import a file?

Kind regards

Joe

Re: using LRECL=54 in import

ghosh — Mon, 11 May 2020 15:00:50 GMT

Fixed length (f) 54 bytes record size

Re: using LRECL=54 in import

Tom — Mon, 11 May 2020 15:02:44 GMT

Did you read the documentation? https://documentation.sas.com/?docsetId=lestmtsref&docsetTarget=n1rill4udj0tfun1fvce3j401plo.htm&docsetVersion=9.4&locale=en

The LRECL is the Logical Record Length. How many bytes per line (record).

The RECFM is the RECord ForMat. How each line is store.

54 means 54 bytes.

F means each record is Fixed length.

So in your file every 54 bytes is a record. So you a binary file (although all of the bytes might normal characters) instead of a normal text file.

Re: using LRECL=54 in import

ballardw — Mon, 11 May 2020 15:13:35 GMT

Maybe looking at the results of this will give you a clue, change the drive to a path where you have read/write privileges:

data _null_;
   file 'd:\text.txt';
   input s :$20.;
   put s;
datalines;
234567890qwertyuiop
ghjkertyuuaddsakka
;
data example;
   infile 'd:\text.txt' lrecl=5 recfm=F;
   input @;
   str=_infile_;
run;

_infile_ is a special temporary SAS variable that holds the contents of the current input buffer.