topic Re: reading data from DATALINES vs reading data from external file in SAS Programming

reading data from DATALINES vs reading data from external file

Dennis_K — Fri, 20 Jul 2018 07:27:43 GMT

the output from the following program

DATA TEST;
INFILE datalines ;
INPUT Pname $10.;
datalines;
FABINHO
NABY KEITA
ALISSON
SHAQIRI
;
run;

produces

                               Obs      Pname

                                1     FABINHO
                                2     NABY KEITA
                                3     ALISSON
                                4     SHAQIRI

However , if i were to read these data from the external files it produces the following

                              Obs      Pname

                                1     NABY KEITA
                                2     SHAQIRI

Any ideas how SAS read the data ?

Re: reading data from DATALINES vs reading data from external file

s_manoj — Fri, 20 Jul 2018 07:30:43 GMT

Kindly out the code that you have used to read external data

Regards
manoj

Re: reading data from DATALINES vs reading data from external file

Kurt_Bremser — Fri, 20 Jul 2018 07:37:26 GMT

datalines are automatically padded to 80 characters.

Use the truncover option in the infile statement when reading from external files that can have shorter records than the code expects.

Re: reading data from DATALINES vs reading data from external file

Dennis_K — Fri, 20 Jul 2018 07:41:20 GMT

DATA TEST;
INFILE 'test.txt' ;
INPUT Pname $10.;
run;

Re: reading data from DATALINES vs reading data from external file

Kurt_Bremser — Fri, 20 Jul 2018 07:43:02 GMT

DATA TEST;
INFILE 'test.txt' truncover;
INPUT Pname $10.;
run;

and you're done.

Re: reading data from DATALINES vs reading data from external file

Dennis_K — Fri, 20 Jul 2018 08:19:24 GMT

I was testing the behavior of the default option FLOWOVER.

it seems like there is a difference in reading from DATALINES and external file

Re: reading data from DATALINES vs reading data from external file

s_manoj — Fri, 20 Jul 2018 08:24:23 GMT

DATA TEST;
INFILE 'test.txt' ;
INPUT Pname & $10.;
run;

may be this could work

Regards

Manoj

Re: reading data from DATALINES vs reading data from external file

Kurt_Bremser — Fri, 20 Jul 2018 08:34:34 GMT

@Dennis_K wrote:

I was testing the behavior of the default option FLOWOVER.

it seems like there is a difference in reading from DATALINES and external file

As I already said in a previous post, datalines are automatically padded to 80 characters, so you don't get an overflow event. That's all.

Re: reading data from DATALINES vs reading data from external file

Dennis_K — Fri, 20 Jul 2018 09:49:42 GMT

Cheers