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
;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.