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?
Also would want to remove blank lines between DATALINES: and ;, as shown below.
DATALINES;
"ALPHA",-3.64693629
"BETA1",-0.584778408
"BETA2",-0.808085584
;
cause you missed a semi colon?
data test;
Don't worry, it happened to me millions of time
Haikuo
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.
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;
Also would want to remove blank lines between DATALINES: and ;, as shown below.
DATALINES;
"ALPHA",-3.64693629
"BETA1",-0.584778408
"BETA2",-0.808085584
;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.
Find more tutorials on the SAS Users YouTube channel.