topic Re: get data set with 0 rows-why? in SAS Programming

get data set with 0 rows-why?

Ronein — Wed, 01 Jan 2020 09:29:48 GMT

Hello

Why do I get empty data set???

Please not that there is space between 655 and - and between - and 60039652

Data tbl;
input ID $100.;
cards;
655 - 60039652
;
Run;

Re: get data set with 0 rows-why?

Ksharp — Wed, 01 Jan 2020 10:36:58 GMT

The default max length of string in CARDS is 80 . try 80.

Data tbl;
input ID $80.;
cards;
655 - 60039652
;
Run;

Re: get data set with 0 rows-why?

novinosrin — Wed, 01 Jan 2020 17:50:36 GMT

Hi @Ronein You may have noticed a note "NOTE: SAS went to a new line when INPUT statement reached past the end of a line."
in the LOG. This is a default behavior of SAS when reading variable length records as to when SAS continues to read for the number of bytes provided by the width in the informat, which in your case is 100.

So what happens here is, SAS tends to do that and clears the input buffer leaving no values to read while attempting to read the next dataline. To override this default behavior, you need a TRUNCOVER in INFILE statement.

Example:

infile cards truncover;

Data tbl;
infile cards truncover;
input ID $100.;
cards;
655 - 60039652
;
Run

Re: get data set with 0 rows-why?

Kurt_Bremser — Wed, 01 Jan 2020 12:33:17 GMT

Maxim 2: Read the Log, as @novinosrin already pointed out.