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
;
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and save with the early bird rate—just $795!
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.