what is the use of LRECL option.

Answer Posted / solasa

LRECL= option—Specifies the logical record length, in bytes.

This option is used when the records in a file are
longer than 256 bytes (on ASCII platforms). The default
input buffer is 256 bytes.

Records that exceed this length are truncated when they are
read.

Setting the LRECL= option to a greater length ensures that
the input buffer is long enough for the entire record to be
read. This is usually not an issue on EBCDIC platforms
because the data control block specifies the logical record
length for SAS.

As shown in the following example, the LRECL=
statement option in an INFILE statement overrides the LRECL=
system option, if it is used.


infile 'C:\mydata\test.dat' dsd truncover lrecl=4096;

Is This Answer Correct ?    15 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

describe how to adjust the performance of data integrator? : Sas-di

564


what is the primary data source for the wrs? : Sas-bi

659


What is the function of Stop statement in a SAS Program?

645


Why double trailing @@ is used in input statement?

703


please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??

1667






How to create list output for cross-tabulations in proc freq?

623


how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming

843


How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?

1099


what is data governance? : Sas-di

625


what type of graphs we will create(for 2+years candidates)?

1906


Hello, I have PROC SQLs results group by 3 fields and I use SUM and COUNT functions in SQL. The problem is when I try to display my result with PROC TABULATE. I am getting very big numbers. I believe I make a mistake some where in Tabulate. Here is my Proc Tabulate. PROC TABULATE DATA=OUT04_05 FORMAT=12.; CLASS YR CENTRE VISA / PRELOADFMT EXCLUSIVE; VAR NEWUSER FRAUD TRANSFER AUTUSER REISSUE; TABLE CENTRE ALL, (YR ALL)*VISA, (NEWUSER*F=COMMA12. AUTUSER*F=COMMA12. FRAUD*F=COMMA12. TRANSFER*F=COMMA12. REISSUE*F=COMMA12.) / MISSTEXT={LABEL='0'} PRINTMISS RTS=20; FORMAT VISA VISAFMT.; KEYLABEL SUM = ' ' ALL = 'TOTAL'; LABEL YR = 'DATE YEAR' NEWUSER = 'TOTAL NEW ACCT' TRANSFER = 'TOTAL TRANSFER' FRAUD = 'TOTAL FRAUD TRANSFER' AUTUSER = 'TOTAL AUTH USERS' REISSUE = 'TOTAL REISSUE'; When I code it like : NEWUSER*N*F=COMMA12. AUTUSER*N*F=COMMA12. I get same amount numbers but to find a NEWUSER I use COUNT(*) and to find AUTUSER I use SUM(xxxx) function so both result shouldn’t be the same my problem is in this point. Could you tell me where the problem in code is. How can I display my result? TX.

1780


explain what is factor analysis? : Sas-administrator

602


Name and describe few sas character functions that are used for data cleaning in brief.

669


What is the basic structure of a sas program?

601


What is the difference between %local and %global? : sas-macro

669