topic Re: datelines statement returning incomplete result in SAS Programming

datelines statement returning incomplete result

frupaul — Wed, 03 Jul 2019 10:48:45 GMT

Hi everyone,

I am trying to create a field - channel - which holds all the values below the datalines statement in the code below.

data Testing;
   infile datalines;
   input Channel :$30.;
cards;
C&TM With All
Rebroke
J&T Appliance
;

I am expecting the first record of channel to be 'C&TM With All', but it appeasrs truncated as in below:

What can i do to avoid this truncation?

Thanks,

Paul

Re: datelines statement returning incomplete result

PeterClemmensen — Wed, 03 Jul 2019 10:52:21 GMT

Remove the colon 🙂

data Testing;
   infile datalines;
   input Channel $30.;
cards;
C&TM With All
Rebroke
J&T Appliance
;

Re: datelines statement returning incomplete result

Kurt_Bremser — Wed, 03 Jul 2019 11:11:31 GMT

And if you want to avoid skipping over short lines when applying @PeterClemmensen 's solution to an external file, add the truncover option to the infile statement.