topic Re: SAS datalines not reading properly in SAS Data Science

SAS datalines not reading properly

eagles_dare13 — Wed, 23 Jul 2014 19:44:39 GMT

When I run:

data test

INFILE DATALINES DSD;

INFORMAT varname $32.;

INPUT varname $ var1;

DATALINES;

"ALPHA",-3.64693629

"BETA1",-0.584778408

"BETA2",-0.808085584

;

run;

Why do I get 3 blank records as output?

Re: SAS datalines not reading properly

Haikuo — Wed, 23 Jul 2014 19:48:13 GMT

cause you missed a semi colon?

data test;

Don't worry, it happened to me millions of time

Haikuo

Re: SAS datalines not reading properly

eagles_dare13 — Wed, 23 Jul 2014 19:55:55 GMT

Thanks. I changed the example slightly and it still does not work after putting semi colon.

data test;

INFILE DATALINES DSD ;

INFORMAT varname $32.;

INPUT varname $ var1 var2 var3;

DATALINES;

"test",,,1

"test",,624.5,1

"test",624.5,741.5,2

;

run;

Does not work as in only some fields are being read...not all.

Re: SAS datalines not reading properly

Bryan — Wed, 23 Jul 2014 19:58:08 GMT

Also would want to remove blank lines between DATALINES: and ;, as shown below.

DATALINES;

"ALPHA",-3.64693629

"BETA1",-0.584778408

"BETA2",-0.808085584

;

Re: SAS datalines not reading properly

Haikuo — Wed, 23 Jul 2014 20:01:08 GMT

Works for me:

data test;

INFILE DATALINES DSD ;

INFORMAT varname $32.;

INPUT varname $ var1 var2 var3;

DATALINES;

"test",,,1

"test",,624.5,1

"test",624.5,741.5,2

;

run;